Database Utilities (MOSC)

MOSC Banner

Datapump transportable tablespaces problem

edited Oct 8, 2009 12:57AM in Database Utilities (MOSC) 5 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center