Home » RDBMS Server » Server Utilities » Re: How can i migrate big tables across databases
Re: How can i migrate big tables across databases [message #367966] Fri, 09 July 1999 22:09
venkat dulla
Messages: 1
Registered: July 1999
Junior Member
First create a database link between databases.

you can use

create table newtable as
( select * from other_table@database_link)

You can use unrecoverable option to reduce
redo log overhead.

Let me know if you need more info.

Venkat Dulla
Previous Topic: Sql Loader error -524
Next Topic: Re: SQL*Loader-524 error
Goto Forum:
  


Current Time: Thu Mar 28 16:05:01 CDT 2024