Skip to Content
0
Former Member
Oct 29, 2009 at 11:44 AM

Transportable Tablespace:Tables not active in dictionary

98 Views

Hi,

I have a custom/user defined tablespace in source system(ABC) and the same was moved to the target system(XYZ) using transportable tablespace(1035051 - homogenous method). I am able to see the entire details of that tablespace in DB02, but when I try to access the tables via se11, the error message displayed is "Table does not exist".

Any help would be highly appreciated.

Informations:

I have made the desired entries in the tables DDART, TSORA, TAORA & IAORA.

Source & Target System Details:

OS - Windows 2003(64bit)

DB - Oracle 10G(10.2.0.2)

Regards,

Karthik