Oracle Database 10g: Refresh Production Database Schemas to Stage Database with not all production data

Hi Oracle DBA Gurus, Is there an easy way to do to refresh production database schemas to stage database with smaller amount produciton data (not all p开发者_开发知识库roduction data)? Both databases are 10g r2.

For the schemas? Yes, there exists numerous solutions for this. For the data? I don't believe there is a generic way to do this. Since your data is unique for you, it's impossible to build a generic solution copying a subset of data, taking into account relationships, triggers, stored procedures etc.

Depending on what data you have, it might not be hard to do manually anyway. Once you have working solution, it can be very handy for a long time with small efforts in updating.