Status of drop column package
From: Joseph S. Testa <jtesta_at_scioto.net>
Date: 1997/10/09
Message-ID: <343D9ADA.AEADABC8_at_scioto.net>#1/1
Date: 1997/10/09
Message-ID: <343D9ADA.AEADABC8_at_scioto.net>#1/1
[Quoted] [Quoted] well it is going well, it does the following:
- rename table
- create new table minus the column you want to drop.
- build the PK on new table.
- build all FK that pointed to the old table FK and now point them to the new table.
- build all FK from old table that pointed to other PK and put them on new table.
- build all extra indexes that were on old table.
- save all above in a table, for complete undo back to step one.
[Quoted] [Quoted] 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 Thu Oct 09 1997 - 00:00:00 CEST