Scripts after comparing oracle schema

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
Tagged:

Best Answer

  • Eddie DEddie D Posts: 1,273 Gold 2
    Accepted Answer
    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
Sign In or Register to comment.