This content has been marked as final. Show 5 replies
I'm curious why this role isn't being created on the impdp?ROLE is NOT a schema owned object!
ROLE needs to be manually created,
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?
Is it possible for you to check the log file with respect to import file and issue. We might understand some thing out of it
- Pavan Kumar N
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!!
You can import roles, use INCLUDE=ROLES
Edited by: JohnWatson on Nov 5, 2012 11:42 AM
Arghhhh! Caught by the revival of a two year old topic!