Q

Capturing the creation scripts in 9.2

Is there any way to capture the creation scripts used to create one of the databases in the Oracle 9.2 install?...

I don't want a database in production without the scripts that created it. I did a test install and cannot find anything but the output of the scripts, not the scripts themselves.

Keeping the creation scripts is always a good idea. When you install Oracle, do not just let it install the starter database. Instead, invoke the Database Configuration Assistant (DBCA). The DBCA has an option to store the creation scripts in a number of files. This way, you will have the creation scripts that the DBCA actually runs for you.

If you already have the database created, then you can still get these scripts. Just search the Web for "reverse engineer Oracle" and you will get a lot of hits for scripts which will reverse engineer, or create the DDL statements to create many objects, including the database, tablespaces, tables, indexes, etc. There are tools on the market, like Toad, which also have this capability. In the end, they are just querying the data dictionary to recreate these DDL statements. You can do the same.

For More Information


This was last published in April 2003

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close