Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Export All except ...?

Re: Export All except ...?

From: Patrick Tan <ptan_at_mindspring.com>
Date: 1997/11/11
Message-ID: <34687ED2.91AA2317@mindspring.com>#1/1

look in $ORACLE_HOME/rdbms/admin directory. There is a script called catexp.sql. Search in the script for a view called exu7tab. Copy this view to different file. Add <and o$.name<>'table name'> at end of the script. Connect as sys to the db. Recreate the view. Now perform exp with full=y

Patrick Received on Tue Nov 11 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US