Dear DBA Friends,
DB version - 11.2.0.4
I have a task to export/import a schema from source DB on AIX to target DB on Linux.
The schema is "searchsys" (Admin user for Oracle Secure Enterprise Search (SES) that has some sort of tie up with the Default user "XDB", the XML DB user account)
"searchsys" has tables with VPD enabled on them and the VPD policy function owner of those tables is "XDB". So, there are 2 schemas involved here the object(table)_owner - "searchsys" and the VPD policy function owner is "XDB" . Also, the table is XML table type.
Due to the complexity, I opened a SR with Oracle and oracle confirmed neither data pump nor traditional exp/imp has the capability to export objects belonging Default users - SYS, XDB etc...
Does anyone have any suggestions on how I can copy the table along with its VPD policies/functions properly from source to target ?
Thanks.