OraFAQ Forum: Server Utilities » impdp Import of table having object types of other schema

Home » RDBMS Server » Server Utilities » impdp Import of table having object types of other schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

impdp Import of table having object types of other schema [message #239386]

Tue, 22 May 2007 04:25

dp77
Messages: 1
Registered: May 2007

Junior Member

Dear Team

I am facing a problem importing a particular table that is having a column as your defined object type.

for example:

table dl_trans

tr_id number(10)
tr_name varchar2(10)
tr_trans anuser.abc_typ
rt_data number(10)

in the above table detail you can see the anuser.abc is a type

When We describe that type we found all columns of that types as another types

for ex:

TYPE abc_type
x r.typ_1
y r.typ_2

and so on

means a table is having a column as object type
than that type contains all the columns as other types and that belongs to other schema

NOW whenever i try to import that particular table i got diff errors all the time.

Kindly Reply ASAP

thx in Advance ..

ORA-26062: Can not continue from previous errors.
KUP-11007: conversion error loading table

these are two errors
i particular want to import this table only

[Updated on: Tue, 22 May 2007 12:26]

Report message to a moderator