Home » RDBMS Server » Server Utilities » How to run sql script
How to run sql script [message #69394] Sat, 22 December 2001 21:17 Go to next message
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 Go to previous messageGo to next message
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.

----------------------------------------------------------------------
how to view the contents of that stored procedure [message #69886 is a reply to message #69394] Sun, 17 March 2002 19:18 Go to previous messageGo to next message
Bharathi
Messages: 6
Registered: March 2002
Junior Member
i need to view the contents of a stored procedure
Re: how to view the contents of that stored procedure [message #69888 is a reply to message #69394] Sun, 17 March 2002 23:13 Go to previous message
Vikas Gupta
Messages: 115
Registered: February 2002
Senior Member
You can use the view: user_source
select name, text from user_source where
name = 'yourprocedurename'

Regards,
Previous Topic: Re: FREE OCP PAPERS
Next Topic: urgent
Goto Forum:
  


Current Time: Fri Apr 19 17:22:24 CDT 2024