Operating System - HP-UX
1748211 Members
4988 Online
108759 Solutions
New Discussion юеВ

Re: Oracle exports question

 
SOLVED
Go to solution
Gerry Tully
Frequent Advisor

Oracle exports question

Our DBA was called away unexpectedly and we are having a problem. They want me to export a table but I'm not sure the syntax. I see where a full export command line says 'exp $SYS_UN_PW full-Y consistent=Y file=$FILE log=$LOG but could someone tell me what the command line would be for a table called EXPENSE_TRANS. Thanks I'm not real familiar with this.
Any Ideas?
3 REPLIES 3
Steve Steel
Honored Contributor

Re: Oracle exports question

Hi


For ORACLE look at

http://web.singnet.com.sg/~petermag/oracle.html


Steve Steel
If you want truly to understand something, try to change it. (Kurt Lewin)
Ian Lochray
Respected Contributor
Solution

Re: Oracle exports question

Gerry,
how about ...
exp username/password file=outputfile tables=EXPENSE_TRANS consistent=Y log=logfilename

Substitute the releavant values for username, password, outputfile and logfilename.
Gerry Tully
Frequent Advisor

Re: Oracle exports question

Thanks Ian. It worked fine.
Any Ideas?