Home » RDBMS Server » Server Utilities » impdp Import of table having object types of other schema
impdp Import of table having object types of other schema [message #239386] Tue, 22 May 2007 04:25 Go to next message
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

Re: impdp Import of table having object types of other schema [message #239535 is a reply to message #239386] Tue, 22 May 2007 10:49 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
post errors
Previous Topic: import error
Next Topic: Import Database (Merged)
Goto Forum:
  


Current Time: Thu Dec 08 06:32:07 CST 2016

Total time taken to generate the page: 0.11598 seconds