Export by date [message #296058] |
Thu, 24 January 2008 07:25 |
hristo
Messages: 258 Registered: May 2007
|
Senior Member |
|
|
Hi!
I want to make an export (dumpfile) of a database but I only want data that is newer then January 1st 2007 to be included.
This is our export.bat
set ORACLE_HOME=E:\oracle\product\10.2.0\db_1
set ORACLE_SID=DB08
EXP SYSTEM/******@DB08 FILE=E:\dump\db08_071030_ver7130s5.dmp COMPRESS=Y FULL=Y LOG=E:\dump\db08_071030_ver7130s5.log
I know that you can use QUERY, but is it useable in this case? I want to export everything that have been updated/inserted in the DB after a specific date.
Is this possible?
Regards
Hristo
[Updated on: Thu, 24 January 2008 07:27] Report message to a moderator
|
|
|
|
|
Re: Export by date [message #296063 is a reply to message #296058] |
Thu, 24 January 2008 07:49 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Even if it was possible, every table would have to have a DATE column that you could query against. Oracle is good, but it's not magic - it would have no way of knowing what is updated or inserted by date.
|
|
|
Re: Export by date [message #296066 is a reply to message #296058] |
Thu, 24 January 2008 07:53 |
hristo
Messages: 258 Registered: May 2007
|
Senior Member |
|
|
Again, thanks for everyones speedy responses.
Actually, I didnt expect it to work. At least now I REALLY know.
Regards
Hristo
|
|
|