Oracle - Query Parameter in EXP

Labels: Posted by Sandeep G on Tuesday, January 8, 2008 at 2:36 AM

How to use Query Parameter in exp command line:

When your column in the where clause is of TYPE VARCHAR

exp file=partial1.dmp log=partial2.log tables=PS_JOB,PS_JOB_JR,PS_COMPENSATION,PS_AS_AUDIT_JOB query=\"where emplid=\'220627489\'\" userid=scott/tiger

When your column in the where clause is of TYPE NUMBER

exp file=partial1.dmp log=partial2.log tables=PS_JOB,PS_JOB_JR,PS_COMPENSATION,PS_AS_AUDIT_JOB query=\"where empno=10\" userid=scott/tiger

Thanks

D.Sasi Kumar

 

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)