Red Gate forums :: View topic - Anyway to Include Tablespaces
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Schema Compare for Oracle
Schema Compare for Oracle forum

Anyway to Include Tablespaces

Search in Schema Compare for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
eandrews



Joined: 06 Jan 2014
Posts: 4
Location: United States

PostPosted: Mon Jan 06, 2014 7:54 pm    Post subject: Anyway to Include Tablespaces Reply with quote

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?
Back to top
View user's profile Send private message
eandrews



Joined: 06 Jan 2014
Posts: 4
Location: United States

PostPosted: Wed Jan 08, 2014 2:51 pm    Post subject: Include Tablespaces Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group