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