Toad World® Forums

Schema Compare and Partition tables

Schema compare only list that

"– Difference : Partitioning

– No Action Taken "

It does not create script for drop and recreating the table. If there is way to enable this feature ?

Toad V 12. Oracle 11.2

Sorry, no. The schema compare avoids actions that will result in data loss.

If you don’t care about data loss, the easiest thing to do is use Generate Schema Script to get a full script for the source schema and run it to produce the
target schema. Of course, if it is just a few tables, then you might want to use the SB-Tables-Script tab to get a script just for the tables that need to be rebuilt.

From: s.pathak [mailto:bounce-spathak@toadworld.com]

Sent: Friday, June 28, 2013 10:48 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Schema Compare and Partition tables

Schema Compare and Partition tables

Thread created by s.pathak

Schema compare only list that

"– Difference : Partitioning

– No Action Taken "

It does not create script for drop and recreating the table. If there is way to enable this feature ?

Toad V 12. Oracle 11.2

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Thanks for quick response… i think since data is not important, i will create schema dd and go for drop and recreate option.

Thanks again.

Saurabh