Create a .bat file containing
*//
time /t
exp user/[Email Address Removed] parfile=export_params.txt
time /t
pause
//*
Than a .txt file containing
*//
file = tables_20050414.dmp
tables = (item_combination,item_dependency,adm_item_map,item)
feedback = 13332
buffer = 1024001
log =tables_exp_20050414.log//*/
ensure the <sid> is in your local tnsnames.ora
run the .bat flee
Many Thanks
Miles
Miles Flint
System Architect
Laduma Project Team
Phone (+27) 11 677 6304
Cell (+27) 82 805 5339
-----Original Message-----
From: DXiang
[mailto:oracledba-ezmlmshield-x40760661.[Email address protected]
Sent: 30 May 2005 04:19
To: LazyDBA Discussion
Subject: how can I run exp from my Oracle 9i client on Windows
Hey DBAs,
I have a 9i client(Windows) and three servers(two V8.1.6 and one V9.2,
UNIX). I want to use the client to connect to one of the V8.1.6 servers to
exp data. How can I do that? I can use SQL PLUS on the client to connect to
one of the servers by specifying host string, but I don't know how to
specify my server in the exp command. Is there any environment variable
that I need to set up?
Any help would be greatly appreciated.
David Xiang
Canadian Depository For Securities Ltd.
85 Richmond St. West.
Toronto, Ontario
M5H 2C9
(416) 815-2029
email: [Email address protected]
The information in this e-mail is confidential, privileged and is subject
to copyright. It is intended solely for the addressee(s) named. Access to
this e-mail by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any action taken or
omitted to be taken in reliance on it is prohibited and may be unlawful and
we ask that you notify us immediately by telephone at (416) 365-8400 or
reply by e-mail to the sender. When addressed to our participants or other
clients, any information contained in this e-mail is subject to the terms
and conditions expressed in any applicable agreement governing the use of
CDS services.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page