Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

expdp and imp on oci

ramesh kumarSep 27 2022

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

  1. 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.
  2. 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

Anuj Dwivedi-Oracle
Hi kamil,

Your question is not very clear. If I understood right, then you are talking about the scenario when Oracle B2B sends message to it's remote TP(outbound case) and Remote TP's server has client authentication enabled.

If above is the case, then you just enable SSL at your B2B by following below link and rest would be done at the runtime -

http://www.b2bgurus.com/2007/08/ssl-setup-for-oracle-as-b2b.html

If you want to enable client authentication at your B2B server, then please refer SSL Client Authentication section of below doc -

http://www.oracle.com/technology/products/integration/b2b/pdf/B2B_TN_023_SSL.pdf

Note :- By default client authentication remains turned off.

Regards,
Anuj

Edited by: Anuj Dwivedi, Infosys on Aug 6, 2009 6:27 PM
1 - 1

Post Details

Added on Sep 27 2022
1 comment
102 views