create database

[Thiko]

is it possible to extract the create database statement that was used to create a database?

i would like to use/amend a copy from another machine for a new database.... Many Thanks.

Thiko!

 

[rishiu]

Actually It depends, If u hv freshly installed the database
then the Answer is yes, but if lot of tablespace etc have been added then Answer is No.
Anyway U can get a feel of ur database by the control file

Alter database backup controlfile to trace.

Try this and Mail further
Rishiu

 

[Thiko]

yes thank you Rishiu, that is just what i need! Many Thanks.

Thiko!

 

[Sanjiv]

Instead of creating a seperate tablespace can we create 2 or more database in oracle.
I tried creating a databse other then the default ,it overwrote the settings of the default database.

Pl help
Sanjiv