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 tried exp utility to dump all database. Looks like this exports only the last version of data skipping undo log. Using flashback queries I see:

01466. 00000 -  "unable to read data - table definition has changed"
*Cause:    Query parsed after tbl (or index) change, and executed
           w/old snapshot

What I'm trying to do is to capture db changes, make backup for later use with the ability to flashback to timestamp.

With rman backup I have similar situation:

ORA-01555: snapshot too old: rollback segment number 3 with name "_SYSSMU3_2472002983$"  too small 
01555. 00000 -  "snapshot too old: rollback segment number %s with name \"%s\" too small"
*Cause:    rollback records needed by a reader for consistent read are overwritten by other writers`. 

Update: I managed to do what I needed only by increasing undo retention and direct copying of data files and control file modification on cloned instance.

share|improve this question

migrated from stackoverflow.com Dec 28 '12 at 19:16

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

1  
Are you trying to take the export, import it into another database and run flashback queries in the new database (against the imported data)? If so, this can't be done. –  Chris Saxon Dec 29 '12 at 14:12
    
I'm doing backup and restore to new database and running flashback queries. –  user1934597 Jan 5 '13 at 13:33
add comment

1 Answer 1

You could insert the results of a flashback query or flashback versions query into a table and export that table or you could do your own versioning. You could also look at the Change Data Capture feature which may meet your requirements. The real answer to your specific question though is...

No, you can't do that.

share|improve this answer
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.