Re: Oracle equivalent of Informix dbschema??

Dirk Fromhein wrote:
>
> I have an Oracle db that I need to get the ddl for... is there a way to
> get it via standard Oracle tools?
>
> Thanks!
>
> Dirk Fromhein
> df_at_watershed.com
> http://www.watershed.com

Look at the Export and Import utilities. First export what you want the ddl for. Next import using the indexfile option. I usually do two separate import operations, one for the table defs and one for the index defs. The resulting "indexfile" will contain the ddl for the objects you imported. It will be necessary to edit the file to remove the "REM " at the beginning of each line, but once you do you can recreate the tables and index structures as exported. Incidentally, the import with the indexfile option does not import either table data or index data into the database.

I just did the above operations and then edited the files to relocate all of my tables and indexes into different tablespaces.

Jerry Received on Wed Aug 27 1997 - 00:00:00 CDT