Home » RDBMS Server » Server Utilities » Transportable tablespace. (Oracle 9i)
Transportable tablespace. [message #531210] Mon, 14 November 2011 07:25
Messages: 5
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.


And this is the import

# imp \'/ as sysdba\' parfile=parfile_IMP_TS_PRUEBA.par

Import: Release - Production on Lun Nov 14 13:56:43 2011

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to: Oracle9i Enterprise Edition Release - 64bit Production
With the Partitioning and OLAP options
JServer Release - 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"
 ",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

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 Jul 31 14:44:01 CDT 2021