Export Policies and Import to another database? [message #564521] |
Fri, 24 August 2012 12:17 |
|
Jeremy.Russell
Messages: 14 Registered: September 2011 Location: Charleston, SC
|
Junior Member |
|
|
Hi; I have what I sincerely hope is a question which has a simple answer.
How can I export FGA / row level security policies from one database to another? I have created a new version of my schools ERP database, with upgraded application software, and now need to get the policies from our current production system to the new one.
Thanks for any suggestions.
Jeremy
|
|
|
|
|
Re: Export Policies and Import to another database? [message #564529 is a reply to message #564522] |
Fri, 24 August 2012 15:06 |
|
Jeremy.Russell
Messages: 14 Registered: September 2011 Location: Charleston, SC
|
Junior Member |
|
|
And just when it was going so well, I got this
$ expdp citadeldba schemas=odsmgr dumpfile=odsmgr_export.dmp include=rls_policy
$ impdp citadeldba@ODSX schemas=odsmgr dumpfile=odsmgr_export.dmp include=rls_policy
Import: Release 10.2.0.4.0 - 64bit Production on Friday, 24 August, 2012 15:52:48
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "CITADELDBA"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "CITADELDBA"."SYS_IMPORT_SCHEMA_01": citadeldba/********@ODSX schemas=odsmgr dumpfile=odsmgr_export.dmp include=rls_policy
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/RLS_POLICY
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-00600: internal error code, arguments: [kupfiReadBzLob], [kgcddo error], [19], [1], [212], [0], [], []
ORA-06512: at "SYS.KUPW$WORKER", line 1397
ORA-06512: at line 2
Job "CITADELDBA"."SYS_IMPORT_SCHEMA_01" stopped due to fatal error at 15:54:35
I'm now going to have to research what "internal error code, arguments: [kupfiReadBzLob]" means!
|
|
|
|
|