No. No date fields or triggers.

Kind Regards,
Ravi.
-----Original Message-----
From: Clark James C
[mailto:oracledba-ezmlmshield-x37928399.[Email address protected]
Sent: Tuesday, January 08, 2008 11:08 PM
To: LazyDBA Discussion
Subject: RE: Exporting Select data from tables !!!!

Do you have a date_modified field in each of the tables or some type of
trigger that logs changes to show when they were inserted or updated?


James Clark

-----Original Message-----
From: ravi.v
[mailto:oracledba-ezmlmshield-x84260254.[Email address protected]
Sent: Tuesday, January 08, 2008 10:42 AM
To: LazyDBA Discussion
Subject: Exporting Select data from tables !!!!

The following export would export all the rows from the specified
tables.
But I want only those rows inserted after 1st January, 2008. I don't
know how to construct WHERE predicate.



Help would be appreciated.



$EXP [Email address protected] FILE=d:\super.dmp LOG=d:\exp_super.LOG
TABLES=('table1', ' table2', ' table3', ' table4, ' table5');





Kind Regards,

Ravi.





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page