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

Home -> Community -> Usenet -> c.d.o.misc -> Full Imp problem ( part of imp/exp problem)

Full Imp problem ( part of imp/exp problem)

From: C Chang <cschang_at_maxinter.net>
Date: Mon, 27 Jan 2003 23:38:08 -0500
Message-ID: <3E360930.36FD@maxinter.net>


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) /

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 Received on Mon Jan 27 2003 - 22:38:08 CST

Original text of this message

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