How to run sql script [message #69394] |
Sat, 22 December 2001 21:17 |
Girdhari Ram Choudhary
Messages: 8 Registered: December 2001
|
Junior Member |
|
|
I want to create data dictionary after creating the database.how to run catalog.sql script
----------------------------------------------------------------------
|
|
|
Re: How to run sql script [message #69419 is a reply to message #69394] |
Mon, 31 December 2001 21:11 |
AV.NACHIAPPAN
Messages: 9 Registered: December 2001
|
Junior Member |
|
|
After creating the database. In the Severmanager
prompt svrmgr>@%oraclehome%rdbms80admin
catalog.sql
then catproc.sql
if you run this two scripts your database will have the datadictionaries and the procedures
and functions needed for the database to run
smoothly.
in win95 for p08 the home will be d:orawin95
in winnt the home will be d:orant
if you still have doubts please do not hesitate
to contact me.
Thanks and wish you a happy new year 2002.
----------------------------------------------------------------------
|
|
|
|
|