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

Best Answer

  • Eddie DEddie D Posts: 1,379 Rose Gold 1
    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
    Eddie Davis
    Technical Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.