Creating external table using zip file
Hello experts,
We're trying to create an external file while using a zip file but I am getting several that I cannot seem to resolve.
Here's code to create a external test table:
drop table ACTLLIAB.TBLADMIN_POLYALLINTFC_TES2_X
/
CREATE TABLE ACTLLIAB.TBLADMIN_POLYALLINTFC_TES2_X
(
column_01 VARCHAR2(50) NULL,
column_02 VARCHAR2(50) NULL,
column_03 VARCHAR2(50) NULL,
column_04 VARCHAR2(50) NULL,
column_05 VARCHAR2(50) NULL,
column_06 VARCHAR2(50) NULL,
column_07 VARCHAR2(50) NULL,
column_08 VARCHAR2(50) NULL,
column_09 VARCHAR2(50) NULL,
column_10 VARCHAR2(50) NULL,
column_11 VARCHAR2(50) NULL,
column_12 VARCHAR2(50) NULL
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY EXTTBLFILES_POTADMIN
ACCESS PARAMETERS
(RECORDS DELIMITED BY NEWLINE
DISABLE_DIRECTORY_LINK_CHECK