Question about Reordering Columns in a Table in TOAD for Oracle

Message from: linda.fevold_718

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


Historical Messages

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

__