Rollback in Sql * loader [message #274188] |
Sun, 14 October 2007 23:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rk1982
Messages: 24 Registered: September 2007
|
Junior Member |
|
|
Hi,I want to rollback all records of a file,if loading of that file through sql* loader is not successful.
Can you please help me how to do it.
|
|
|
|
|
|
|
Re: Rollback in Sql * loader [message #274229 is a reply to message #274227] |
Mon, 15 October 2007 02:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rk1982
Messages: 24 Registered: September 2007
|
Junior Member |
|
|
See i try to run attached sql.The external table is created but when i am trying to select it its giving me error.
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "date_format": expecting one of: "binary_double, binary_float, comma, char, date, defaultif, decimal, double, float, integer, nullif, oracle_date, oracle_number, raw, ), unsigned, varrawc, varchar, varraw, varcharc, zoned"
KUP-01007: at line 8 column 28
ORA-06512: at "SYS.ORACLE_LOADER", line 19
-
Attachment: Load.sql
(Size: 0.69KB, Downloaded 1199 times)
|
|
|
|
|
|
Re: Rollback in Sql * loader [message #274259 is a reply to message #274246] |
Mon, 15 October 2007 04:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rk1982
Messages: 24 Registered: September 2007
|
Junior Member |
|
|
Sir,Directory is on server only on which oracle is installed.
I am using AIX.can me idea how to check oracle have acess to directory.
resolve my problem
arbor@billdev:/arbor1/arbor/Rohit 102 : ls -l a.dat
-rwxrwxrwx 1 arbor arboradm 176 Oct 11 23:48 a.dat
arbor@billdev:/arbor1/arbor/Rohit 103 :
arbor@billdev:/oracle/product/9206 112 :
[mod-edit] removed illiterate IM speak.
[Updated on: Mon, 15 October 2007 08:08] by Moderator Report message to a moderator
|
|
|
Re: Rollback in Sql * loader [message #274274 is a reply to message #274259] |
Mon, 15 October 2007 05:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Connect as the OS oracle instance owner and execute:
$ id
$ groups
$ ps -eaf | grep smon
$ head /arbor1/arbor/Rohit/a.dat
Regards
Michel
|
|
|