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