Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export question on excluding certain schema
Also, by default, in Oracle 8.1.6 MDSYS and CTXSYS are already excluded from the export, so no editing of catexp.sql is needed to do what the original poster wanted to do.
# grep MDSYS $ORACLE_HOME/rdbms/admin/catexp.sql
u$.name not
in ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS')
u.name not in ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS')
u1$.name not in ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS')
'ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS')
ue$.name not in ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS')
s$.owner not in ('ORDSYS', 'MDSYS', 'CTXSYS', 'ORDPLUGINS')
AND u.name not in ('ORDSYS',
'MDSYS', 'CTXSYS', 'ORDPLUGINS')
> -----Original Message-----
>
href="mailto:kirti.deshpande@verizon.com">mailto:kirti.deshpande@verizon.com]
>
> The answer is: Yes.
> You will need to edit catexp.sql to rebuild internal view
to exclude
> interested owner#.
>
> -----Original Message-----
> Is it possible to exclude certain sys type schema when we
do
> export? We are
>
(will be) migrating from 8161 to 9201 and would like to
> exclude MDSYS and
> CTXSYS from (8161)
export.
-- 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 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Sep 05 2002 - 15:08:34 CDT
![]() |
![]() |