I have an export of transportable tablespaces. The export have 7 tablespaces and I want to import only 6. Is it posible?
This is the parfile.
TRANSPORT_TABLESPACE=y
FILE=EXP_TBS_PRUEBA.dmp
LOG=imp_TS_TODOS.log
DATAFILES=('/oradata/ts_hist_1_01.dbf',......'/oradata/ts_hist6_02.dbf')
TABLESPACES=(TS_HIST_1, ....., TS_HIST_6)
ignore=y
And this is the import
# imp \'/ as sysdba\' parfile=parfile_IMP_TS_PRUEBA.par
Import: Release 9.2.0.8.0 - Production on Lun Nov 14 13:56:43 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning and OLAP options
JServer Release 9.2.0.8.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
About to import transportable tablespace(s) metadata...
import done in WE8ISO8859P15 character set and AL16UTF16 NCHAR character set
. importing SYS's objects into SYS
IMP-00017: following statement failed with ORACLE error 29347:
"BEGIN sys.dbms_plugts.beginImpTablespace('TS_HIST_7',175"
",'SYS',3,0,8192,1,107425996387,1,2147483645,8,128,8,0,1,0,8,4271032286,1,33"
",16949033687,NULL,0,0,NULL,NULL); END;"
IMP-00003: ORACLE error 29347 encountered
ORA-29347: Tablespace name validation failed - failed to match tablespace 'TS_HIST_7'
ORA-06512: at "SYS.DBMS_PLUGTS", line 1500
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully
Thanks.