Home » SQL & PL/SQL » SQL & PL/SQL » table transfer (10)
table transfer [message #357396] Wed, 05 November 2008 03:36 Go to next message
maheshmhs
Messages: 93
Registered: October 2008
Location: Nepal
Member
hi,

there are several tables in one server. I have to transfer them to another server. The size of tables is very big.

When i use query:
CREATE TABLE ABC AS SELECT * FROM CDE.ABC@efg;

to each tables it takes really long. Is there any faster method of transfering tables between different servers?

thank you
Re: table transfer [message #357398 is a reply to message #357396] Wed, 05 November 2008 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Transportable tablespace when possible.

Regards
Michel
Re: table transfer [message #357400 is a reply to message #357398] Wed, 05 November 2008 03:50 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Direct path export, import and rename
Previous Topic: Sybase To Oracle migration
Next Topic: Grouping rows based on value - pl/sql
Goto Forum:
  


Current Time: Thu Dec 08 08:30:36 CST 2016

Total time taken to generate the page: 0.15116 seconds