Scripts after comparing oracle schema
rajeshb
Posts: 1 New member
Scripts after comparing oracle schema
I have compared two schemas and it throws the difference. Is it possible to get the script only for the change
For Example
Schema A contains table1 with a field address varchar(100)
In Schema B the address size is varchar(80)
Is it possible to get the script to alter the field size only instead of dropping and creating the table again
I have compared two schemas and it throws the difference. Is it possible to get the script only for the change
For Example
Schema A contains table1 with a field address varchar(100)
In Schema B the address size is varchar(80)
Is it possible to get the script to alter the field size only instead of dropping and creating the table again
Tagged:
Best Answer
-
Eddie D
Posts: 1,807 Rose Gold 5
Hi, thank you for your forum post.
Schema Compare for Oracle will alter existing tables whenever possible. However there are situations to preserve the data that exists in the table to be modified. When this occurs, the entire table will be dropped and recreated. This involves creating a new table, copying the data to the new table and dropping the old table
