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).

• Kirti

-----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).