Title: RE: export in full mode but exclude particular user?
It's the same - exu81obj and exu8usr.
HTH
Arup Nanda
www.proligence.com
- Original Message -
From:
Chris
Stephens
To: Multiple recipients of list ORACLE-L
Sent: Thursday, November 21, 2002 9:18
Title: 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
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
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
Title: RE: export in full mode but exclude particular user?
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=.