Home » RDBMS Server » Server Administration » export data from client machine
export data from client machine [message #63093] Thu, 09 September 2004 04:24 Go to next message
export data from client m
Messages: 1
Registered: September 2004
Junior Member
how can one export data of a table, while working on a client machine?

database - oracle 8.1.6.0 (windows 2000)

Report message to a moderator

Re: export data from client machine [message #63094 is a reply to message #63093] Thu, 09 September 2004 04:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use the connectString ( as created in tnsnames.ora).

exp dba/password@connectstring owner=xx...

Report message to a moderator

Re: export data from client machine [message #63110 is a reply to message #63093] Thu, 09 September 2004 20:47 Go to previous messageGo to next message
dr alex
Messages: 18
Registered: June 2004
Junior Member
To do export/import while working in the client machine, first you have to copy oradim.exe file from oracle server to the client machine (in \oraclebin folder), then you can do as in the server.

exp user/password@connectionstring file=c:dataexp.dmp log=c:dataexp.log owner=user

Anup
(Nepal)

Report message to a moderator

Re: export data from client machine [message #63155 is a reply to message #63093] Tue, 14 September 2004 22:14 Go to previous message
Anatol Ciolac
Messages: 113
Registered: December 2003
Senior Member
At first you must find a version of exp program for windows2000, copy them in ORACLE_HOME/bin directory and use standart procedure.

Report message to a moderator

Previous Topic: RAID for indexes vs. tables
Next Topic: move table (AUD$) to different tablespace
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 03:32:38 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.