| Is it possible to export (expdp) a table from client m/c, without using Remote desk top connection ? [message #419545] |
Mon, 24 August 2009 02:52  |
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
|
Member |
|
|
Is it possible to export (expdp) oracle table from client machine, without using Remote desk top connection ?
Server - Unix / Oracle-10g
Client - Windows -Vista / Oracle 10.2 client
1) Database-10g server is in America
2) client machine is in India
3) Oracle client-10g is installed in my machine
4) I am able to connect to the server, could see all tables
5) one table is with 35 million record, I wanted to export this table using data pump, from client machine is it possible?
I tried
~~~~~~~~
6) connect sys as sysdba
create directory test_dir as '/dbusr1/exp_test'
grant read, write on directory test_dir to user1;
7) expdp user1/pwd1@xyz tables=test_1 directory=test_dir dumpfile=test_file.dmp logfile=test_file.log
 Errors
In linux prompt I am getting this error
-bash: expdp: command not found
In windows cmd prompt I am getting this error
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE";, line 488
ORA-29283: invalid file operation
9) why ?
-- Does the user ( "user1") should have any system level privilege ? to export his own table?
-- This subfolder only ('/dbusr1/exp_test') has write privilege in os level.
Thanks in advance
sbmk_design
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
