----- Original Message -----
Sent: Thursday, November 21, 2002 9:18
AM
Subject: RE: export in full mode but
exclude particular user?
anybody know the views for 9.2?
-----Original Message-----
From:
Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
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).
- 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:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
--
Please see the official ORACLE-L
FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
