Question about Reordering Columns in a Table in TOAD for Oracle

I have TOAD for Oracle DBA Suite. I did have Embarcadero’s DBArtisan but decided to drop that license when we upgraded last year. I have one development group that requests adding a column to their tables and want the column in a certain position - I know they can handle this using queries and views so it is not really necessary. My issue is DBArtisan handled this very well - basically you just inserted the new column where you wanted it and DBArtisan would do the rest - rename the table, create the new table, load the table and create the indexes. Does anyone know of a place within TOAD DBA Suite that will do this easily?

Thanks.
Linda F

Message from: tillman3_671

Hello Linda, One of our developer’s asked this same question today and I showed
him how TOAD’s “Table Rebuild” feature would let him re-arrange the table
structure fairly painlessly. The feature will generate DDL that you may modify
and then use to rebuild and re-populate the table including all constraints,
triggers etc. Look for the Rebuild Table feature.


Historical Messages

Author: tillman3_671
Date: Tue Dec 07 12:49:49 PST 2010
Hello Linda, One of our developer’s asked this same question today and I showed
him how TOAD’s “Table Rebuild” feature would let him re-arrange the table
structure fairly painlessly. The feature will generate DDL that you may modify
and then use to rebuild and re-populate the table including all constraints,
triggers etc. Look for the Rebuild Table feature.
__

Author: linda.fevold_718
Date: Thu Dec 02 08:46:18 PST 2010
I have TOAD for Oracle DBA Suite. I did have Embarcadero’s DBArtisan but
decided to drop that license when we upgraded last year. I have one development
group that requests adding a column to their tables and want the column in a
certain position - I know they can handle this using queries and views so it is
not really necessary. My issue is DBArtisan handled this very well - basically
you just inserted the new column where you wanted it and DBArtisan would do the
rest - rename the table, create the new table, load the table and create the
indexes. Does anyone know of a place within TOAD DBA Suite that will do this
easily?

Thanks.
Linda F

__


The DBMS_REDEFINITION wizard will allow you to do this as well, and a lot more
powerful than just adding/changing column order…

Hello Linda, One of our developer’s asked this same question today and I showed him how TOAD’s “Table Rebuild” feature would let him re-arrange the table structure fairly painlessly. The feature will generate DDL that you may modify and then use to rebuild and re-populate the table including all constraints, triggers etc. Look for the Rebuild Table feature.

Thanks - I tried it and it worked great.

Linda F