Re: Status of drop column package

Try Adhawk Spacer !!!!!

Joseph S. Testa <jtesta_at_scioto.net> wrote in article <343D9ADA.AEADABC8_at_scioto.net>...
> well it is going well, it does the following:
> 1. rename table
> 2. create new table minus the column you want to drop.
> 3. build the PK on new table.
> 4. build all FK that pointed to the old table FK and now point them
> to the new table.
> 5. build all FK from old table that pointed to other PK and put them
> on new table.
> 6. build all extra indexes that were on old table.
> 7. save all above in a table, for complete undo back to step one.
>
> That is the general concept of what works today, I'll be testing rest of
> this week and all next week, by next weekend(oct 18th or so), should be
> ready for some volunteers to beat up on it some. any volunteers?, sorry
> source code wont be available right away.
>
> joe
>
> --
> Joseph S. Testa, Oracle Database Administrator
> Are you looking for Oracle DBA in Central Ohio, but only want one for
> some part-time work? try http://web.scioto.net/jtesta
> That is also the place to find the FREE, "how do I build a second,
> third, etc, instance, without using oracle's installer, database
> scripts.
> ICQ UIN: 2814105(Joe-N8XCT, Home) UIN: 2832230(&oracle, work).
>
>
>
Received on Fri Oct 10 1997 - 00:00:00 CDT