Re: TTS Self-contained restriction workaround
Date: Mon, 27 Jun 2016 14:28:21 +0000
Message-ID: <TU4PR84MB02060C0FCD4E37A7610F2FFBCC210_at_TU4PR84MB0206.NAMPRD84.PROD.OUTLOOK.COM>
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Deepak Sharma <dmarc-noreply_at_freelists.org> Sent: Friday, June 24, 2016 5:43:57 PM
To: Oracle-l Digest Users
Subject: TTS Self-contained restriction workaround
The requirements for TTS metadata export/import is that all tablespaces in a group should be self-contained.
For example, if TS1 has a table that has a partition in TS9, then either move that table to TS1 or include TS9 in the group of tablespaces for metadata export.
In our environment we have lots of tables that have their partitions spread across several tablespaces.
We could include all those tablespaces in a group, but the problem is that as in example below, the TRANSPORT_TABLESPACES or TRANSPORT_DATAFILES do not allow PARALLEL degree to be set.
And, we want to use PARALLEL just becuse these tablespaces have a lots and lots of Metadata. Without parallel it would just take several hours for the export/import.
nohup impdp \"/ as sysdba\" parfile=migrate_tts.par > migrate_tts.log 2>&1 &
## migrate_tts.par
DIRECTORY=MIG_DIR
LOGFILE=MIG_TTS.log
NETWORK_LINK=ttslink
TRANSPORT_FULL_CHECK=no TRANSPORT_TABLESPACES=APP_DATA,APP_IDX,APP_DATA2 TRANSPORT_DATAFILES='/oradata/APP/APP_DATA_01.dbf','/oradata/APP/APP_IDX_01.dbf',...
-thanks
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 27 2016 - 16:28:21 CEST