Seeking Oracle out of the matrix

Oracle New Articles

Oracle Critical Patches

Oracle jDeveloper News

Oracle Blogs of interest

This blog records my personal experience.

Latest news from the front

Author's note : Thank you all for your supporting letters. You have been a motivation to this web spot's posting. I wish you all the very best for you and your families for the new year.
Interested to know about a next post? You can suscribe to my RSS feed
HOW TO:

TIP: Use exp.exe to export specific rows from a table, with command-line SQL

Saturday, December 09, 2006

If you ever need to export specific records from your table to a .dmp file using exp.exe here is an example :

Suppose we have a table Orders and we want to export that table to a dmp file - not the whole table but today's orders.

from the prompt you write :

exp.exe 'sys/mypass@mydb as sysdba' file=c:\orders.dmp log=c:\orders.log tables=(ORDERS) QUERY=\" WHERE ORDER_DATE = '11/08/2006'\"

Remember :
query=\" \" or else you get an error !

posted by Admin @ 9:04 PM

1 Comments:

At 1:54 AM, Anonymous said…

@gpdimonderose
Man it's easy to make a blog and post your stuff there. This is a technology blog.