Export Oracle Table from One Server to Other

[saw15]

I need to export an Oracle table from the production server to our test server.

Table name is: i_history

Looking for the best way to accomplish this.

Any help is appreciated.

 

[jpernia]

Hi how many rows the table has?

there are differents was to do it.

 

[rcurva]

You can use export utility. For help on this tool type;

exp help=y

or read about this in your Oracle Utilities manual.
Robbie

"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War

 

[DaPi]

If it is a big transfer then export/import is your best bet.

If you want a flexible (i.e. unplanned) method for small tables (and you can live with the default allocations) you can do it by a db link:

1) use Net8 assistant on the test machine so that it can be a client of the prod db

in test db

2) create database link remote_db
connect to <user> identified by <password>
using '<prod-db>';

3) create mytable as select * from mytable@remote_db;

 

[Turkbear]

Hi,for single table transfers I find nothing
beats the COPY command in SqlPlus - you can pre-set the COMMIT size and keep rollback segment use minimal (using SET COPYCOMMIT=n ), it gives immediate feedback and runs quite fast..Syntax, in general is:

COPY from username/password@thisdatabase to username/password@thatdatabase 
CREATE ( or INSERT, APPEND, REPLACE) 
Table_name_at_thatdatabase
Using Select * from ......