Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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?