expdp and imp on oci

User_E03DK

i am taking export dump from one schema.All the tables in that schema stored in one tablespace the tablespace name is TRTSDATA01(/u01/app/oracle/trtsdata01.dbf')

this is the structue

 CREATE TABLE "SYMPHONY_INV_OCI"."EMP" 

  ( "EMPNO" NUMBER, 

"ENAME" VARCHAR2(20 BYTE)

  ) SEGMENT CREATION IMMEDIATE 

 PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 

 NOCOMPRESS LOGGING

 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

 TABLESPACE "TSTRDATA01" ;

2) Now i created one schema in anther server the default tablespace is TRTSDATA001 (it is a ASM). Here by mistake one TRTSDATA01 tablespace created earlier.

3) while impoting all the tables are going to insert TRTSDATA01 not inserting TRTSDATA001 (it is a ASM) because while exporting tables are expoting with structure, in that structure the

tablespace is TRTSDATA01.

like this  CREATE TABLE "SYMPHONY_INV_OCI"."EMP" 

  ( "EMPNO" NUMBER, 

"ENAME" VARCHAR2(20 BYTE)

  ) SEGMENT CREATION IMMEDIATE 

 PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 

 NOCOMPRESS LOGGING

 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

 TABLESPACE "TSTRDATA01" ;

JohnWatson2

Perhaps the REMAP_TABLESPACE parameter of impdp?