Home » RDBMS Server » Server Administration » Creating 9.2 DB from the command line
Creating 9.2 DB from the command line [message #157923] Tue, 07 February 2006 04:26 Go to next message
bikebore
Messages: 2
Registered: February 2006
Junior Member
Hi,

Apologies if this is a basic question. I'm having to manually create a database from the command line at a remote site. I have the DB created, tablespaces and rollback setup.

However, no system tables/ views are available as sysdba. Have read somewhere on the site that I need to run catproc.sql, however this generates errors.

Have been trying to run catproc.sql as sysdba. Can anyone tell me what steps I should complete once the DB is created to get it to a point where I can import data?

Thanks
Nick
Re: Creating 9.2 DB from the command line [message #157925 is a reply to message #157923] Tue, 07 February 2006 04:34 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96521/create.htm#1000691
icon7.gif  Re: Creating 9.2 DB from the command line [message #157931 is a reply to message #157923] Tue, 07 February 2006 04:51 Go to previous message
bikebore
Messages: 2
Registered: February 2006
Junior Member
Thanks Tarundua!

Maybe I should practice my google skills.... Embarassed
Previous Topic: Maximum data segment size
Next Topic: lot of messages in the alert file
Goto Forum:
  


Current Time: Tue Feb 04 02:21:03 CST 2025