How add, delete or change field of table?
If i want to do it i can't do it because there are consrains which don't allow me to do it.
It can be done to delete all schema and make it newerely
using scripts, but i am iteresting is there another method to make such operation?
I know that in Oracle 8i i can do it, but does anybody
know how do it on Oracle 7.3.4???
It is a question of all MY LIFE!!!!!
The best way to do it in 7.3.4 is to upgrade to 8i
You can ALTER TABLE to add or modify a field. However, prior to 8.1, there is no easy way to delete a field. You have to
CREATE TABLE new_table AS SELECT all_but_the_columns_you_want_to_drop;
Drop the table after disabling any foreign key constraints.
RENAME new_table TO old_table.
Recreate indexes, constraints.
Click Here to Expand Forum to Full Width