COMPATIBLE
Oracle database 12c is compatible with version from 10.0.0.
EXPORT E IMPORT TABLESPACE A OTRA BASE DE DATOS
DETERMINING ENDIAN REQUERIMENTS
To view differents platform
set pagesize 50
set line 200SELECT PLATFORM_ID, PLATFORM_NAME, ENDIAN_FORMAT FROM V$TRANSPORTABLE_PLATFORM;
to Check for tablespace self_consistency
EXECUTE DBMS_TTS.TRANSPORT_SET_CHECK('&TABLESPACE_NAME');
TO CHECK ANY ERROR
SELECT * FROM TRANSPORT_SET_VIOLATIONS;
To view your Platform and endin format
SELECT PLATFORM_NAME MY_PLAFORM, ENDIAN_FORMAT MY_ENDIN_FORMAT
FROM V$TRANSPORTABLE_PLATFORM JOIN V$DATABASE USING(PLATFORM_NAME);
To convert Tablespace a different platform
RMAN> CONVERT DATAFILE '/ORADATA/PRUEBA.DBF' TO PLATFORM 'AIX-Based Systems (64-bit)' format '/ORADATAaix/PRUEBA_aix.DBF'
set tablespace mode read only
SELECT TABLESPACE_NAME, STATUS FROM DBA_TABLESPACES WHERE TABLESPACE_NAME='&TABLESPACE_NAME';
ALTER TABLESPACE &TABLESPACE_NAME READ ONLY;
To made a EXPORT TABLESPACE
#EXPDP DIRECTORY=DATA_PUNT_DIR DUMPFILE=ARCHIVO.DMP TRANSPORT_TABLESPACES=TABLESPACE_NAME
expdp directory=agap dumpfile=rman.exp logfile=rman.log transport_tablespace=rman
To move tablespace
(WINDOWS) REN C:\TABLESPACE_NAME.DBF D:\TABLESPACE_NAME-2.DBF
To made IMPORT TABLESPACE
note: you have to check directory, grant of directory and users who are owner within tablespace
IMPDP DIRECTORY=DATA_PUNT_DIR DUMPFILE=ARCHIVO.DMP TRANSPORT_DATAFILES='D:\TABLESPACE_NAME-2.DBF'
impdp scott/triger@pdb1 directory=agap dumpfile=rman.exp logfile=rman.imp.log TRANSPORT_DATAFILES=+DATA_GRUP/agap/594B8F8A96405680E0536538A8C0A639/DATAFILE/users01.dbf REMAP_TABLESPACE=users:users2
set tablespace mode read write
SELECT TABLESPACE_NAME, STATUS FROM DBA_TABLESPACES WHERE TABLESPACE_NAME='&TABLESPACE_NAME';
ALTER TABLESPACE TABLESPACE_NAME READ WRITE;
EXPORT E IMPORT GENERATE DATABASE TRANSPORT SCRIPT
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP MOUNT
SQL> ALTER DATABASE OPEN READ ONLY;
RMAN> CONVERT DATABASE ON TARGET PLATFORM CONVERT SCRIPT 'CNVT_SUNDB.SQL' TRANSPORT SCRIPT 'CRDB_SUNDB.SQL' NEW DATABASE 'SUNDB' TO PLATFORM 'Solaris Operating System (x86-64)' format 'c:\tmp\%U';
