Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: INDEXFILE and Line Breaks in DDL
Thanks for the ideas, the statements with the bad line breaks still cr*p
out. I wrote my own program in VB that will fix this but an 18 mile drive
into work is required to fetch it. Maybe I will write a stored procedure
using UTL_FILE to fix it. Will let you know. - E
"koert54" <koert54_at_nospam.com> wrote in message
news:aHHo7.54870$6x5.11759267_at_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 - 08:30:00 CDT