A Wetpaint Site
Sign in to Wetpaint
Internet Explorer 6.0 is not supported. Please try
IE 8
or
Firefox
.
Home
Discussions
Photos
Videos
News
Updates
Droplets
Members
Sign in
or
scott/tiger
Page Versions
Key:
additions
deletions
Please select two page versions to compare - check the checkbox to the right of each version.
Showing 9 pages
Date/Time
Made By
Edit Note
Type
Scope
Compare
May 15 2008, 5:47 AM EDT
meuwiskl
edit
Change:
There were only format changes (bold, italics, etc.) in this version.
See this version for details.
(Word count: 163)
May 2 2008, 8:13 AM EDT
meuwiskl
added 2 links for demobld , demodrop
edit
20 words added
Change:
demonstration of newer database features.The following links discuss the new sample schemas in more detail. Following SCOTT/TIGEROracle's Sample Schemas: Saying Goodbye to Scott
Build oracle sqlplus demo table
To drop Scott you need to run the demodrop.sql script
More details here :
demodrop.sql
View changes from previous version.
(Word count: 163)
Jan 7 2008, 4:59 PM EST
jornica
edit
20 words added
Change:
the demobld script.Later versions has an additional demo schema called HR with password HR. This schema contains many additional database objects to allow demonstration of newer database features.
The following links discuss the new sample schemas in more detail.
Following SCOTT/TIGER
Oracle's Sample Schemas: Saying Goodbye to Scott
View changes from previous version.
(Word count: 142)
Jan 6 2008, 8:26 PM EST
rsriram
edit
1 word added
Change:
SQL>
ALTER USER SCOTT ACCOUNT UNLOCK;Oracle XE inexplicably doesn't have this classic account, but you can add the user yourself and fill it using the demobld script.Later versions has an additional demo schema called HR with password
View changes from previous version.
(Word count: 120)
Jan 6 2008, 8:26 PM EST
rsriram
edit
Change:
There were only format changes (bold, italics, etc.) in this version.
See this version for details.
(Word count: 119)
Jan 4 2008, 3:15 AM EST
vesterli
Added demobld and XE info
edit
48 words added
2 words deleted
Change:
In recent versions of the database, this account is locked by default and must be unlocked with ALTER USER SCOTT ACCOUNT UNLOCK;
Oracle XE inexplicably doesn't have this classic account, but you can add the user yourself and fill it using the
demobld
script.
Later versions has
View changes from previous version.
(Word count: 119)
Jan 3 2008, 12:26 PM EST
emocat
Moved from: The Official Oracle Wiki
move
No content added or deleted.
Change:
Moved by
emocat
Jan 3 2008, 12:26 PM EST
Jan 2 2008, 5:16 AM EST
vesterli
Created
edit
71 words added
Change:
Every Oracle database has had an account called SCOTT with password TIGER. It is named after Bruce Scott (one of the original Oracle employees) and the password is the name of his daughter's cat. This schema contains the EMP and DEPT tables used in innumerable demos.
Later versions
View changes from previous version.
(Word count: 73)
Jan 2 2008, 5:12 AM EST
vesterli
create
No content added or deleted.
Change:
Created by
vesterli
Jan 2 2008, 5:12 AM EST for: no reason given
JavaScript must be enabled in order for you to contribute to this site.
To start contributing, enable JavaScript by changing your browser options, then
try again
.
Home
Rules of Conduct
FAQ
Oracle OpenWorld
Oracle Technology Network
Oracle Magazine
Applications
E Business Suite 11i/R12
Business Intelligence
Database
Editions
Administration
Data Access APIs
Data Cartridge
Data Import and Export
Database Benchmarking
Database Error Codes
Database Releases
Database Security
Database Troubleshooting
Embedded SQL Precompilers
Materialized View Log
Oracle Data Guard
Oracle Data Mining
Oracle Questions & Solutions
Oracle OLAP Option
Oracle Statistical Functions
Oracle Warehouse Builder
Performance Tuning
PL/SQL
Real Application Clusters
Real Application Testing
scott/tiger
Shared Pool Memory Structures
Spatial
SQL
Virtualization
Real World Performance
Oracle 11g Database Features
Oracle Database Hosting Companies
Messaging Gateway
FlashBack
Parameters
Events
Dumping data
Hanganalyze
Tracing
Oracle Dictionary
How ORACLE CBO Calculate Join Cardinality with Join Elimination Filter?
Database Tools
Ronald_Vargas_CR
Oracle XMLDB
Query Parsing
Oracle DB notes-tricks-techniques
Developer Tools
Embedded
Enterprise Manager
Fusion Middleware
Grid Computing
Java
Linux
Oracle and FOSS
Oracle Secure Enterprise Search
Windows and .NET
TimesTen
Oracle On Demand
Oracle VM
Semantic Web
Installation Guides
Security & Compliance
Scripting Languages
Oracle Certification
Acronyms
Oracle Community
Spanish Wiki
Web 2.0 Resource Library
Architect / Architecture Resources
QuestionsOnSOA
Japanese Wiki (日本語)
ISV Guideline DBA friendly Software
Fusion
Oracle Cloud Computing
Oracle Italy Technology Insight Program
SOA Events Calendar
Jobs for Architects
France Communauté Partenaires Database
Polskie Portale
Desmistifying SOA
High availability with RAC or Fail Safe
Scripts Shell desde Procedimiento BD Oracle
Communauté E2.0 France
E2.0 česká wiki
Oracle Mix sandbox
ERP 2.0
Nuove norme del Garante della Privacy
Debugging Siebel EIM
Improving Siebel Configuration Efficiency
Enterprise Tool
enterprise20spain
Blurbs
Prime People
Primavera
Job Oracle Transportation Management
PL Wiki ORACLE
SOA Governance Cookbook
Oracle Support
OPN Portugal
RAC Assurance Team
Why do you need 11g
Oracle Certifications
Weblogic Integration ( WLI )
Specialized OPN Program your questions
Patching Hints and Tips
Nordics Wiki
Oracle Direct Iberia
Migration tools to Oracle solutions
SQL COMMANDS
Sierra Atlantic, Inc.
new page
(Uncategorized)