OraFAQ Forum: SQL & PL/SQL » How to create HR schema table using stored scripts

Home » SQL & PL/SQL » SQL & PL/SQL » How to create HR schema table using stored scripts (10g, windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to create HR schema table using stored scripts [message #537949]

Tue, 03 January 2012 03:32

morad_dba
Messages: 93
Registered: June 2008

Member

Dear All,

I dropped HR schema from database by mistake.
Please tell me how to create HR Schema and its all tables using oracle stored scripts.

My operating system is Windows XP and oracle version is 10g.

Please help me.

Morad.

Report message to a moderator

Re: How to create HR schema table using stored scripts [message #537954 is a reply to message #537949]

Tue, 03 January 2012 03:35

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The script is @?/demo/schema/human_resources/hr_main.sql
Connect as SYSTEM to execute it.

Regards
Michel

Report message to a moderator

Re: How to create HR schema table using stored scripts [message #537956 is a reply to message #537954]

Tue, 03 January 2012 03:37

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

Did you dropped HR username?

Report message to a moderator

Re: How to create HR schema table using stored scripts [message #537963 is a reply to message #537954]

Tue, 03 January 2012 03:50

morad_dba
Messages: 93
Registered: June 2008

Member

Dear Michel Cadot,

In my PC at E:\oracle\product\10.2.0\db_1\demo\schema\human_resources\

location , there is no file like hr_main.sql.

So how can i create hr schema and its all table ?

Please help me.

Morad.

Report message to a moderator

Re: How to create HR schema table using stored scripts [message #537964 is a reply to message #537963]

Tue, 03 January 2012 03:53

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have to reinstall the demo scripts from the Client CD.

Regards
Michel

Report message to a moderator

Re: How to create HR schema table using stored scripts [message #537966 is a reply to message #537964]

Tue, 03 January 2012 03:59

morad_dba
Messages: 93
Registered: June 2008

Member

Dear Michel,

I have oracle 10g database software as backup in my PC but how can i install demo scripts, I didn't find any folder like Demo in the
software folder.

Please help me.

Morad.

Report message to a moderator