Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Script to generate Table DDL
I'am glad you have mentioned and called it that way.
Try next time imp user/pwd file=xpto indexfile=whatevername_you_want
Peek the whatevername_you_want.sql file and you migh't get a surprise.
To get indexes just "grep -v -i 'rem'
whatevername_you_want.sql'>to_your_index_one.sql
To get the entire file just do a «sed '/ REM //g'
whatevername_you_want.sql>new_file.sql» or awk it.
Simple.
Regards
Jorge Meirim
Steven Hauser escreveu na mensagem <7283ta$8p1$1_at_garnet.tc.umn.edu>...
>URL: http://www.tc.umn.edu/~hause011/
>
>Script is ugly_DDL.ksh, extracts sql from export files.
>
>HEH.
>
>--
>
>---------------------------------------------------------
>Steven Hauser, hause011_at_tc.umn.edu
>Phone: (612)626-7135
>Fax: (612)625-6853
>---------------------------------------------------------
Received on Tue Nov 10 1998 - 17:30:02 CST