|8i nested table export, not importing into 10g [message #242017]
||Thu, 31 May 2007 06:43
Registered: November 2005
I have exported a user schema from version 8.1.7 using a standard exp command:
exp FRED/password FILE=FRED.dmp OWNER=FRED rows=Y grants=Y log=FRED.log
Checking the log file all seems fine.
The file is then imported into ORACLE 10g 10.2.0
imp FRED/password FILE=FRED.dmp FULL=y
All works except a table containing an outer nested table. The DESCRIPTOR table and nested table VALS_ALLOWED_TABLE (and data) are missing. Using IMP SHOW on the 10g server I can see that the definition of the tables and this works when run from sqlplus...
CREATE TABLE DESCRIPTOR
DESCRIPTOR_NAME VARCHAR2(24) NOT NULL,
DESC_VALS_ALLOWED DEFAULT "SHM"."DESC_VALS_ALLOWED_T"(),
NESTED TABLE DESC_VALS_ALLOWED STORE AS VALS_ALLOWED_TABLE
The type DESC_VALS_ALLOWED_T is created fine,
CREATE TYPE DESC_VALS_ALLOWED_T OID "ABC4567" As TABLE OF VARCHAR2(8);
any thoughts why it simply does not work? Does the OID matter?
[Updated on: Fri, 01 June 2007 04:32]
Report message to a moderator