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

[Message index]

		undo tablespace responsibility?? By: kgorgolewski on Sat, 08 August 2015 06:26
		Re: undo tablespace responsibility?? By: John Watson on Sat, 08 August 2015 06:52
		Re: undo tablespace responsibility?? By: kgorgolewski on Sat, 08 August 2015 06:58

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: Thu Apr 25 00:18:00 CDT 2024