Home » SQL & PL/SQL » SQL & PL/SQL » oracle external table issue (oracle 11g)
oracle external table issue [message #666537] Sun, 12 November 2017 10:42 Go to next message
POGAKU_SANTHOSH
Messages: 18
Registered: April 2017
Junior Member
Hi team,

I have a txt file which has data delimited by "TAB SPACE" and i am trying to load the data using the oet table.Here is the script below which i used to load the data . Unfortunately the data is not loading . Can any one say how to load the tab space data using oracle external table.

Script:

CREATE TABLE car_oet_laod
(
car_id VARCHAR2(500 BYTE),
car_nm VARCHAR2(500 BYTE),
car_num VARCHAR2(500 BYTE)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY LOGGING
ACCESS PARAMETERS
( records delimited by newline skip 1
logfile EXT:'CAR.txt.log'
fields terminated by '\t' OPTIONALLY ENCLOSED BY '"'
)
LOCATION (EXT:'CAR.txt')
)
REJECT LIMIT UNLIMITED
NOPARALLEL
NOMONITORING;


Thank you.
Re: oracle external table issue [message #666538 is a reply to message #666537] Sun, 12 November 2017 10:54 Go to previous messageGo to next message
John Watson
Messages: 7176
Registered: January 2010
Location: Global Village
Senior Member
I notice from your previous posts that you seem to have trouble providing any responses when people try to assist you. This may discourage people from replying.

In this particular case, that is not an issue because no one can assist if you do not show what problem you have. "Unfortunately the data is not loading" is not an Oracle error message I have seen before.
Re: oracle external table issue [message #666541 is a reply to message #666538] Sun, 12 November 2017 11:03 Go to previous messageGo to next message
POGAKU_SANTHOSH
Messages: 18
Registered: April 2017
Junior Member
My apologies sir, I will follow that suggestion from now. Regarding to the issue the oracle is not throwing any error only ".bad" file is created in the path when i check the data inside the table and the table is empty.
Re: oracle external table issue [message #666542 is a reply to message #666541] Sun, 12 November 2017 11:19 Go to previous messageGo to next message
BlackSwan
Messages: 25741
Registered: January 2009
Location: SoCal
Senior Member
What is OS name & version?

How can we reproduce what you report?

What is "EXT:"?
Re: oracle external table issue [message #666543 is a reply to message #666542] Sun, 12 November 2017 11:27 Go to previous messageGo to next message
POGAKU_SANTHOSH
Messages: 18
Registered: April 2017
Junior Member
Hie,

os :red hat linux.
product := oracle 11g.
The term ""EXT:" this is the oracle directory where the file is located . I have created a directory on the name of "EXT" i nmy linux machine.

thank you.
Re: oracle external table issue [message #666544 is a reply to message #666543] Sun, 12 November 2017 11:38 Go to previous messageGo to next message
BlackSwan
Messages: 25741
Registered: January 2009
Location: SoCal
Senior Member
https://docs.oracle.com/database/122/SUTIL/examples-of-using-oracle-external-tables.htm#SUTIL-GUID-9C61CD54-F59D-4F9F-984A-981DD984EA A7
Re: oracle external table issue [message #666546 is a reply to message #666544] Sun, 12 November 2017 11:51 Go to previous message
POGAKU_SANTHOSH
Messages: 18
Registered: April 2017
Junior Member
Thank you swan i can get a lot of information from that reply. Smile
Previous Topic: update query
Next Topic: PL/SQL: SQL Statement Ignored
Goto Forum:
  


Current Time: Sun Dec 10 18:22:04 CST 2017

Total time taken to generate the page: 0.01065 seconds