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: Help, it's late and I need sleep. INDEXFILE and CONSTRAINTS

Re: Help, it's late and I need sleep. INDEXFILE and CONSTRAINTS

From: Ethan Post <Blah_at_Blah.com>
Date: Sat, 15 Sep 2001 08:02:49 GMT
Message-ID: <JWDo7.6106$6c5.197999@news1.rdc1.sdca.home.com>


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

Original text of this message

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