General
cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting tables one server to another server..?

Ramana.Sv
Frequent Advisor

Exporting tables one server to another server..?

Hi, I have 2 HP-UX with oracle 10G server i want copy table from serverA to ServerB,how to dot his one directly from Server A to Server B is there any commands pls...


Thank's
9 REPLIES
Srimalik
Valued Contributor

Re: Exporting tables one server to another server..?



1) Run exp utility on server B to export the table from Server A to a dmp file on server B.
I can not write the syntax as I do not have a system with me. try $ORACLE_HOME/bin/exp help=y

2) use imp utility to import the dmp file into the database.

Thanks
Sri
abandon all hope, ye who enter here..
Ramana.Sv
Frequent Advisor

Re: Exporting tables one server to another server..?

when i use export command iam getting this error ?

SP2-0734: unknown command beginning "expdp cons..." - rest of line ignored.
Hein van den Heuvel
Honored Contributor

Re: Exporting tables one server to another server..?

Hmm, expdp would be the 'datapump'.
Maybe a simple exp/imp as suggest will suffice?

What is the EXACT command you tried?

Looks like you are antered an SQL> command where you should use a shell command.

Hein.
TwoProc
Honored Contributor

Re: Exporting tables one server to another server..?

I'd create a dblink, and then just run your new table create with a

"create table newtable as
select * from oldtable@dblink"

We are the people our parents warned us about --Jimmy Buffett
Srimalik
Valued Contributor

Re: Exporting tables one server to another server..?

do not use data pump utils they will store the amp file on server A only and then you have to transfer the file using ftp or somthing similar.

DBLINK solution seems to be better/easier/cleaner. :-)
abandon all hope, ye who enter here..
Arturo Galbiati
Esteemed Contributor

Re: Exporting tables one server to another server..?

Hi,
1) use exp on server a
2) ftp the dump file to server b
3) on server b use imp to import data
Take care about option during export if you need to export grant, indexes as well.

Just my .02$
Rgds,
Art
Gyankr
Frequent Advisor

Re: Exporting tables one server to another server..?

altering ramana's question instead of exporting as a dump i want to export the table data (in server A) to a pipe delimited flat file (in server B).Can someone help me on this?

Regards,
Gyan
Dennis Handly
Acclaimed Contributor

Re: Exporting tables one server to another server..?

>altering ramana's question

(You should create your own thread for your question and point to this one if there is any useful background.)
Jeeshan
Honored Contributor

Re: Exporting tables one server to another server..?

Hi Ramana

There are 2 ways you can copy files from server A to Server B.

1. Create DBLINK. And get table from Server A.
2. Export table in Server A and compress it with the command utility. Then scp or ftp.

The other thing you can do is, compress your table in database and then export it. It will reduce your time to copy large table rather than compressed table.
a warrior never quits