Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Yet Another Export Question
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
![]() |
![]() |