Home » Other » General » Export schema with FGAC (11g)
Export schema with FGAC [message #538376] Thu, 05 January 2012 11:32 Go to next message
lynndba
Messages: 23
Registered: November 2011
Junior Member
Hi,

I did a schema export and got the error for some of the tables

*ORA-39181: Only partial table data may be exported due to fine grain access control on +table+*

I created another user granted DBA role and still did not work, what other options do i have other than having to disable fine-grained access control.

Thank you

Report message to a moderator

Re: Export schema with FGAC [message #538379 is a reply to message #538376] Thu, 05 January 2012 11:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Look into EXEMPT ACCESS POLICY.
Basically, you exempt the user from FGAC. Not acceptable in many shops.

Report message to a moderator

Re: Export schema with FGAC [message #538382 is a reply to message #538379] Thu, 05 January 2012 12:06 Go to previous message
lynndba
Messages: 23
Registered: November 2011
Junior Member
thanks that worked will delete the user afterwards

Report message to a moderator

Previous Topic: Why Oracle?
Next Topic: recompiling objects
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 17 13:26:11 CST 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.