Monday, February 9, 2009

steps to run the Oracle scripts for building demo tables

Procedure to run the Oracle scripts to build the sample(Demo) tables.
I)
1. Go to All Programs >> Oracle-Ora Home >> Configuration and Migration Tools and click on Database

Configuration Assistant.
2. Click on next
3. Check the radio button for Crate a database and click on next.
4. Check the radio button for data warehouse and click on next.
5. Provide Global database name and sid click on next.
6. Next >> next >> next >> Finish.

II)
1) Go to run >> type cmd and press enter.
2) Type sql plus and click on enter.
3) Type sys as sysdba and press enter.
4) Provide the password.(which you have given in the password management interface).
5) search for the file C:\oracle\ora92\sqlplus\admin\pupbld.sql. If it exists run the following script.
6) sql> @ C:\oracle\ora92\sqlplus\admin\pupbld.sql

III)

1) 1) Go to run >> type cmd and press enter.
2) Type sql plus and click on enter.
3) Type sys as sysdba and press enter.
4) Provide the password.(which you have given for sid).
5) sql > connect scott/tiger press enter.
6) Now search for the file C:\oracle\ora92\sqlplus\demo\demobld.sql. If it exists run the following script.
7) sql> @ C:\oracle\ora92\sqlplus\demo\demobld.sql

Its done.

Thank you,

Raghuram Reddy Gottimukkula
Adobe Certified Coldfusion Developer
Bangalore

Special thanks to Mani Silpa :)