I created a folder on Oracle Server the path:
C:\Data2016\SourceNTFFor
Using the excellent article that is clear and explains the process.
https://paulzipblog.wordpress.com/2017/04/17/oracle-external-tables-part-1/
CREATE OR REPLACE DIRECTORY NTF_SOURCE_ORACLE AS C:\Data2016\SourceNTFFor';
-- directory NTF_SOURCE_ORACLE created.
GRANT READ, WRITE
ON DIRECTORY NTF_SOURCE_ORACLE
TO PUBLIC;
CREATE TABLE T_NTF_2017 (
NTF VARCHAR2(15)
)
ORGANIZATION external
(
TYPE oracle_loader
DEFAULT DIRECTORY NTF_SOURCE_ORACLE
ACCESS PARAMETERS
(
RECORDS DELIMITED BY 0X'0D'
SKIP 1
BADFILE 'NTF2017.bad'
LOGFILE 'NTF2017.log'
FIELDS TERMINATED BY ", "
(
NTF
)
)
LOCATION('NTF.txt')
)
PARALLEL
REJECT LIMIT 100;
I can see the Oracle directory (T_NTF_2017) and external folder (NTF).
copied from the Schema - Oracle directory and external folder
When I click on T_NTF_2017, don't get an error, I can see the table.
There are no records??
SELECT *
FROM T_NTF_2017
NTF
---------------
I thought that the external folder would allow me to query the text file (NTF.txt) using a SQL statement??
Seems that there is a step missing??