7 Replies Latest reply: Mar 12, 2014 3:59 PM by 283d481d-f536-4728-85e4-793b05e26213 RSS

    I have run script to set the demo hr schema but there are no tables


      When I run the script in SQL Developer I get the following output


      specify password for HR as parameter 1:

      specify default tablespeace for HR as parameter 2:

      specify temporary tablespace for HR as parameter 3:

      specify password for SYS as parameter 4:

      specify log path as parameter 5:

      Cannot create SPOOL file c:\oraclexe\app\oracle\product\11.2.0\server\demo\schema\log\hr_main.log

      user HR dropped.

      user HR created.

      user HR altered.

      user HR altered.

      GRANT succeeded.

      GRANT succeeded.



      Error starting at line : 85 File @ C:\oraclexe\app\oracle\product\11.2.0\server\demo\schema\human_resources\hr_main.sql

      In command -

      CONNECT sys/&pass_sys AS SYSDBA

      Error report -

      Connection Failed


      user HR altered.


      Am I doing something wrong here or is there something else that needs to be run to create the tables?