How to view the 'CREATE DATABASE' script for my database?

Hi,

I can access my Oracle database by using Toad (v11, Free) and sqlplus.

Is there a way for me to view the 'CREATE DATABASE' script for my database?

Thanks.
LVL 1
killdurstAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
One other option:  Run the database configuration asssitant (DBCA), create a template from an existing database.  Then run through the steps to create a database from the template.

At the end of the process you have the option to save the create scripts instead of actually creating the database.
0
 
Victor TarasovConnect With a Mentor Head of the Department of System AdministrationCommented:
No, but you can write script.
0
 
Wasim Akram ShaikConnect With a Mentor Commented:
you can view the create scripts for database objects but not for database..

because database is not an object, its a software...!!!

there are many ways for recreating the database.. as expert pratima has said, that could be one of the option

other options can be taking an export/expdp of existing db and import import/impdp in another database..etc.,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.