-
finding modified tables/partitions
As part of our backup/recovery process we don a RMAN backup along with
a full export of a 4.5TB database. To limit what is pumped out I would
like to limit my export to only those tables/partitons, which have changed
for the current day or maybe the day before.
By change, I mean any inserts,updates or deletes.....
Does anybody know of such a query that will give me this information,
which I can use to dynamically build a parfile through a shell script than
invoke expdp.
Any examples would be greatly appreciated.
Thanks to all who answer.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|