IMP-00017 IMP-00003 ORA-00942 USING FROMUSER/TOUSER ON SNAPSHOT [LOG] IMPORT (Doc ID 1017292.102)

Last updated on JUNE 28, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.0 and later
Information in this document applies to any platform.

Symptoms


***The information is applicable from 8i to 11.2 database***

You have a situation where USER1 owns table T1 with snapshot log MLOG$_T1.

You export USER1 and want to import into USER2. You use the FROMUSER=  TOUSER=
option of the Import utility to accomplish this.

During import, you receive errors:

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms