Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Help, it's late and I need sleep. INDEXFILE and CONSTRAINTS
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
![]() |
![]() |