Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

problem on external table

Hi all, I have problems on display records from my external table.

This is the statement I have used to create my external table:

CREATE TABLE preview_h7
(
col1 number,

col2 number

col3 number
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY PROG_EXTRA
ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
LOGFILE PROG_EXTRA:'H7_LOG.LOG'
)
LOCATION( 'input_h7.txt')
)
REJECT LIMIT UNLIMITED ;

My record are enclosed by " and separator is ;

Here is an example of my record:

"1";"1";"223101"

Table is created eithout errors, but when I access from sql developer to the table, I don't see any records.

Can anyone help me to find why I don't see any records from sql developer?

Thanks in advance,

Fabrizio

Comments
Post Details
Added 5 days ago
4 comments
60 views