[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2012-03-20
4
Medium Priority
?
409 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
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 78

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses
Course of the Month18 days, 8 hours left to enroll

825 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