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" ;
- 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.
- 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" ;