Hi. I came here for an advise. I need to get only data from date interval, for example x --> y, or another variant only date from x --> now. What's the best way to do it? I came across date expdp allows to use flasback scn, but I don't have any idea, how to check how to use that.
It depends what you are trying to achieve. Does the data itself have oms way to indicate it is of a certain date? Like maybe a create_date or updated_date column? If that were the case you could export using a WHERE clause that limits the data to a specific time frame...
"Full database data" doesn't really make sense as that would include changes in the internal schemas. Do you really mean changed data in a whole schema?
I don't think that is possible using the default tool set. If you wanted the data as it looked in the past you could use flashback, but that will not allow you to only pull out the changes since that time to now.
The easiest way to track these data changes is to done of the following:
1) Use change data capture to capture the changes. 2) Track the changes yourself by adding create_date and/or modified_date columns to the tables. These can then be targeted in exports using the WHERE clause.
For something that has already happened, you can't retrofit this.
You only other options then are to mine the archived redo logs to identify DML that has occurred. That is going to be very time consuming and labor intensive.