host mkdir /tmp/tong

set timing on
CREATE DIRECTORY ext_tab_dir AS '/tmp/tong';

CREATE TABLE ext_all_source
    ORGANIZATION EXTERNAL
    (
       TYPE ORACLE_DATAPUMP
       DEFAULT DIRECTORY ext_tab_dir 
       LOCATION ( 'all_source_sorted.dmp' )
    )
    AS
       SELECT * FROM all_source ORDER BY 1,2;

Elapsed: 00:00:04.39
	   
DROP TABLE ext_all_source PURGE ;

CREATE TABLE ext_all_source
    ORGANIZATION EXTERNAL
    (
       TYPE ORACLE_DATAPUMP
       DEFAULT DIRECTORY ext_tab_dir 
       LOCATION ( 'all_source_sorted.dmp' )
    )
    AS
       SELECT * FROM all_source ORDER BY 1,2;
	   
CREATE TABLE ext_all_source
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-11012: file all_source_sorted.dmp in /tmp/tong already exists
ORA-06512: at "SYS.ORACLE_DATAPUMP", line 19

host ls -lt /tmp/tong
total 35824
-rw-r--r--  1 oracle oinstall      148 Aug  9 11:49 EXT_ALL_SOURCE_30415.log
-rw-r-----  1 oracle oinstall 36638720 Aug  9 11:49 all_source_sorted.dmp

host rm -rf /tmp/tong/*

CREATE TABLE ext_all_source
    ORGANIZATION EXTERNAL
    (
       TYPE ORACLE_DATAPUMP
       DEFAULT DIRECTORY ext_tab_dir 
       LOCATION ( 'all_source_sorted.dmp' )
    )
    AS
       SELECT * FROM all_source ORDER BY 1,2;
	   
SELECT count(*) FROM ext_all_source ;

  COUNT(*)
----------
    302823

Elapsed: 00:00:00.44

desc ext_all_source
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER                                              VARCHAR2(30)
 NAME                                               VARCHAR2(30)
 TYPE                                               VARCHAR2(12)
 LINE                                               NUMBER
 TEXT                                               VARCHAR2(4000)	   
 
SELECT * from ext_all_source WHERE rownum < 2 ;

OWNER                          NAME                           TYPE
------------------------------ ------------------------------ ------------
      LINE
----------
TEXT
--------------------------------------------------------------------------------
AQADMIN                        MESSAGE_ARRAY_T                TYPE
         1
TYPE message_array_t AS TABLE OF message_t


Elapsed: 00:00:00.05

DROP TABLE ext_all_source PURGE ;

host rm -rf /tmp/tong/*

CREATE TABLE ext_all_source 
    ORGANIZATION EXTERNAL
    (
       TYPE ORACLE_DATAPUMP
       DEFAULT DIRECTORY ext_tab_dir 
       LOCATION ( 'all_source_sorted1.dmp', 'all_source_sorted2.dmp', 'all_source_sorted3.dmp', 'all_source_sorted4.dmp' )
    )
    PARALLEL 4
    AS
       SELECT * FROM all_source ORDER BY 1,2;


host ls -lt /tmp/tong
total 35900
-rw-r-----  1 oracle oinstall 9224192 Aug  9 12:05 all_source_sorted2.dmp
-rw-r-----  1 oracle oinstall 9183232 Aug  9 12:05 all_source_sorted3.dmp
-rw-r-----  1 oracle oinstall 9105408 Aug  9 12:05 all_source_sorted1.dmp
-rw-r-----  1 oracle oinstall 9162752 Aug  9 12:05 all_source_sorted4.dmp
-rw-r--r--  1 oracle oinstall      41 Aug  9 12:05 EXT_ALL_SOURCE_27317.log
-rw-r--r--  1 oracle oinstall      41 Aug  9 12:05 EXT_ALL_SOURCE_27421.log
-rw-r--r--  1 oracle oinstall      41 Aug  9 12:05 EXT_ALL_SOURCE_27523.log
-rw-r--r--  1 oracle oinstall      41 Aug  9 12:05 EXT_ALL_SOURCE_27632.log
-rw-r--r--  1 oracle oinstall      41 Aug  9 12:05 EXT_ALL_SOURCE_30415.log

SELECT /*+ PARALLEL(t,4) */ COUNT(*) FROM ext_all_source t;

  COUNT(*)
----------
    302823

Elapsed: 00:00:00.27

ALTER TABLE ext_all_source LOCATION ( 'all_source_sorted3.dmp' );

SELECT /*+ PARALLEL(t,4) */ COUNT(*) FROM ext_all_source t;

  COUNT(*)
----------
     75706

Elapsed: 00:00:00.10