| external table [message #218764] |
Fri, 09 February 2007 22:07  |
oracle_coorgi
Messages: 188
Registered: September 2006
Location: INDIA-karnataka
|
Senior Member |
|
|
CREATE TABLE testload
(
ID NUMBER,
NAME VARCHAR2(30),
FIRSTNAME VARCHAR2(30),
LASTNAME VARCHAR2(30)
)
ORGANIZATION EXTERNAL
(
TYPE oracle_loader
DEFAULT DIRECTORY load_data_dir
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ','
missing field values are null
(
ID,
NAME,
FIRSTNAME,
LASTNAME
))
LOCATION ('testload.dat')
)PARALLEL
REJECT LIMIT UNLIMITED;
how can i use no log error 04063
i dont need to logfile
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04063: unable to open log file TESTLOAD_800_3200.log
OS error The device does not recognize the command.
ORA-06512: at "SYS.ORACLE_LOADER", line 19
ORA-06512: at line 1
|
|
|
|
| Re: external table [message #218767 is a reply to message #218764] |
Fri, 09 February 2007 23:05  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
Hi,
are you create directory and grant read or write privs to ORACLE USERS.
IF YES
then check .dat file exists in right directory
if yes
then check you have OS premission on directory or you are able to access those directory.
regards
Taj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
