cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-1562

Former Member
0 Kudos

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...

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Thanks Lars,

We are migrating from informix to oracle as i have already said..

Even if we want to move to UNDO it can only be done after migration...

Can you suggest a solution for the error though before i move to UNDO?

Thanks,

RaHuL..

stefan_koehler
Active Contributor
0 Kudos

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

Answers (0)