Home » RDBMS Server » Server Utilities » Transportable tablespace. (Oracle 9i)
Transportable tablespace. [message #531210] Mon, 14 November 2011 07:25
estonolose
Messages: 4
Registered: October 2011
Junior Member
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.
Previous Topic: Slow exports using exp command due to open sessions
Next Topic: ORA-01652: unable to extend temp segment by 8192 in tablespace IDX_TAB
Goto Forum:
  


Current Time: Sat Feb 29 08:01:56 CST 2020