Bill and Ted's excellent datapump



Completely pointless post really but I'll add it anyway.

When i was doing an import today i just happened to take a look at the external table definition the import process was loading from





So the DW process is just doing an insert into select blah, blah from external table - i wondered what this external table defintion actually looked like - so i used dbms_metadtaa to find that

select dbms_metadata.get_ddl('TABLE','ET$0043A3CD0001') from dual;

which returned

CREATE TABLE "ORACLE"."ET$0043A3CD0001"
   (    "PRICING_RESULT_CONTRACT" NUMBER(10,0),
        "PRICING_RESULT_PRICE" BINARY_DOUBLE,
        "PRICING_RESULT_OFFICIAL_PRICE" BINARY_DOUBLE,
        "PRICI__ULT_OFFICIAL_PRICE_DATE" DATE,
        "PRICING_RESULT_KEY" VARCHAR2(3900),
        "PRICING_RESULT_MODEL_KIND" NUMBER(10,0),
        "PRICING_RESULT_PRICING_TAG" NUMBER(10,0),
        "PRICI__T_EFFECTIVE_PRICING_TAG" NUMBER(10,0),
        "PRICI__ESULT_INITIAL_TIMESTAMP" BINARY_DOUBLE,
        "PRICING_RESULT_FINAL_TIMESTAMP" BINARY_DOUBLE,
        "PRICING_RESULT_USER" NUMBER(10,0),
        "ID" NUMBER(10,0),
        "VERSION" NUMBER(19,0),
        "PRICING_RESULT_CURRENCY" CLOB,
        "PRICI__ESULT_OFFICIAL_CURRENCY" CLOB,
        "PRICING_RESULT_ANNOTATION" CLOB,
        "PRICING_RESULT_BID_ASK" CLOB,
        "PRICING_RESULT_DESCRIPTION" CLOB,
        "PRICING_RESULT_COMMENT" CLOB,
        "PRICI__RESULT_MODEL_PARAMETERS" CLOB,
        "PRICI__KET_DATA_TRANSFORMATION" CLOB,
        "PRICI__ESULT_MARKET_DATA_QUERY" CLOB,
        "PRICI__ESULT_MARKET_DATA_ITEMS" CLOB,
        "PRICING_RESULT_EXTRAS" CLOB,
        "PRICING_RESULT_EXTRAS_SUMMARY" CLOB,
        "PRICI__MANAGED_STEPS_UNIQUEIDS" CLOB,
        "PRICING_RESULT_DATE" CLOB,
        "PRICING_RESULT_ADJUSTMENTS" CLOB,
        "PRICING_RESULT_PROPERTIES" CLOB,
        "PRICING_RESULT_CREDIT_SPREAD" CLOB
   )
   ORGANIZATION EXTERNAL
    ( TYPE ORACLE_DATAPUMP
      DEFAULT DIRECTORY "DATA_PUMP_DIR"
      ACCESS PARAMETERS
      ( DEBUG = (0 , 0) DATAPUMP INTERNAL TABLE "LEXIFI_MONSTER"."PRICING_RESULTS"
JOB ( "ORACLE","SYS_IMPORT_SCHEMA_01",1)
 WORKERID 1 PARALLEL 1 VERSION '11.2.0.1' ENCRYPTPASSWORDISNULL  COMPRESSION DISABLED  ENCRYPTION DISABLED     )
      LOCATION
       ( 'bogus.dat'
       )
    )
   REJECT LIMIT UNLIMITED


So it seems to be doing some funky internal stuff - what amused me though was that the dummy file it's using was called bogus.dat - someone still stuck in the 90's wrote this code maybe.... :-)



0 comments:

Post a Comment