There is no Oracle default scott schema or default tables like emp, dept, bonus, salgarde in Oracle 10g XE. Here is a easy step by step guide to create it.
1) Download & install Oracle 10g XE.
2) Go to Start > All Programs > Oracle Database 10g Express Edition > Go To Database Home Page
3) Log in using username: system & your password you entered in installation process.
4) Go to Administration > Manage Database Users > Create
5) username: scott Direct Grant System Privileges: CREATE TABLE (You can modify these settings later)
6) Go to Start > All Programs > Oracle Database 10g Express Edition > Run SQL Command Line
7) type connect
8) username: scott password: password you entered in step 5.
9) Download this file https://github.com/mycuteblog/oracle-10g-xe-default-schema/blob/main/oracle.sql (this contents data for the tables)
10) type this command in sql command prompt.
@(yourfilepathhere)/oracle.sql;
replace yourfilepathhere with the path of the sql file you just downloaded. Here is an example;
@c://downloads/oracle.sql;
11) You are done! Now you can work with scott schema and all oracle default tables.
Comments