OraFAQ Forum: Server Utilities » Roll BAck during SQL*LOADER execution

Home » RDBMS Server » Server Utilities » Roll BAck during SQL*LOADER execution

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

Roll BAck during SQL*LOADER execution [message #252778]

Thu, 19 July 2007 23:55

suvrodip
Messages: 3
Registered: July 2007
Location: kolkata

Junior Member

Hi,
I would like to know whether there is any way to rollback the data entered into the table using SQL*LOADER in case any error occurs during execution.
Please help!

Report message to a moderator

Re: Roll BAck during SQL*LOADER execution [message #252780 is a reply to message #252778]

Fri, 20 July 2007 00:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I hope you have good backups.
Comitted data is comitted data.
There is no rollback after COMMIT; only restore from backup.

Report message to a moderator

Re: Roll BAck during SQL*LOADER execution [message #252793 is a reply to message #252778]

Fri, 20 July 2007 00:50

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Reported By: suvrodip On: Fri, 20 July 2007 06:56 In: RDBMS Server � Server Utilities � Roll BAck during SQL*LOADER execution
Reason I need the reply as soon as possible

It is useless to report to get more attention.
Nothing is urgent in forum, you'll get an answer when you'll get it, if ever you'll get one.

If you need an urgent help, pick up your phone and hire a consultant.

Regards
Michel

Report message to a moderator

Re: Rollback during SQL*LOADER execution [message #252794 is a reply to message #252778]

Fri, 20 July 2007 00:52

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Your best option is to load to a temp table before inserting to the main table.

Report message to a moderator

Re: Rollback during SQL*LOADER execution [message #252815 is a reply to message #252794]

Fri, 20 July 2007 01:35

suvrodip
Messages: 3
Registered: July 2007
Location: kolkata

Junior Member

The log file keeps a track of the number of rows fetched from a CSV file.Which parameter in the log file keeps a track of this?Can this parameter be used in control file in any way?

Sorry Michel,it was not for drawing extra attention.It's just that am using such forums for the first time.No harrasement was intended.

Report message to a moderator

Re: Rollback during SQL*LOADER execution [message #252820 is a reply to message #252815]

Fri, 20 July 2007 02:50

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

OK.

You could use external table instead of SQL*Loader then you'd have the whole power of SQL to check your data, load what you want as you want and so on.

Regards
Michel

Report message to a moderator

Previous Topic:	using Export Data Pump/Import Data Pump in oracle 9.2
Next Topic:	SQL LOADER : How to specify sysdate with infile name?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 22:06:11 CDT 2024