OraFAQ Forum: Server Utilities » Loading data using external table .

Home » RDBMS Server » Server Utilities » Loading data using external table .

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

Loading data using external table . [message #215662]

Tue, 23 January 2007 07:13

kanis
Messages: 61
Registered: November 2006

Member

I have tried to load data in to database table ,using the folowing script

CREATE TABLE test (personid VARCHAR2(20),
Name VARCHAR2(40),
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY LOG_DIR
ACCESS PARAMETERS
(
records delimited by newline
)
LOCATION ('revext.dat')
)
PARALLEL 4
REJECT LIMIT UNLIMITED;
#######################################

But getting the following errors.
Pls guide me how i can resolve the error??

Attachment: Upload.doc
(Size: 29.50KB, Downloaded 1556 times)

Report message to a moderator

Re: Loading data using external table . [message #215669 is a reply to message #215662]

Tue, 23 January 2007 07:45

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

Are you set UTL_FILE_DIR parameter for directory in init.ora file.

first set directory for external tables.

regards
Taj

Report message to a moderator

Re: Loading data using external table . [message #215670 is a reply to message #215669]

Tue, 23 January 2007 07:54

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Instead of UTL_FILE_DIR, use create directory command for all versions 9i and above.

Report message to a moderator

Re: Loading data using external table . [message #215674 is a reply to message #215670]

Tue, 23 January 2007 08:02

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

HI,

Instead of UTL_FILE_DIR, use create directory command for all versions 9i and above.

and grant READ or WRITE permission to users.

regards
Taj

[Updated on: Tue, 23 January 2007 08:02]

Report message to a moderator

Previous Topic:	Query regarding importing DUMP file
Next Topic:	IMPDP: How to update table, if primary-key already exists?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 21:43:46 CST 2024