Generate tables script

[Nadia Teles]

Good afternoon staff,

I created the bank, the tables, sequences and primary keys through Enterprise Manager. How do I generate a script for all this? For, I will install on another Oracle server.

Thanks

Nádia

[gilbertoca]

Hi Nadia!

Good source is this link http://www.quest-pipelines.com/newsletter-v7/0406_A.htm

a concrete example:

Select all

 
set pagesize 0 
 
 set long 90000 
 
 set feedback off 
 
 set echo off  
 spool scott_schema.sql  
 connect scott/tiger; 
 SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name) 
     FROM USER_TABLES u; 
 SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name) 
     FROM USER_INDEXES u; 
 spool off; 

Gilberto

[erthal]

Nadia,

or else you can make use of a freeware called dbdesigner4, from Fabforce, that you find in superdownloads.

He does a "perverse" engineering than you want, from the bank, of a specific schema and so on.

[] 's

[ARF]

Oracle SQL Developer (Oracle Free Tool) shows the DDLs of the objects.