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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 01 21:30:31 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.