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.... :-)
Comments
Post a Comment