Home » Infrastructure » Linux » export/import in server where Oracle Instant Client is
export/import in server where Oracle Instant Client is [message #250501] Tue, 10 July 2007 05:02 Go to next message
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 #250584 is a reply to message #250501] Tue, 10 July 2007 10:13 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
Our requirement is to run Oracle exp/imp from S2 without ssh to S1.

Confusing....
You want to take EXP of SERVER S2 from S1 or you want to make dump of S2 on s1?


Re: export/import in server where Oracle Instant Client is [message #250700 is a reply to message #250584] Tue, 10 July 2007 22:54 Go to previous messageGo to next message
anbansal
Messages: 2
Registered: July 2007
Junior Member
Hi DreamzZ,
As our Database Server is running in S1 server, we need to
export some DB tables (in S1 server) from S2 using Oracle exp
binary available in S1.

We are not supposed to ssh to S1 from S2 and perform exp.
~ Anuj
Re: export/import in server where Oracle Instant Client is [message #250713 is a reply to message #250700] Wed, 11 July 2007 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a database link on S2 and execute one of these:
- create table local as select from remote@s1
- insert into local select from remote@s1

Regards
Michel
Re: export/import in server where Oracle Instant Client is [message #250851 is a reply to message #250713] Wed, 11 July 2007 10:29 Go to previous message
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

Previous Topic: Help a newbie install 10g on Suse 10.1
Next Topic: step to shutdown/startup database in Linux server
Goto Forum:
  


Current Time: Thu Mar 28 18:19:55 CDT 2024