Forum Stats

  • 3,874,432 Users
  • 2,266,734 Discussions
  • 7,911,847 Comments

Discussions

expdp and imp on oci

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

Comments