|
|
|
Re: how to export table structure as script in oracle in all schemas [message #488550 is a reply to message #488548] |
Sun, 09 January 2011 05:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
With dbms_metadata, first hit in google.
See if this suits you ( and I trust the author).
http://www.optimaldba.com/scripts/extract_schema_ddl.sql
with exp/imp tools,
export with rows=n
and
import with show=y logfile=somelogfile.sql
or
import with indexfile=somefile.sql
Both above options will actually import nothing into database but will dump the ddl information in specified file.
|
|
|