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

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

From: Ethan Post <Blah_at_Blah.com>
Date: Sat, 15 Sep 2001 07:53:13 GMT
Message-ID: <JNDo7.6091$6c5.197563@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 - 02:53:13 CDT

Original text of this message

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