Home » RDBMS Server » Server Utilities » Roll BAck during SQL*LOADER execution
Roll BAck during SQL*LOADER execution [message #252778] Thu, 19 July 2007 23:55 Go to next message
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!
Re: Roll BAck during SQL*LOADER execution [message #252780 is a reply to message #252778] Fri, 20 July 2007 00:01 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: Roll BAck during SQL*LOADER execution [message #252793 is a reply to message #252778] Fri, 20 July 2007 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
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
Re: Rollback during SQL*LOADER execution [message #252794 is a reply to message #252778] Fri, 20 July 2007 00:52 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Your best option is to load to a temp table before inserting to the main table.
Re: Rollback during SQL*LOADER execution [message #252815 is a reply to message #252794] Fri, 20 July 2007 01:35 Go to previous messageGo to next message
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.
Re: Rollback during SQL*LOADER execution [message #252820 is a reply to message #252815] Fri, 20 July 2007 02:50 Go to previous message
Michel Cadot
Messages: 64151
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
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:
  


Current Time: Fri Dec 09 22:58:20 CST 2016

Total time taken to generate the page: 0.13101 seconds