Home » SQL & PL/SQL » SQL & PL/SQL » Transaction log
Transaction log [message #210583] Thu, 21 December 2006 07:20 Go to next message
Messages: 3
Registered: December 2006
Junior Member
I have to insert data from one set of tables( 18-20) to corresponding table of another user.So for data migration should i create my own log record for every insert transaction or can i use lof of ORACLE itself.If yes plz tell which tables to use.
Does it advisable to open, write and then close files time and again to record transactions results or is it better to use oracle log records??plz clarify..
Re: Transaction log [message #210683 is a reply to message #210583] Thu, 21 December 2006 14:42 Go to previous message
Messages: 21151
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do those users see each other (either in the same database or through a database link)? If so, you could directly insert data from first schema to another. Error logging could be done directly (using LOG ERRORS INTO if your database version supports it), or create your own logic (using a PL/SQL block with exception handler).

Otherwise, do an export of those tables from first schema and import it into second one. Import offers a LOG file which will tell you what happened during import session.
Previous Topic: SELECT within INSERT
Goto Forum:

Current Time: Wed Aug 23 22:17:46 CDT 2017

Total time taken to generate the page: 0.12268 seconds