Thanks for the question, Sailesh.
Asked: June 20, 2018 - 9:51 am UTC
Last updated: June 24, 2018 - 11:47 am UTC
Version: 12.1.0.2.0
Viewed 1000+ times
You Asked
Wanted to check if there is some easy way to create a backup of the tables/schema and use some script that will load back the data from the backup file.
I have DBCS access so can run the sh script as well.
Please let me know if there is a simpler way.
Note: Manually exporting the table is a very long process and we have app 30-40 table to take the backup. Even the record size is huge.
Regards
Sailesh.
and Connor said...
Your options would be:
1) datapump
So you can nominate the schemas/tables explicitly. Datapump can usually unload/load pretty large volumes in reasonable time.
2) RMAN
RMAN works at the *physical* level. So in this instance, you would need a means of isolating the objects in question to a particular tablespace, or set of tablespaces (with no *other* objects in there). Then this tablespace could be backed up and restored in isolation with rman. Same logic applies for transportable tablespaces.
Is this answer out of date? If it is, please let us know via a Comment