Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help, it's late and I need sleep. INDEXFILE and CONSTRAINTS
Hey what do you know, run it twice and all of a sudden it works...
"Ethan Post" <Blah_at_Blah.com> wrote in message
news:JNDo7.6091$6c5.197563_at_news1.rdc1.sdca.home.com...
> Migrating some TS's to LMT. App puts PK's on data tablespace and I want
to
> move them to IND TS. I do import, with no indexes and no constraints.
Then
> create indexfile. Then comment out REM and change all BLAHT tablespace to
> BLAHI. Problem is some of the SQL is bombing because of line breaks in
the
> middle of column names. Why would imp with indexfile do this and what is
> quickest way to fix it. I assume some snazzy UNIX command.
>
> Thanks,
> Ethan POst
>
>
Received on Sat Sep 15 2001 - 03:02:49 CDT