Creating DB from script in Toad or SQL+

[martinm]

I have a Toad generated DB creation script of a DB created using the Oracle Admin tool, this needs to be run as a script to create on users sites. Problem is, you need to be logged into a DB to create it (or any Oracle command), and many of the tablespace names used in the script exist in the 'current' db........

I'm sure the answer is simple, but I don't know what it is!!

 

[sem]

So where is the question?

Regards, Dima

http://seminihin.narod.ru

 

[martinm]

How do I create a DB from a script!!

 

[sem]

Just launch it from sql*plus.

Regards, Dima

http://seminihin.narod.ru

 

[sem]

Ok, to create database you should be connected to instance, not to database. You can not create more than 1 database per instance.

Regards, Dima

http://seminihin.narod.ru

 

[martinm]

Hi Sem - I think I'm getting there!!

How do I connect to an instance in SQL+ - I have user/pwd/hoststring params needed.

They guy who set it up has left - what are the default pwds I may need (hopefully he hasn't changed them )

Cheers.

 

[sem]

Are you sure you need to create database? Not schema or table? Do you know the difference?

Regards, Dima

http://seminihin.narod.ru

 

[martinm]

It's a db or Schema. Somewhere new to add tables to.So no, not quite sure of the difference %-)

 

[martinm]

In fact, creating it via Oracle, it creates a new db.

 

[sem]

What did you call Oracle in the last message?

Regards, Dima

http://seminihin.narod.ru

 

[martinm]

Database Config. Assistant

 

[sem]

You should prepare pfile, create and start oracle service with oradim, set ORACLE_SID, connect from sql*plus /as SYSDBA and launch the script.
But I'd strongly recommend you to read manuals or at least learn basic Oracle concepts.

Regards, Dima

http://seminihin.narod.ru

 

[martinm]

Thanks Sem. I've advised my client that db creation is a DBA task (most won't let a user/developer create anyway), so they should be given the script and left to it. Job done.