HPE Community
Operating System - HP-UX
1753554 Members
4899 Online
108795 Solutions
New Discussion юеВ

Oracle exports question

 
SOLVED
Go to solution
Gerry Tully
Frequent Advisor

тАО04-25-2003 05:50 AM

тАО04-25-2003 05:50 AM

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?
0 Kudos
Reply
3 REPLIES 3
Steve Steel
Honored Contributor

тАО04-25-2003 05:57 AM

тАО04-25-2003 05:57 AM

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)
0 Kudos
Reply
Ian Lochray
Respected Contributor

тАО04-25-2003 06:03 AM

тАО04-25-2003 06:03 AM

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.
Reply
Gerry Tully
Frequent Advisor

тАО04-25-2003 08:36 AM

тАО04-25-2003 08:36 AM

Re: Oracle exports question

Thanks Ian. It worked fine.
Any Ideas?
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.