I do import tables from Unix to Oracle by this command: imp id@password file=oBIXMTX201Wa001.dmp log=oBIXMTX201Wa001.log ignore=y grants=n fromuser=ARBOR touser=METADATA
I use Oracle 9.2.0, and it returns me this error: Import: Release 9.2.0.1.0 - Production on Wed May 14 10:20:59 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production
IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00023: Import views not installed, please notify your DBA IMP-00000: Import terminated unsuccessfully Return Code 256
Any idea how to solve this?
Appreciate for any suggestion. Thanks.
Solution: Oracle Import Table
The export views are views that the export and import utilities expects to see in the database they are exporting/importing. These views are created with the CATEXP.sql.
Could be that you are using the wrong IMPORT executable, ensure the PATH enviroment variable is set to the correct executable and these views were created with the CATEXP.sql. Oracle8i Utilities manual, Chapter on "Export" and "Import" have more details on this and could refer to the following article:
132904.1 Compatibility Matrix for Export & Import Between Different Oracle Versions
IMPORT (using a FROMUSER parameter) DOES NOT create schemas that do not have any database objects in a full database export file. 113941.1 FROMUSER/TOUSER Import Creates only Schema Objects