Re: Exporting structure

Try import using options "indexfile=file_name.sql rows=N". file_name.sql is an ascii file now including table definition as comments and indexes definition. You may edit it as you want.

Steve <robertoc_at_fyiowa.infi.net> wrote:

>We need to export a user's schema, structure only, make sizing changes
>then import this in another instance. I know that the file in which
>export puts out is a binary file and you're not suppose to edit it.
>Is there a problem if I take what it exports modify it and clean it up
>and then instead of using import just execute it as a SQL script or is
>this a bad idea?
 

>Will I be missing any constraints/indexes etc?
 

>I talked with someone during Oracle Openworld in the Campground area and
>they said that there was an undocumented ascii export option. When I
>got back I called Oracle Support and they never heard of it.
 

>I'd appreciate any help or suggestions.
 

>Thanks in advance.
 

>Steve

--
TRF