kkdxCheckClobProperty error during tablespaces import

[Former Member]

Hi experts,

I am facing some error during tablespaces import by brttols according to

1003028 - Extended support for database copy in BR*Tools

ORA-07445: exception encountered: core dump [kkdxCheckClobProperty()+86]  на таблице BEGIN

....

SYS.DBMS_PLUGTSP.PATCHTABLEMETADATA('SAPSR3','ACTESTREPCONTENT',:1,:2,:3);END;

There is hardly information in internet to find some solution for this situation

Bug 21082466 : EXADATA: ORA 7445 [KKDXCHECKCLOBPROPERTY+86] ON TTS IMPORT

Bug 15859528 : ORA-7445 [KKDXCHECKCLOBPROPERTY()+119] ON TTS IMPORT

The mentioned table is empty and it has got two hidden columns

SYS_C00003_13112915:01:40$

SYS_C00002_13112915:01:40$

Can these two columns be the reason of the error?

Is there any way to resolve the situation?

Regards, Evgeniy

[Former Member · Accepted solution]

Solution

before export a source database

it is necessary to check the source database whether some tables contain unused columns          

and drop unused columns according to

1815989 - BW InfoCube Repartitioning fails with ora-14097 error

1891692 - Got ORA-01792 error when activate the table after adding a new field

856417 - Metadata export of tablespace fails with BR0740E          

or reorg the tables with brtools

646681 - Reorganization of tables with BRSPACE

Regards, Yevgeniy

[Brindavan_M]

Hi Evgeniy,

Try to increase you SGA_TARGET (and or SGA_MAX_SIZE) if you are using automatic memory management to handle the SGA components. If not, increase the SHARED_POOL_SIZE.

chcek the table LOB datatype, Only NUMBER,VARCHAR2,DATE and LONG.

Thanks,

Brindavan

[Former Member]

Dear Brindavan,

I think the reason is not related to any memory problem.

The error is raised by some metadata inconsistence.

Regards, Evgeniy