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 by 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 oracle default tables (369) (this contents data for the tables)
10) extract the downloaded file
11) type this command in sql command prompt
@(yourfilepathhere)/oracle.sql;
replace yourfilepathhere with the path of the sql file you just extracted. here is an example
@c://downloads/compressed/oracle/oracle.sql;
12) You are done!!! Now you can work with scott schema & all oracle default tables
