From: jurij.modic@mf.sigov.mail.si (Jurij Modic) Subject: Re: Status of drop column package Date: 1997/10/10 Message-ID: <343e80e4.1255025@www.sigov.si>#1/1 References: <343D9ADA.AEADABC8@scioto.net> Organization: Ministry of Finance, Republic of Slovenia Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.server,comp.databases.oracle.misc On Thu, 09 Oct 1997 23:02:50 -0400, "Joseph S. Testa" wrote: >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. > Don't forget to rebuild also some other objects from old to new table: - the views - the sysnonyms (also for new views) - the grants (also for new views and synonyms) - the triggers - the check constraints - the snapshot logs - ...... >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 Regards, ============================================================ Jurij Modic Republic of Slovenia jurij.modic@mf.sigov.mail.si Ministry of Finance ============================================================ The above opinions are mine and do not represent any official standpoints of my employer