Re: Full Imp problem ( part of imp/exp problem)

C Chang wrote:
> This is part of the import problem. When I imported the full data.dmp,
> one of the table did not go through due to the referencing error of one
> of the columns. How to import a table which has a reference column
> inside as the table of fl_part_number that was constructed as
> following:
>
> CREATE TABLE fl_part_number OF part_number_T
> (SCOPE FOR (cage_code_R) IS fl_supplier)
> /
>
> -- part_number_T is
> CREATE OR REPLACE TYPE part_number_T AS OBJECT
> (
> part_number VARCHAR2(35),
> cage_code_R REF supplier_T,
> rnvc VARCHAR2(1)
> )
>
> -- supplier_T is
>
> CREATE OR REPLACE TYPE supplier_T AS OBJECT
> (
> cage_code VARCHAR2(5),
> company_name VARCHAR2(80),
> office_addr_T addr_T,
> office_phone VARCHAR2(20)
> );
>
> SYStem: Oracle 8.1.6 on NT4 with 2X 750 Mhz CPU with 1G RAM and 6 HDs.
> C Chang

EXPort should have been direct (direct=y).

Frank Received on Wed Jan 29 2003 - 13:34:02 CST