Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Full Imp problem ( part of imp/exp problem)
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