hi guys, I'm trying to import content only from a number of tables and it is resulting in the following log file for two out of 50 tables. I'm unsure as to what the cause would be as the 00936 relates to an expression missing or misused, yet I'm importing data so do not see how this can be relevant...


;;;
Import: Release 10.2.0.1.0 - Production on Tuesday, 20 March, 2007 16:46:07

Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "SPFDATA"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "SPFDATA"."SYS_IMPORT_TABLE_01": spfdata/******** TABLES=N2OBJEXT CONTENT=DATA_ONLY DUMPFILE=datadir2007:EXPDPSPFDATA_Load.dmp LOGFILE=datadir2007:importlogdata.txt
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "SPFDATA"."N2OBJEXT" failed to load/unload and is being skipped due to error:
ORA-00936: missing expression
Job "SPFDATA"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 16:46:13