Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Script to generate Table DDL

Re: Script to generate Table DDL

From: Jorge Meirim <transparente_at_mail.telepac.pt>
Date: Tue, 10 Nov 1998 23:30:02 -0000
Message-ID: <72ahts$lak@brown.telepac.pt>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US