Database Utilities (MOSC)

MOSC Banner

IMPDP DBA_USERS view

edited Jul 14, 2010 3:14AM in Database Utilities (MOSC) 1 commentAnswered ✓
Hello,

I have an expdp dump file that was created with full=y.  How can I impdp the tables that make up the dba_users view into a different schema?  I have tried these parameters and received the indicated results.

impdp <userid>/<password>@&lt;instance> dumpfile=<file>.dmp job_name=<jobname> table_exists_action=replace version=latest logfile=dba_users.log REMAP_SCHEMA=sys:jlv tables=sys.user$,sys.resource_group_mapping$,sys.ts$,sys.ts$,sys.profname$,sys.user_astatus_map,sys.profile$,sys.profile$
Connected to: Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
ORA-39002: invalid operation
ORA-39166: Object USER$ was not found.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center