exp userid=system file=order_details.dmp tables=order_details where='detail_date between sysdate-30 and sysdate'When you run this export, the WHERE clause will be applied to the query that pulls records from the table. If more than one table is specified in the export utility, the WHERE clause is applied to all tables. So you may have to create different dump files for different tables depending on the WHERE clause you need for each table. Once you have the dump file(s), you can then import those records into your destination database.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.