To get around the exports with RLS/FGAC, we use DIRECT=Y while running the
export.
Thanks
Babu
Mohammad Rafiq
<rafiq9857@xxxxxxx To:
"oracle-l@xxxxxxxxxxxxx " <oracle-l@xxxxxxxxxxxxx>
om> cc:
Sent by: Subject: Full database export
as user ' / as sysdba'
oracle-l-bounce@fr
eelists.org
09/29/2004 09:26
AM
Please respond to
rafiq9857
OS: WINDOWS 2000, HP-UX 11.11
Oracle Version : 8.1.7.4 and 9.2.0.5
Is there any issues while exporting full database as user ' / as sysdba'?
We have to do it because of implemention of row level security as in
this case as system it generates errors for all those tables where RLS
implemented and not able to export those rowson .
In certain Oracle Notes for full exports (except for transportable
tablespaces) and even in Datapump export doc for 10g it is suggested
not to export as ' sysdba' for full database.
I personally exported and imported full database export dump as sysdba
without any issues.
Any input or experience?
Regards
Rafiq
--
http://www.freelists.org/webpage/oracle-l
_____________
This e-mail transmission and any attachments to it are intended solely for
the use of the individual or entity to whom it is addressed and may contain
confidential and privileged information. If you are not the intended
recipient, your use, forwarding, printing, storing, disseminating,
distribution, or copying of this communication is prohibited. If you
received this communication in error, please notify the sender immediately
by replying to this message and delete it from your computer.
--
http://www.freelists.org/webpage/oracle-l