Way to extract SQL from archived redo logs?

Listers,

A few of our (non-database) people were at a meeting last week, where they were told that a large storage and web-hosting company was using the following method to keep the data in a test database synched with the production database, where the test database had structural differences due to upgrades...

The archived redo logs of the production database are put through a Perl "filter", and the results applied to the test database. The person explaining this referred to the results as SQL. The "filter" presumably mapped old columns to new columns, etc.

Is there a way to extract SQL statements from the archived redo logs? Or am I to assume there was some incredible disconnect in the information here?

Thanks,

Diana Duncan
Database Architect
fileFrenzy.com
diana_at_filefrenzy.com
919.833.1766 x 238 Received on Thu Sep 07 2000 - 09:48:41 CDT