Home » RDBMS Server » Backup & Recovery » external table
external table [message #218764] Fri, 09 February 2007 22:07 Go to next message
oracle_coorgi
Messages: 185
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 Go to previous message
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
Previous Topic: DELETE backup job failing
Next Topic: need for hot backup script.and schedule
Goto Forum:
  


Current Time: Sat Dec 10 05:25:59 CST 2016

Total time taken to generate the page: 0.24990 seconds