Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: export fails with an EXP-0079 ERROR
On Jun 18, 2001 at 08:36:36AM, Seema Singh wrote:
> Hi
> I am getting the following error message.
> EXP-00079: Data in table "RRRRRRRRRRR" is protected. Conventional path may
> only be exporting partial table.
> I am unable to export from system user with full=y option.I am able to
> export from sys user.How can I export from system user.
You have enabled fine grained access control. Only user sys can export your data.
-- Vladimir Begun | "Cogito ergo I'm right and you're wrong." http://vbegun.net/ | -- Blair Houghton http://vbegun.net/wap/ | me_at_vbegun.net | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Begun INET: jester_at_whale.sunbay.crimea.ua Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Jun 18 2001 - 11:53:45 CDT