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: INDEXFILE and Line Breaks in DDL

Re: INDEXFILE and Line Breaks in DDL

From: koert54 <koert54_at_nospam.com>
Date: Sat, 15 Sep 2001 12:19:18 GMT
Message-ID: <aHHo7.54870$6x5.11759267@afrodite.telenet-ops.be>


hmm - if you're using sqlplus in 8i you should issue 'set sqlblank on' - otherwise run the indexfile in svrmgrl
Or you could use Pretoria - an indexfile pretty printer ... it can also merge new storage parameters in the indexfile http://sourceforge.net/projects/pretoria/

"Ethan Post" <Blah_at_Blah.com> wrote in message news:iLEo7.6183$6c5.199800_at_news1.rdc1.sdca.home.com...
> Back to my original problem again.
>
> imp x/x file=file.dmp indexfile=abc.sql fromuser=a touser=b
>
> Then VI and remove REM's.
>
> When running numerous statements are invalid due to line-breaks in column
> names.
>
> What gives??? I swear I did this on some machines last week and never saw
> any invalid SQL. Both are AIX and Oracle 8i. Help will be greatly
> appreciated.
>
> Thanks,
> Ethan Post
>
>
Received on Sat Sep 15 2001 - 07:19:18 CDT

Original text of this message

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