OraFAQ Forum: SQL & PL/SQL » oracle external table issue

Home » SQL & PL/SQL » SQL & PL/SQL » oracle external table issue (oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle external table issue [message #666537]

Sun, 12 November 2017 10:42

POGAKU_SANTHOSH
Messages: 39
Registered: April 2017

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.

Report message to a moderator

Re: oracle external table issue [message #666538 is a reply to message #666537]

Sun, 12 November 2017 10:54

John Watson
Messages: 8997
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.

Report message to a moderator

Re: oracle external table issue [message #666541 is a reply to message #666538]

Sun, 12 November 2017 11:03

POGAKU_SANTHOSH
Messages: 39
Registered: April 2017

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.

Report message to a moderator

Re: oracle external table issue [message #666542 is a reply to message #666541]

Sun, 12 November 2017 11:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What is OS name & version?

How can we reproduce what you report?

What is "EXT:"?

Report message to a moderator

Re: oracle external table issue [message #666543 is a reply to message #666542]

Sun, 12 November 2017 11:27

POGAKU_SANTHOSH
Messages: 39
Registered: April 2017

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.

Report message to a moderator