Re: Full database export as user ' / as sysdba'

From: <babu.nagarajan_at_Cummins.com>
Date: Wed, 29 Sep 2004 11:09:37 -0500
Message-id: <OF82F11B52.AD1E830E-ON05256F1E.005888EF-05256F1E.0058C5D1@cidc.cummins.com>

To get around the exports with RLS/FGAC, we use DIRECT=Y while running the export.

Thanks

Babu

                                                                                                                                       
                      Mohammad Rafiq                                                                                                   
                      <rafiq9857_at_gmail.c        To:       "oracle-l_at_freelists.org " <oracle-l_at_freelists.org>                           
                      om>                       cc:                                                                                    
                      Sent by:                  Subject:  Full database export as user ' / as sysdba'                                  
                      oracle-l-bounce_at_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 Received on Wed Sep 29 2004 - 11:09:09 CDT