Home » RDBMS Server » Server Administration » could I execute catalog.sql when db is opened
could I execute catalog.sql when db is opened [message #56479] Thu, 03 April 2003 00:00 Go to next message
Felix
Messages: 6
Registered: February 2002
Junior Member
Hi:
I forgot to execute catalog.sql when create db,
the database is opened and there are many users connect to it, could I execute it now? or I should switch db to single user mode? thanks

felix

Report message to a moderator

Re: could I execute catalog.sql when db is opened [message #56491 is a reply to message #56479] Thu, 03 April 2003 13:11 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
You can run it even with users connected.

However, I doubt any user can connect since the catalog.sql creates the data dictionary. Probably you already ran this script and missed to see it.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: ORA-03114 when installing 8.1.7
Next Topic: How to connect to oracle9i server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 28 23:33:53 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.