Database Administration (MOSC)

MOSC Banner

exporting users without tables

Hi,

using Oracle 12.2/linux

I need to copy users to another db.

expdp SYSTEM directory=tts_dump dumpfile=tts1_users.dmp logfile=tts_dump_log:tts_users.log schemas=.....EXCLUDE=TABLE reuse_dumpfiles=y

on other db

impdp \"/ as sysdba\" directory=tts_dump dumpfile=tts1_users.dmp logfile=tts_dump_log:tts_users_i.log

=> I get errors

ORA-39083: Object type ROLE_GRANT failed to create with error:

ORA-01919: role 'SQLT_USER_ROLE' does not exist


Failing sql is:

 GRANT "SQLT_USER_ROLE" TO "BUSCLONE"

ORA-39083: Object type ROLE_GRANT failed to create with error:

ORA-01919: role 'SQLT_USER_ROLE' does not exist

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