Skip to Content
0
Former Member
Dec 28, 2007 at 04:04 AM

Need help regarding PSAPUNDO and PSAPTEMP in context of client copy

665 Views

Hi,

I am trying to take a remote copy ( prof = sap_all ) from production system to quality.

The whole database size is nearly 80 GB ( we have one integration testing client on production system, means it also contribues to this 80 GB ).

I had created a tablespace PSAPROLLBIG of 2GB for client copy purpose. But it gave an error ORA 1562 - failed to extend rollback seg PRS_BIG

So I increased the size to 4 GB and got the same error again.

Next I implemented oracle AUM with 5GB space allocated to PSAPUNDO. and got error ORA-30036: unable to extend segment in undo tablespace.

Next I tried to change the undo_retention parameter from 12h ( SAP suggested ) to 2h and increased PSAPUNDO by 5GB more.

Now this time I am getting error for PSAPTEMP.

Current size of PSAPTEMP is 358 MB

On this background I want to get some clarification on following.

1. what will be the difference in use of PSAPUNDO and PSAPTEMP while copy is running. ( i.e. what will be entered in PSAPUNDO and what will be filled in PSAPTEMP.)

2. the target client already has a copy taken 1 month before. so I think while importing it first delete existing data and then copies the new one.

So If I first delete the target client and then take import on it; will it have advantage in regards of getiing UNDO or TEMP segments getting filled ?

Please gie your suggestions. and any more suggestion to help me getting the copy done successfully. Should I have to take into account anything else before starting import.

( Please let me know if I am not clear to describe the problem ).

Thanks.

---Shamish.