IMP-00017 IMP-00003 ORA-00942 USING FROMUSER/TOUSER ON SNAPSHOT [LOG] IMPORT
Last updated on JUNE 28, 2013
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
***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:
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