This content has been marked as final. Show 9 replies
No, you can't with sample - it has different meaning. You can do it manually for all tables like
expdp query=employees:"where date_enter>sysdate-30" tables=employees
expdp query=employees:"where date_enter>sysdate-30" tables=employeeswhat is that query.. please post
what about indexex, other objects...
The QUERY clause acts as a filter - http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/dp_export.htm#SUTIL860
with this approach i have take export of each object in diffirent jobs right?.
with this approach i have take export of each object in diffirent jobs right?.does EVERY table in schema have a DATE_ENTERED column?
If not, how do you identify the desired records to be extracted?
Does application contain "lookup tables" that must exist intact (regardless of when records was entered?) for application to properly function?
Yes, each table has created_date column and we have couple of lookup tables that i would take full export and i can also rebuild the indexes.
But the problem with procedures,function's and constraints .
if you did old fashioned export (exp ROWS=NO) it will include procedures,function's and constraints, etc.
The tables can be populated using
CREATE TABLE .... AS SELECT
K i will try that and let you know
Edited by: 789845 on Dec 7, 2010 8:16 PM
How many such tables exists in particular schema ?
If the number of objects are higher they it would be tedious process to carry for each table/segment. First roughly estimate for some tables how many records are going to be. Next Instead of export - you can generate the db link across the database and go for CTAS so that you can automate the process by creating a script.
Just an alternative
- Pavan Kumar N