backup single table partiton question?
HI we are using oracle 11.2.0.3 on linux platform and was wanting to know if there is a way to backup just a single table partiiton using rman? If so does the database need to be runnnig in archivelog mode in order to do this with the database online?
This is a database that has one single huge table that is partitioned by day and we are attempting to export out daily partitions using datapump export so that we can arhive them to tape but the disk system we have is not able to keep up and the export of roughly 128gb is taking over 8 hours and is failing beciase the undo is aging out.
We would like to bypass writing the partitions out to disk and just stream them to tape if at all possible?
Any help or suggestions are greatly appreciated.
Thanks.