Data Pump Transportable Tablespaces
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