Source:In this machine size of database
block is 8K.
1) In source
machine create one tablespace TTS and create user TTS and assign default tablespace to TTS user
as TTS tablespace.
2)exec
dbms_tts.transport_set_check(‘TTS’);
3)Check for
violations using
Select *
from transport_set_violations;
4)keep
tablespace TTS in read only
Alter tablespace
TTS read only;
5)$ exp
file=tts.dmp TABLESPACES=TTS TRANSPORT_TABLESPACE=Y
Username/password:-
sys as sysdba
6)copy
dumpfile and datafile to destination machine
Destination:- In this machine size of
database block is 4K
Add
following parameter in pfile
Db_8K_cache_size=200M
Perform
import using below command
[oracle5@fed01
~]$ imp file=tts.dmp TABLESPACES=TTS TRANSPORT_TABLESPACE=Y DATAF
ILES='/u02/oradata/tts/tts01.dbf'
Import:
Release 11.2.0.1.0 - Production on Thu Jul 18 04:25:22 2013
Copyright
(c) 1982, 2009, Oracle and/or its affiliates.
All rights reserved.
Username: /
as sysdba
Connected
to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the
Partitioning, OLAP, Data Mining and Real Application Testing options
Export file
created by EXPORT:V11.02.00 via conventional path
About to
import transportable tablespace(s) metadata...
import done
in US7ASCII character set and AL16UTF16 NCHAR character set
. importing
SYS's objects into SYS
. importing
SYS's objects into SYS
. importing
TTS's objects into TTS
. .
importing table "TTS1"
. importing
SYS's objects into SYS
Import
terminated successfully without warnings.
Note If we don’t
mention db_8k_cache_size in pfile it will give following error
Export file
created by EXPORT:V11.02.00 via conventional path
About to
import transportable tablespace(s) metadata...
import done
in US7ASCII character set and AL16UTF16 NCHAR character set
. importing
SYS's objects into SYS
. importing
SYS's objects into SYS
IMP-00017:
following statement failed with ORACLE error 29339:
"BEGIN
sys.dbms_plugts.beginImpTablespace('TTS',5,'SYS',1,0,8192,1,322450,"
"1,2147483645,8,128,8,0,1,2147483645,8,1197301176,1,4129,321958,NULL,0,0,NUL"
"L,NULL); END;"
IMP-00003:
ORACLE error 29339 encountered
ORA-29339:
tablespace block size 8192 does not match configured block sizes
ORA-06512:
at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512:
at "SYS.DBMS_PLUGTS", line 1682
ORA-06512:
at "SYS.DBMS_PLUGTS", line 1813
ORA-06512:
at line 1
IMP-00000:
Import terminated unsuccessfully
[oracle5@fed01
~]$ oerr ora 29339
29339,
00000, "tablespace block size %s does not match configured block
sizes"
//
*Cause: The block size of the tablespace
to be plugged in or
// created does not match the block
sizes configured in the
// database.
//
*Action:Configure the appropriate cache for the block size of this
// tablespace using one of the various
(db_2k_cache_size,
// db_4k_cache_size, db_8k_cache_size,
db_16k_cache_size,
// db_32K_cache_size) parameters.
