TOAD 8.5 Database Creation Scripts

[MartinF]

Hi all,

I am using TOAD 8.5, how to i create a set of Database Creation Scripts for my database from TOAD?

Thanks

 

[Thargy]

I use a later version of TOAD, so I can't answer directly. However, if you use the DBCA to make your database, it has a facility to automatically generate a script for you. I suggest you try that as a possible alternative.

Regards

T

 

[LKBrwnDBA]

Try: Database -> Export -> Generate Database (or schema) script.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[MartinF]

LKBrwnDBA: Thanks for the tip, however i dont have the 'Generate Database (or Schema) Script under Database>Export!!

The only menu items i have under these menu's are:

Table Scripts
Grants
Table Data
Source Code
Table as Flat File
Synonyms
Sequences

Does this mean i dont have the required add-in?

 

[LKBrwnDBA]

Maybe you do not have the DBA version of TOAD.
What is under "Database" tab?



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

The best option would then be as Thargy suggested: use dbca.

If you only need to generate scripts for "Schema" creation, then take export without data and use DDL Wizard.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb