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

Home -> Community -> Mailing Lists -> Oracle-L -> Urgent - Export trick needed

Urgent - Export trick needed

From: <blair_at_pjm.com>
Date: Wed, 12 Jul 2000 14:49:16 -0400
Message-Id: <10556.111851@fatcity.com>


We need to do a full database export (except for a set of humongous tables HUMONG1, HUMONG2, and HUMONG3).

In Oracle 7 there was a trick you could do - modify the CREATE OR REPLACE VIEW exu7tab view from $ORACLE_HOME/RDBMS/ADMIN/catexp.sql script.

Does this trick still work? Can I add a clause to the WHERE clause of this view to exclude those tables from a full database export?

Now there is not only an exu81tabs view but also an exu81obj view.

..tom Received on Wed Jul 12 2000 - 13:49:16 CDT

Original text of this message

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