Database Utilities (MOSC)

MOSC Banner

Creating external table using zip file

edited May 21, 2016 5:00AM in Database Utilities (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center