Hi,

Do:

exp userid=youruser/[Email Address Removed] buffer=1000000
tables=(your_table1,your_table2) query= DO not know if you can add a
query here when you have more than one table selected: Testit and let us
know :)


Luis
-----Original Message-----
From: ravi.v
[mailto:oracledba-ezmlmshield-x80796929.[Email address protected]
Sent: 08 January 2008 13:38
To: LazyDBA Discussion
Subject: Exporting a Set of tables !!!!

Hi Experts,



Could somebody tell me (by sending a script) as to how to export a set
of
tables (about 8 tables) in one export command? The point is that the
dump
file should have transactions done from January 1st ,2008 onwards from
all
these tables.



Thank you all in advance.



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




-----------------------------------------
This e-mail is sent on behalf of Trader Media Group Limited,
registered office: Unit 6, Thatcham Business Village, Colthrop
Lane, Thatcham, Berkshire RG19 4LW (Registered in England No.
4768840). This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error please notify the sender. This email message has been
swept for the presence of computer viruses. www.ciphertrust.com

Oracle LazyDBA home page