I've done a full database expdp from one instance.
I have a 2nd similar instance, that needs to have some schemas sync'ed with the first one.
I've dropped the users in the 2nd instance.
I am using impdp to put these schemas back onto the 2nd instance.
For some reason, I get a few errors on one schema mostly...and it appears for some reason, the role it needs is not being created...while other roles are being created just fine?
ORA-01917: user or role 'ROLE1' does not exist
Failing sql is:
GRANT SELECT ON "SCHEMA1"."STD_ID" TO "ROLE1"
I checked on the original instance...and ROLE1 does exist.
I'm curious why this role isn't being created on the impdp? There are other roles that are in there, and appear to be being created just fine.
I'm doing actually 2x passes with import.
On the first pass (the one I'm speaking of here), I'm doing CONTENT=METADATA_ONLY
I list out specifically about 7 or so schemas to import in (same as what I dropped).
The send import, I actually do DATA_ONLY for the SCHEMA1 schema...but I've not reached that point yet.
Any ideas on what I should look for?
This is Oracle 11Gr2 on RHEL5.
Thank you in advance,
So, why were the roles created...when I did an impdp on another (3rd) instance with metadata only, but this time was an empty instance and I imported all schemas?
Are you saying roles never travel with and export/import? I don't think that's right?
Ive had a similar problem with datapump. Any repsonse would be much appreciated.
After the import failed. I attempted to created the roles manually, but many were imported, despite the errors in the log!!