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.