?
Solved

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

Posted on 2012-03-20
4
Medium Priority
?
403 Views
Last Modified: 2012-03-21
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.
0
Comment
Question by:killdurst
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 4

Assisted Solution

by:Victor Tarasov
Victor Tarasov earned 400 total points
ID: 37745882
No, but you can write script.
0
 
LVL 39

Assisted Solution

by:Pratima Pharande
Pratima Pharande earned 400 total points
ID: 37745917
0
 
LVL 16

Assisted Solution

by:Wasim Akram Shaik
Wasim Akram Shaik earned 400 total points
ID: 37745939
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
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 800 total points
ID: 37746907
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question