| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: export in full mode but exclude particular user?
RE: export in full mode but exclude particular user?It's the same - exu81obj and exu8usr.
HTH
Arup Nanda
www.proligence.com
anybody know the views for 9.2?
-----Original Message-----
From: Deshpande, Kirti [mailto:kirti.deshpande_at_Verizon.com]
Sent: Wednesday, November 20, 2002 10:58 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: export in full mode but exclude particular user?
Joe,
It may be unsupported, but it does work. One must be careful in saving the original catexp.sql, and running it afterwards (after the 'tweaked' export is done). I have been using this 'tweak' for quite some time.
Excluding user(s) from export is a fairly easy tweak. Oracle already excludes a few of its own schemas from the export. Adding a new username in the 'exclude list' is not difficult. Hint: affected internal views are exu81obj and exu8usr (in 8.1.7.4).
-----Original Message-----
Sent: Wednesday, November 20, 2002 8:29 PM
To: Multiple recipients of list ORACLE-L
in the past there was a way described here on the list, TOTALLY UNSUPPORTED by tweaking one of the underlying views.
joe
Chris Stephens wrote:
> i'm 99% sure that can't be done. you'll have to explicitly name all
> the other users with owner=user_a,user_b,... ...then you can do an
> import with full=y ...or flip/flop by full=y on export and
> owner=...... on the import.
>
> ...first post to the list.
> ....gotta start somewhere!
>
>
>
> -----Original Message-----
> From: Chuan Zhang [mailto:Chuan.Zhang_at_transact.com.au]
> Sent: Wednesday, November 20, 2002 5:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: export in full mode but exclude particular user?
>
>
> Dear DBA gurus,
>
> Has anyone got such experience when export database in full mode but
> exclude a particular user?
>
> TIA,
>
> Chuan
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Chuan Zhang
> INET: Chuan.Zhang_at_transact.com.au
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
INET: kirti.deshpande_at_Verizon.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arup Nanda INET: arupnanda_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Thu Nov 21 2002 - 09:24:14 CST
 |
 |