From: "Erik Oosterling" Subject: Re: Status of drop column package Date: 1997/10/10 Message-ID: <01bcd584$a2396100$0d44100a@bis-w079>#1/1 X-Nntp-Posting-Host: 10.16.68.13 Sender: nntp@atf.cmg.nl (NetNews Transport Daemon) References: <343D9ADA.AEADABC8@scioto.net> Organization: cmg Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.server,comp.databases.oracle.misc Try Adhawk Spacer !!!!! Joseph S. Testa wrote in article <343D9ADA.AEADABC8@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). > > >