Home » RDBMS Server » Server Administration » undo tablespace responsibility?? (oracle 11gR2)
icon4.gif  undo tablespace responsibility?? [message #640986] Sat, 08 August 2015 06:26 Go to next message
kgorgolewski
Messages: 2
Registered: August 2015
Junior Member
hi, we are having the following setup: local db (let's name it a) and remote db (name b). we are selecting from remote b a huge amount (several million records) of data and inserting it into local a, which is taking a long time related to the amount of data and/or business of remote db b. it is always a sql statement like this executed:

insert into a.localtable
select * from b.remotetable
where b.recorddate=trunc(sysdate)-1;

but regularly we are getting ora-15555 (or similar...related to undo tablespace is not enough or undo retention value is too small).

for this situation: who is responsible for the undo tablespace/retention? the local db a or remote db b?

would be happy to clarify this question Smile
Re: undo tablespace responsibility?? [message #640988 is a reply to message #640986] Sat, 08 August 2015 06:52 Go to previous messageGo to next message
John Watson
Messages: 7220
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

It is the remote db B, where the query is running. You'll see detail in B's alert log.
Re: undo tablespace responsibility?? [message #640990 is a reply to message #640988] Sat, 08 August 2015 06:58 Go to previous message
kgorgolewski
Messages: 2
Registered: August 2015
Junior Member
ok thanks a lot john! Smile
Previous Topic: How to join DBA_TYPE_METHODS and DBA_ARGUMENTS
Next Topic: Ora-01031 error when reading Oracle SGA
Goto Forum:
  


Current Time: Sun Jan 21 09:29:44 CST 2018

Total time taken to generate the page: 0.04442 seconds