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.
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