5 Replies Latest reply: Dec 12, 2012 8:41 AM by Facundo RSS

    I can export a table with Export but not with Data Pump

    Facundo
      Hello Guys,

      I have a symptom I don´t understand in an Oracle Database 10.1.0.5. I am able to export a table with Export Utility, but I am not able export it with Export Data Pump Utility. The strange thing is that the table is a simple table.

      I don´t realize if this table has a restriction for using Data Pump.

      Can you help me?

      This is the structure table:
      CREATE TABLE PORTAL.WWDAV$PATH
      (
        SUBSCRIBER_ID  NUMBER                         DEFAULT SYS_CONTEXT('WEBDB_VPD_CTX','SUBSCRIBER_ID') NOT NULL,
        PATH           VARCHAR2(3200 BYTE),
        PARENTPATH     VARCHAR2(3200 BYTE),
        DOC_ID         INTEGER,
        ELEMENT_TYPE   VARCHAR2(1 BYTE)
      )
      TABLESPACE PORTAL
      PCTUSED    40
      PCTFREE    10
      INITRANS   1
      MAXTRANS   255
      STORAGE    (
                  INITIAL          64K
                  MINEXTENTS       1
                  MAXEXTENTS       UNLIMITED
                  PCTINCREASE      0
                  FREELISTS        1
                  FREELIST GROUPS  1
                  BUFFER_POOL      DEFAULT
                 )
      LOGGING 
      NOCOMPRESS 
      NOCACHE
      NOPARALLEL
      MONITORING;
      
      
      CREATE INDEX PORTAL.WWDAV$ORADAVD ON PORTAL.WWDAV$PATH
      (SUBSCRIBER_ID, DOC_ID)
      LOGGING
      TABLESPACE PORTAL
      PCTFREE    10
      INITRANS   2
      MAXTRANS   255
      STORAGE    (
                  INITIAL          64K
                  MINEXTENTS       1
                  MAXEXTENTS       UNLIMITED
                  PCTINCREASE      0
                  FREELISTS        1
                  FREELIST GROUPS  1
                  BUFFER_POOL      DEFAULT
                 )
      NOPARALLEL;
      
      
      CREATE INDEX PORTAL.WWDAV$ORADAVPP ON PORTAL.WWDAV$PATH
      (SUBSCRIBER_ID, PARENTPATH)
      LOGGING
      TABLESPACE PORTAL
      PCTFREE    10
      INITRANS   2
      MAXTRANS   255
      STORAGE    (
                  INITIAL          64K
                  MINEXTENTS       1
                  MAXEXTENTS       UNLIMITED
                  PCTINCREASE      0
                  FREELISTS        1
                  FREELIST GROUPS  1
                  BUFFER_POOL      DEFAULT
                 )
      NOPARALLEL;
      
      
      CREATE UNIQUE INDEX PORTAL.WWDAV$PKPATH ON PORTAL.WWDAV$PATH
      (SUBSCRIBER_ID, PATH)
      LOGGING
      TABLESPACE PORTAL
      PCTFREE    10
      INITRANS   2
      MAXTRANS   255
      STORAGE    (
                  INITIAL          64K
                  MINEXTENTS       1
                  MAXEXTENTS       UNLIMITED
                  PCTINCREASE      0
                  FREELISTS        1
                  FREELIST GROUPS  1
                  BUFFER_POOL      DEFAULT
                 )
      NOPARALLEL;
      
      
      CREATE OR REPLACE TRIGGER PORTAL.wwdav$ipath
        AFTER INSERT ON wwdav$path
        FOR EACH ROW
      BEGIN
          -- Triggers on VPD table should not be fired when VPD seed
          -- data copy is in progress.  They should check seed copy flag
          -- first, and exit if the flag is on.
          if wwctx_api_vpd.seed_copy_is_in_progress then
              return;
          end if;
      
          --
          -- Triggers should not be fired when the schema validation
          -- utility is in progress. This should check the flag
          -- and exit if the flag is on.
          --
          if wwutl_schema_validation.is_in_progress then
              return;
          end if;
      
          UPDATE wwdav$asl
            SET PATHCOUNT = PATHCOUNT + 1
          WHERE doc_id = :new.doc_id;
        END;
      /
      
      
      CREATE OR REPLACE TRIGGER PORTAL.wwdav$dpath
        AFTER DELETE ON wwdav$path
        FOR EACH ROW
      BEGIN
          -- Triggers on VPD table should not be fired when VPD seed
          -- data copy is in progress.  They should check seed copy flag
          -- first, and exit if the flag is on.
          if wwctx_api_vpd.seed_copy_is_in_progress then
              return;
          end if;
      
          --
          -- Triggers should not be fired when the schema validation
          -- utility is in progress. This should check the flag
          -- and exit if the flag is on.
          --
          if wwutl_schema_validation.is_in_progress then
              return;
          end if;
      
          UPDATE wwdav$asl
            SET PATHCOUNT = PATHCOUNT - 1
          WHERE doc_id = :old.doc_id;
        END;
      /
      
      
      ALTER TABLE PORTAL.WWDAV$PATH ADD (
        CONSTRAINT WWDAV$CKPATH
        CHECK (element_type IN ('M','C')),
        CONSTRAINT WWDAV$PKPATH
        PRIMARY KEY
        (SUBSCRIBER_ID, PATH)
        USING INDEX PORTAL.WWDAV$PKPATH);
      
      ALTER TABLE PORTAL.WWDAV$PATH ADD (
        CONSTRAINT WWDAV$FKPARENTP 
        FOREIGN KEY (SUBSCRIBER_ID, PARENTPATH) 
        REFERENCES PORTAL.WWDAV$PATH (SUBSCRIBER_ID,PATH)
        DEFERRABLE INITIALLY DEFERRED,
        CONSTRAINT WWDAV$FKPATH 
        FOREIGN KEY (SUBSCRIBER_ID, DOC_ID) 
        REFERENCES PORTAL.WWDAV$ASL (SUBSCRIBER_ID,DOC_ID)
        DEFERRABLE INITIALLY DEFERRED);
      Thanks.