Home » RDBMS Server » Server Utilities » Loading data using external table .
Loading data using external table . [message #215662] Tue, 23 January 2007 07:13 Go to next message
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 524 times)
Re: Loading data using external table . [message #215669 is a reply to message #215662] Tue, 23 January 2007 07:45 Go to previous messageGo to next message
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
Re: Loading data using external table . [message #215670 is a reply to message #215669] Tue, 23 January 2007 07:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Instead of UTL_FILE_DIR, use create directory command for all versions 9i and above.
Re: Loading data using external table . [message #215674 is a reply to message #215670] Tue, 23 January 2007 08:02 Go to previous message
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:
  


Current Time: Wed Dec 07 02:55:13 CST 2016

Total time taken to generate the page: 0.09250 seconds