on 07-12-2008 11:43 AM
Hello,
We are doing database import for migration from informix to oracle...
When we are in the import stage we are getting the error :ORA-1562 ERROR: unable to delete data from table " "...
The size of tablespace PSAPROLL is 100 GB and we have 40 rollback segments of MINEXTENTS 10 & MAXEXTENTS 2GB...
Still we are getting this error for 7 of the 38 import processes...
What is the best solution/pre-requisite we need to follow for this error...
Thanks & Regards,
RaHuL...
Hi RaHul,
do you really use Rollback segments (that is manual UNDO MANAGEMENT) for a migration towards Oracle these days?
You're kidding me, are you !?
Since the only possible target release is Oracle 10g I propose you use the automatic UNDO MANAGEMENT.
regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Rahul,
> Even if we want to move to UNDO it can only be done after migration...
No, you can use the automatic undo management from the beginning (and also in Oracle 9i, if your sap release does not support Oracle 10g).
Also if you are in the migration process, you can change the undo management to automatic.
For the procedure take a look at sapnote #600141 - Part: "AUM -Migration procedure from MANUAL to AUTO Undo Management".
Regards
Stefan
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.