This content has been marked as final. Show 4 replies
We would need to see the contents of the file to know for sure how you should start. Does it assume scott already exists or does it create it?
But generically speaking you open SQL*Plus, log in to a DBA account such as SYS or SYSTEM and do the following:
and hit the [Enter] key
If you need more help then post the first 10-20 lines of the file.
But the chances that scott does not already exist in your database is close to zero unless it has been dropped intentionally.
10g XE does NOT include the scott schema, it only has the hr schema installed..
You can run following script with SYSTEM account (from 11.2 <ORACLE_HOME>/rdbms/admin/utlsampl.sql) to create SCOTT user account:
GRANT CONNECT,RESOURCE,UNLIMITED TABLESPACE TO SCOTT IDENTIFIED BY tiger;
To install the SCOTT schema you may execute the following scripts from a DOS box:
Hope this help.
set ORACLE_SID=XE sqlplus /nolog connect / as sysdba @<ORACLE_HOME>/rdbms/admin/scott.sql @<ORACLE_HOME>/sqlplus/demo/demobld.sql @<ORACLE_HOME>/rdbms/admin/utlsampl.sql