Database Reference
In-Depth Information
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Username: sys as sysdba
Password:
Connected to: Oracle Database 12c Enterprise Edition
Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing
options
Starting "SYS"."SYS_EXPORT_TRANSPORTABLE_01":
sys/******** AS SYSDBA dumpfile=e
xpdat.dmp DIRECTORY=EXP_DIR TRANSPORT_TABLESPACES= user_data
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/INDEX
Processing object type TRANSPORTABLE_EXPORT/CONSTRAINT/CONSTRAINT
Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Master table “SYS”.”SYS_EXPORT_TRANSPORTABLE_01” successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TRANSPORTABLE_01 is:
C:\TEMP\EXPDAT.DMP
******************************************************************************
Datafiles required for transportable tablespace USER_DATA:
C:\ORACLE\ORADATA\ORCL\USER_DATA01.DBF
Job "SYS"."SYS_EXPORT_TRANSPORTABLE_01" successfully completed at 20:41:47
Once the export is complete, if no endian conversion is required you can move on to the
step of transporting the tablespace set. If endian conversion is required and you want to run
the conversion on the target system, move on to that step. Otherwise, endian conversion is
required locally and you'll need to invoke RMAN on the source system as follows:
C:\>RMAN TARGET /
RMAN> convert tablespace user_data
2> to platform 'Solaris[tm] OE (32-bit)'
3> format 'c:\temp\%U';
Starting conversion at source at 21-OCT-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile conversion
input datafile file number=00006 name=C:\ORACLE\ORADATA\ORCL\USER_DATA01.DBF
converted datafile=C:\TEMP\DATA_D-ORCL_I-1190467526_TS-
Search WWH ::
Custom Search