My Oracle Support Banner

IMP-00017 warnings when importing dump file (Doc ID 461726.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Server - Standard Edition - Version: 10.2.0.3
This problem can occur on any platform.

Symptoms

-- Problem Statement:
Customer is attempting to duplicate a schema using export+import, but receives the following errors:

ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE UNIQUE INDEX "US_USERS_LWR_IDX" ON "USERS" (LOWER("US_USERNAME") ) "
"PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 196608 FREELISTS 1 FREEL"
"IST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TDDATA" LOGGING"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.