Home » RDBMS Server » Server Utilities » Export by date (10.2.0.3 win2003)
Export by date [message #296058] Thu, 24 January 2008 07:25 Go to next message
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 #296061 is a reply to message #296058] Thu, 24 January 2008 07:36 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

AFAIK, it is not possible except QUERY option.
you have to export one by one table with QUERY Option which table is very big in size.


Regards
Taj
Re: Export by date [message #296062 is a reply to message #296058] Thu, 24 January 2008 07:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No it is not possible with export.

Regards
Michel
Re: Export by date [message #296063 is a reply to message #296058] Thu, 24 January 2008 07:49 Go to previous messageGo to next message
joy_division
Messages: 4640
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 Go to previous message
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. Smile

Regards
Hristo
Previous Topic: oracle 9i,solaris 9
Next Topic: extract data from one database to other - both database cant talk each other (behind firewall)
Goto Forum:
  


Current Time: Sun Dec 04 10:40:13 CST 2016

Total time taken to generate the page: 0.09227 seconds