Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Pump Transportable Tablespaces

Jim ThompsonFeb 22 2012 — edited Feb 22 2012
Hi, I am new to using Data Pump for transportable tablespaces and I have a number of questions to clarify my understanding of what is going on -

Q1. If the tablespace that is to be transported has to be set to read only, then I guess this method is only suitable for those systems that can afford for the tablespace to be set to Read Only ?

Q2. Is this setting to read only just required during the transport period i.e. can it be the temporary read only that RMAN or hot backup sets when online copying ?

Q3. If manually setting the tablespace to read only then I guess you can just directly copy the underlying data files, using OS based copy even with the database open ?

Q4. Does the import attach the copied data files to the target database ?

Q5. If you export using TABLES= and TRANSPORTABLE_TABLESPACES=
what happens regards all the other objects in the copied data files that you are not importing ?

Q6. The 11gR1 Utilities Guide states that if using the TRANSPORTABLE parameter then your database compatibility setting must be 11.0.0 or higher
I though Transportable Tablespace via Data Pump was available at 10g as well, is this wrong ?

Q7. The 11gR1 Utilities Manual also states that if you are copying files between versions of Oracle ( eg 10g to 11g ) or from one platform to another – you should use RMAN for the copy – is this correct or can you use standard OS copy as well ?

thanks,
Jim
This post has been answered by Dean Gagne-Oracle on Feb 22 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2012
Added on Feb 22 2012
2 comments
258 views