CODEWITHSUNDEEP
oracle-databasedatapumpimpdp
Loftx
Loftx

Reputation: 1792

ORA-00942: table or view does not exist error using impdp

I've been provided with a Oracle database dump which I'm attempting to import using the following:

impdp myuser/myuser DUMPFILE=/u01/app/oracle/oradata/dumpfile.dmp FULL=y LOGFILE=/u01/app/oracle/oradata/dumplog.log

The output is

Import: Release 12.1.0.1.0 - Production on Fri May 1 09:46:59 2015

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

UDI-00942: operation generated ORACLE error 942
ORA-00942: table or view does not exist

Is there anyway I can find out what the problem is or get more information? The user myuser has all privileges.

Upvotes: 2

Views: 6663

Answers (1)

Loftx
Loftx

Reputation: 1792

After running though the setup again it turned out this database has not had the catalog.sql and catproc.sql scripts run on it. Rerunning the import once this has been run resolved this error.

Upvotes: 7

Related Questions