Anyway to Include Tablespaces

Compares and synchronizes the schemas of Oracle databases

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

Anyway to Include Tablespaces

Postby eandrews » Mon Jan 06, 2014 7:54 pm

Is there any way to include Tablespaces in the comparison? We currently store Indexes in a separate tablespace from the tables and this doesn't appear to be considered in the comparison.

Any other options?
eandrews
 
Posts: 4
Joined: Mon Jan 06, 2014 7:03 pm
Location: United States

Include Tablespaces

Postby eandrews » Wed Jan 08, 2014 2:51 pm

I figured out that there is a "Ignore Storage" option as part of the project options when executing the compare. When this is not selected the tablespace as well as many other storage parameters are included in the compare and scripts.

However, there still appears to be an issue when comparing the files against the database. In my case I lose the partition information even though the information is in the file being used as the source.
eandrews
 
Posts: 4
Joined: Mon Jan 06, 2014 7:03 pm
Location: United States


Return to Schema Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests

cron