OraFAQ Forum: Server Administration » undo tablespace responsibility??

Home » RDBMS Server » Server Administration » undo tablespace responsibility?? (oracle 11gR2)

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

undo tablespace responsibility?? [message #640986]

Sat, 08 August 2015 06:26

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

Report message to a moderator

Re: undo tablespace responsibility?? [message #640988 is a reply to message #640986]

Sat, 08 August 2015 06:52

John Watson
Messages: 8976
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.

Report message to a moderator

Re: undo tablespace responsibility?? [message #640990 is a reply to message #640988]

Sat, 08 August 2015 06:58

kgorgolewski
Messages: 2
Registered: August 2015

Junior Member

ok thanks a lot john! Smile

Report message to a moderator

Previous Topic:	How to join DBA_TYPE_METHODS and DBA_ARGUMENTS
Next Topic:	Ora-01031 error when reading Oracle SGA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 14:26:13 CDT 2025