Re: how can I drop a column from a table??? Hurry up, please

Whenever a problem (such as drop column, rename column, table reorg, etc...) calls for "DROP TABLE" as part of the solution there are some issues that need to be addressed:

1. constraints
2. indexes
3. triggers
4. grants
5. comments
6. audit settings on the table
7. snapshot logs
8. stored procedures
9. views
10. synonyms

Items #1 - #7 get dropped along with table. Items #8 - #10 don't get dropped but some may need recompiliation.

Everyone seems to remember items #1 and #2 but forget the rest!

If you're a DBA, you'd be doing yourself and the company you work for a favor if you memorize this list. These 10 issues come from working with Oracle 7.x . With Oracle 8.x, there may be new issues to add.

On Tue, 15 Sep 1998 12:53:13 GMT, tomscott_at_nospam.abac.com wrote:

>1) Find all the constraints for the table and disable/inactivate them
>2) Rename the table
>3) Create a new table with only the columns you want
>4) Lod the new table from the renamed table with a select statement
>5) Reenable the constraints
>
>Sad, but true.
>
>There are scripts out there that will do this for you, but it's not
>that difficult to do yourself.
Received on Fri Sep 18 1998 - 00:00:00 CEST