Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Failed import with the user type

Re: Failed import with the user type

From: EP <ep_at_plusnet.pl>
Date: Mon, 16 Sep 2002 12:35:38 +0200
Message-ID: <am4c5v$2g8m$1@news2.ipartners.pl>


> I am trying to import a schema with a user type referencing another
schema.
> Even though I create a table in the following way (the metalink advice):
> create table xxx.testt_id (testfield yyy.t_id)
> I still get the ORA-00902 error.
>

I have already found out - what I needed was EXECUTE ANY TYPE...

Regards
EP Received on Mon Sep 16 2002 - 05:35:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US