RE: Yet Another Export Question

From: Justin Cave (DDBC) <jcave_at_ddbcinc.com>
Date: Thu, 22 Apr 2004 01:06:31 -0600
Message-ID: <87E9F113CEF1D211A4C30090273018741BBCE2@ddbcinc.ddbc.local>

There is a tables clause for the export utility, but that would require that you list all the tables you do want to export, which may not be ideal.

You could move the table in question to a special tablespace and just list the tablespaces you want to export.

If you're on 9i, you could look into doing incremental exports. If the table doesn't change at all, it won't be exported in an incremental export (though if it does change, all the rows will be exported).

Are you using export to perform database backup? If so, you may want to consider switching to a more robust backup strategy, one that lets you do incremental backups. Logical backups via export are generally not sufficient by themselves anyway-- you want some sort of physical backup.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fahd Mirza Sent: Thursday, April 22, 2004 12:53 AM
To: oracle-l_at_freelists.org
Subject: Yet Another Export Question

Hi there,

I take full database export every morning. In one schema, I have got a table which contains pictures and the contents of this specific table rarely change. Is there any way, I could take full database export excluding this specific picture table.=20 Give me some lights, please.
thanks,
regards,
Fahd

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Thu Apr 22 2004 - 01:59:17 CDT