Hi all,
select*from v$version;
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
"CORE 10.2.0.1.0 Production"
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
I've around 500 master tables with huge data in my pre production database. I've one testing environement with same structure of master tables. this testing environement already have old copy of master tables from production. I need to take dump file from pre production enviroment with last week data. old data from master table is not required as those data is alrady available in my testing environement. And also i no need to take all the tables from pre production. only master tables need to take with lastest one week data.
How can i take partial data from master tables from pre prodcution database ? and how can i import only those new record into testing database.
I'm using EXP and IMP commands. But I didn't see the option only to take partial data . Please advice.