Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to carry out the partitioning activity. I am using oracle 11g R2. In case of error occurs while partitioning I might loose the data. On safer side I want to take backup of the database and if any error caused in the partitioning activity I can restore the same database.

Now question is how should I take backup?

Please keep in mind that DB size : 100 GB I want index, constraints and all details of table while restoring (Please don't suggest me to create index) Is there any automatic way to handle index?

What about Flashback Table query? Can I use it?

P.S : In partitioning activity DDL gets changed.

share|improve this question

migrated from stackoverflow.com Dec 11 '13 at 8:04

This question came from our site for professional and enthusiast programmers.

Unless your storage solution offers some fancy backup options, you should use rman to backup and restore Oracle databases. –  Colin 't Hart Dec 11 '13 at 10:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.