Datapump transportable tablespaces problem
Hi all,
My env.:
Source Database: Oracle v10.1.3.0 Enterprise 32bit, RHEL AS release 3
Detination Database: Oracle 10.2.0.1 Enterprise 32bit RHEL 5
I'm having this problem when trying to transport tablespaces.
I followed the guide from Metalink Note.277650.1 and did the following on
source DB:
EXECUTE DBMS_TTS.TRANSPORT_SET_CHECK('payroll_p', TRUE);
SELECT * FROM transport_set_violations;
<no rows selected>
ALTER TABLESPACE payroll_p READ ONLY;
...
expdp system/manager DIRECTORY=backup_dir DUMPFILE=exp_payroll_tbsp.dmp
LOGFILE=exp_payroll_tbsp.log TRANSPORT_TABLESPACES=payroll_p
TRANSPORT_FULL_CHECK=Y
...
destination DB:
moved over with ftp (binary mode) the datapump metadata exp_payroll_tbsp.dmp and
My env.:
Source Database: Oracle v10.1.3.0 Enterprise 32bit, RHEL AS release 3
Detination Database: Oracle 10.2.0.1 Enterprise 32bit RHEL 5
I'm having this problem when trying to transport tablespaces.
I followed the guide from Metalink Note.277650.1 and did the following on
source DB:
EXECUTE DBMS_TTS.TRANSPORT_SET_CHECK('payroll_p', TRUE);
SELECT * FROM transport_set_violations;
<no rows selected>
ALTER TABLESPACE payroll_p READ ONLY;
...
expdp system/manager DIRECTORY=backup_dir DUMPFILE=exp_payroll_tbsp.dmp
LOGFILE=exp_payroll_tbsp.log TRANSPORT_TABLESPACES=payroll_p
TRANSPORT_FULL_CHECK=Y
...
destination DB:
moved over with ftp (binary mode) the datapump metadata exp_payroll_tbsp.dmp and
0