Home » RDBMS Server » Server Administration » How to reate new database with script in windows 2000
How to reate new database with script in windows 2000 [message #50149] Mon, 04 March 2002 04:23 Go to next message
jie
Messages: 10
Registered: March 2002
Junior Member
Database in Windows 2000 is running as service. When creating database using script, how can I add the service? I tried to create a new db using script, but it ended up creating clone database. After I create the database, I could create rollback segment using no system tablespace. Should I do some setting in the registry or environment variables? Thanks.

Report message to a moderator

Re: How to reate new database with script in windows 2000 [message #50156 is a reply to message #50149] Mon, 04 March 2002 09:00 Go to previous message
Kassim Kasmani
Messages: 25
Registered: January 2002
Junior Member
You should create another instance before you create a new database. Use ORADIM to create the instance from the command line.

I.E:

C:>oradim -new -sid dbname -intpwd dbpassword -startmode auto/manual -pfile path/to/init.ora

Hope this helps!

_____________
Kassim Kasmani
Yahoo Messenger: kassim13

Report message to a moderator

Previous Topic: JDBC question
Next Topic: Re: ocp
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 08 11:33:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.