Hi All, Iam trying to take export of tablespace in database and importing it in another database, while importing oracle throwed error, here's output for your reference,
[oracle@oracleoel5 ~]$ imp file=tbspace.dmp log=tbs1.log fromuser=test1 touser=test2 transport_tablespace=y tablespaces=TBS1 datafiles='/u01/app/oracle/oradata/dump9/tbs1.dbf' destroy=y ignore=y
Import: Release 10.2.0.1.0 - Production on Wed Aug 14 18:19:41 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Username: sys/sys as sysdba
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.02.01 via conventional path
About to import transportable tablespace(s) metadata...
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00017: following statement failed with ORACLE error 29349:
"BEGIN sys.dbms_plugts.beginImpTablespace('TBS1',2,'SYS',2,0,8192,1,463082"
",1,2147483645,8,128,8,0,1,0,8,150535392,1,33,300520,NULL,0,0,NULL,NULL); EN"
"D;"
IMP-00003: ORACLE error 29349 encountered
ORA-29349: tablespace 'TBS1' already exists
ORA-06512: at "SYS.DBMS_PLUGTS", line 1801
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully