Error using EXP on nested tables

From: masonman <mason_john_at_comcast.net>
Date: 18 Aug 2005 09:07:23 -0700
Message-ID: <1124381243.921469.100080@g44g2000cwa.googlegroups.com>

Background

   Platform Win2k
   Installed Oracle 9.2.0.1
   Upgraded to 9.2.0.4
   Created Database

When I try to use exp command on the database I get an the Oracle error shown below when it tries to export nested tables. All other tables export fine.

Any ideas.

### EXP Command ###############

exp usr/password file=Export.dmp log= logfile.log buffer=4096 compress=Y consistent=y constraints=y full=y statistics=NONE indexes=no

### Error ###############

EXP-00056: ORACLE error 1007 encountered ORA-01007: variable not in select list

Thanks

John Received on Thu Aug 18 2005 - 11:07:23 CDT