[oracle@aggs00.test for_test]$ ls -l aggs_day_conversion_agg_2419
-rw-r----- 1 oracle oracle 15917056 Aug 10 09:06 aggs_day_conversion_agg_2419

CREATE TABLE IMP_3251198_2419(
    PARTITION_DATE DATE,
    USER_ID         NUMBER,
    SID             NUMBER,
    ACCOUNT_ID      NUMBER,
    EX_CAMPAIGN_ID  NUMBER,
    EX_ADGROUP_ID   NUMBER,
    EX_TERM_ID      NUMBER,
    EX_CREATIVE_ID  NUMBER,
    EF_HASH_ID      NUMBER,
    CONVERSION_TYPE VARCHAR2(4000),
    CONVERSIONS     NUMBER,
    LAST_UPDATE     DATE) 
ORGANIZATION EXTERNAL 
( TYPE ORACLE_DATAPUMP
  DEFAULT DIRECTORY "FOR_TEST"
  ACCESS PARAMETERS (NOLOGFILE)
  LOCATION("FOR_TEST":'aggs_day_conversion_agg_2419')
);

SQL> select * from IMP_3251198_2419 where rownum < 2;
 
PARTITION_DATE    USER_ID        SID ACCOUNT_ID EX_CAMPAIGN_ID EX_ADGROUP_ID EX_TERM_ID EX_CREATIVE_ID EF_HASH_ID CONVERSION_TYPE                                                                  CONVERSIONS LAST_UPDATE
-------------- ---------- ---------- ---------- -------------- ------------- ---------- -------------- ---------- -------------------------------------------------------------------------------- ----------- -----------
2012-06-01           2419          3  100000762       13413968     539952308 2293111868    13153197728 2897334409 Lead                                                                                       1 2012-06-06
 
Executed in 1800.642 seconds