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