Home » RDBMS Server » Server Utilities » 8i nested table export, not importing into 10g
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

Previous Topic: Load data in Table through SQL Loader more than one Data file
Next Topic: importing sql server database
Goto Forum:
  


Current Time: Sat Dec 10 15:05:41 CST 2016

Total time taken to generate the page: 0.12220 seconds