How NOT to EXPort a specific table when FULL=Y?
- From: "Reardon, Bruce (CALBBAY)" <Bruce.Reardon@xxxxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 May 2005 08:33:54 +1000
We use a method for updating our test instance whilst excluding the =
biggest few tables.
It probably isn't supported by Oracle and make sure you test it and =
understand the gotchas - eg you don't get the table but you do get the =
views based on the table which will be invalid - so you need to recreate =
the table & indexes and then recompile everything (or pre-create the =
table).
Anyway, create a custom version of catexp.sql (ie =
?\rdbms\admin\catexp.sql).
-- Update views exu81obj + exu81tabs - add o$.name NOT IN ('x','y')
-- View exu8usr would need altering if wanted to exclude a particular =
user.
Note that I got the original idea from Nov 2002 Oracle-L postings by =
Arup Nanda + Kirti Deshpande - subject "export in full mode but exclude =
particular user".
Then have a script that does the export
run your custom catexp-nobig.sql
run export
run standard catexp.sql
Obviously don't do this at the same time someone else (scheduled job?) =
is trying to do a normal export (eg full) that involves those tables.
HTH,
Bruce Reardon
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Marquez, Chris
Sent: Tuesday, 24 May 2005 7:59 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: How NOT to EXPort a specific table when FULL=3DY?
Have a HUGE table that I do NOT want to EXPort,=20
but other that I would like *everything* else...FULL=3DY.
Any ideas?
Thanks in advance,
Chris Marquez
Oracle DBA
--
//www.freelists.org/webpage/oracle-l
NOTICE
This e-mail and any attachments are private and confidential and may =
contain privileged information. If you are not an authorised recipient, =
the copying or distribution of this e-mail and any attachments is =
prohibited and you must not read, print or act in reliance on this =
e-mail or attachments.
This notice should not be removed.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
