If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Data extraction

I'm looking for a solution that would extract the last months data from a production database onto a test server. I thought about finding the SCN number from a month ago and using the export utility for this but not sure if this would work. Any ideas on this?
Thanks

If you want the database to restored as past to a point-in-time do a point-in-time recovery until the desired timestamp on test server. As Amit said the OS should be same.
OR if you just want last's moth's data on the new database then create DB link and pull the data using SQL queries.

HTH.

Sanjay G.
Oracle Certified Professional 8i, 9i.

"The degree of normality in a database is inversely proportional to that of its DBA"