| 8i nested table export, not importing into 10g [message #242017] |
Thu, 31 May 2007 06:43 |
philackerley
Messages: 4
Registered: November 2005
|
Junior Member |
|
|
Hi,
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"(),
...
...
LAST_MOD_ID VARCHAR2(30)
)
NESTED TABLE DESC_VALS_ALLOWED STORE AS VALS_ALLOWED_TABLE
TABLESPACE SHM
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?
thanks
Phil
[Updated on: Fri, 01 June 2007 04:32] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
