| export/import in server where Oracle Instant Client is [message #250501] |
Tue, 10 July 2007 05:02  |
anbansal
Messages: 2
Registered: July 2007
|
Junior Member |
|
|
Hi,
We have Oracle 10g on Linux.
We have one DB server (S1), where Oracle Server is installed. Oracle binaries are installed only in this
server. It's bin contains export/import binaries too.
$ORACLE_HOME = /opt/oracle/product/10gR2
There is another server (S2) integrated to that DB server.
This server has got only Oracle Instant Client installed. It contains only sqlplus.
$ORACLE_HOME = /usr/lib/oracle/10.2.0.2/client
Our requirement is to run Oracle exp/imp from S2 without ssh to S1.
Env variables are set as below:
ORACLE_PATH=/opt/oss/lib/sql
LD_LIBRARY_PATH=/opt/oss/lib:/opt/oss/tao/lib:/usr/lib:/usr/lib/oracle/10.2.0.2/client/lib
ORACLE_SID=oss
ORACLE_BASE=/usr/lib/oracle
PATH=/usr/lib/oracle/10.2.0.2/client/bin:/opt/oss/bin:/opt/oss/perl/bin:/opt/oss/tao/bin:/bin:/usr/bin:/opt/oss/bin:/usr/lib/oracle/1 0.2.0.2/client/bin:/opt/oss/bin:/opt/oss/perl/bin:/opt/oss/tao/bin:/bin:/usr/bin:/opt/oss/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6 /bin:/usr/sbin:/home/omc/bin:/usr/sbin:/opt/oss/sbin
TNS_ADMIN=/usr/lib/oracle
ORACLE_HOME=/usr/lib/oracle/10.2.0.2/client
We tried copying exp/imp binaries and some message files, but below error is coming when executing exp:
----------------------------------------------------------------------------------------------
omc# exp omc/omc tables=nith_exp file=exp10g.dmp
Export: Release 10.2.0.3.0 - Production on Wed Jul 4 11:37:35 2007
Copyright 1982, 2005, Oracle. All rights reserved.
EXP-00056:
EXP-00000: Export terminated unsuccessfully
----------------------------------------------------------------------------------------------
Please help us in solving this problem.
Regards,
ANUJ
|
|
|
|
|
|
|
|
|
|
| Re: export/import in server where Oracle Instant Client is [message #250851 is a reply to message #250713] |
Wed, 11 July 2007 10:29  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | I guess Micheal option is best
|
,but if you want to do it through IMP/EXP then use datapump with network option.
Network export creates the dump file set on the instance where the Data pump job is running from and extracts the metadata and data from the remote instance.
EXAMPLE
=======
Steps:
1.) create database link in the destination database:
create database link test_link connect to system identified by test_password using 'test_database';
2.) create directory for the data pump job to use:
create directory datapump as 'c:\oracle';
3.) grant read and write on the directory to everyone:
SQL> grant read, write on directory datapump to public;
4.) Start the importing through the network mode of data pump:
impdp system@test_database directory=datapump network_link=test_link schemas=test_schema1,test_schema2
remap_schema = 'test_schema1:new_test_sch,test_schema2:new_test_sch2' LOGFILE=test_data.log
[Updated on: Wed, 11 July 2007 10:30] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
