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

I know the feeling - my record is a marathon migration/reorg of 3 days no sleep and hacking away indexfiles :-)
I have some korn shell scripts that'll manipulate indexfiles but I implemented it all in java so it'll run everywhere-> http://sourceforge.net/projects/pretoria/ I'm also polishing up Pepi (http://sourceforge.net/projects/pepi) - an export/import tool for the power users (with power boxes and power diskservers :-) )

Cheers,
Kurt

"Ethan Post" <Blah_at_Blah.com> wrote in message news:JWDo7.6106$6c5.197999_at_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 - 07:45:41 CDT