Oracle Database Discussions

Hello to everyone.

I need help. I've searched help sites/forums for the past few days and have not found a solution.

I am new to using impdp and cannot get it to work. My prior experience was the old "imp" utility. We recently upgraded to 11.1.0.6 database and trying to import an export file created from 11.1.0.7 using the export parameter VERSION=11.1.0.6. The DBA sending me the export file has sent it to me as both a DBA and non-DBA export. Both get the same errors. Both databases are on Sun Solaris platforms. I had already created a directory and granted TIMS read/write.

OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS ERPMGR_DATADUMPS
/app/erpmgr/datadumps



Following are the roles granted to the user "TIMS":
SQL> select * from user_role_privs;

USERNAME GRANTED_ROLE ADM DEF OS_
------------------------------ ------------------------------ --- --- ---
TIMS CONNECT NO YES NO
TIMS DBA NO YES NO
TIMS IMP_FULL_DATABASE NO YES NO
TIMS RESOURCE NO YES NO


The parameter file is as follows:

content=data_only
DIRECTORY=erpmgr_datadumps
DUMPFILE=afp44_mri.dmp
TABLES=afp44_mri
NOLOGFILE=y


The errors generated are:

erpimsvm > impdp TIMS parfile=mri.par

Import: Release 11.1.0.6.0 - 64bit Production on Friday, 18 June, 2010 8:44:10

Copyright (c) 2003, 2007, Oracle. All rights reserved.
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bitn
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-31694: master table "TIMS"."SYS_IMPORT_TABLE_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-02373: Error parsing insert statement for table "TIMS"."SYS_IMPORT_TABLE_01.
ORA-00904: "ORIGINAL_OBJECT_NAME": invalid identifier

I checked the description of the source tables against the target tables and they are identical.
All of my tablespaces have have sufficient freespace, especially the TIMS default tablespace.
I've tried this with several different parameter files for different tables and all get the same errors.
Any help wouldbe appreciated.

Thanks,
Glenn