Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: INDEXFILE and Line Breaks in DDL
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