Hi,

I need to change OBID of some tables, but I could not find any solution for it.
I thought that REPAIR utility can do, but I was not succeed with it yet.

Please guide me if anyone know about this topic.

Thanks,
Amir

Why do you want to change the object ID?

Hi,

There is a problem from restoring the taken backup data from tables of a region to other.

I have simple tablespace with many tables included. I need to restore some of the tables into another region with resume yes option.

But the taken backup could not restored becuase as you know at
WHEN(00001:00002 = X'000F') syntax of load CNTL , hex of OBID of table used as a key to find the specific unloaded data from whole backup which has been taken.

Unfortunatly, OBID of the sourse region is not match with destination table.
I decide to change OBID of destination table so that the data can be restored.
Otherwise, the table must be drop/define with new OBID.

I hope I could explain my problem.

thanks,
Amir

What about a DSN1COPY with the OBIDXLAT Option?