Home » SQL & PL/SQL » SQL & PL/SQL » urgent :regarding data transfer from one oracle server to another
urgent :regarding data transfer from one oracle server to another [message #19149] Sun, 03 March 2002 20:41 Go to next message
brinth
Messages: 1
Registered: March 2002
Junior Member
sir,
how to copy datas frm one table of one server to the table of another server without using dump?
we need immediate response if possible with sample code.
Re: urgent :regarding data transfer from one oracle server to another [message #19153 is a reply to message #19149] Sun, 03 March 2002 22:55 Go to previous messageGo to next message
seng
Messages: 191
Registered: February 2002
Senior Member
Here is step.

1. Setting database link first with CREATE DATABASE LINK .
2. Using CREATE TABLE name AS SELECT * FROM tablename@dblink , INSERT INTO name SELECT * FROM tablename@dblink or COPY command.
Re: urgent :regarding data transfer from one oracle server to another [message #19155 is a reply to message #19149] Sun, 03 March 2002 23:02 Go to previous message
Manoj
Messages: 101
Registered: August 2000
Senior Member
usnig COPY command u can solve your Problem

Syntex is

copy from scott/tiger@oracle to sott/tiger@oracl2-
inesrt table_name from select * from table_1 -
where condition
Previous Topic: how to get distinct records
Next Topic: finding the names where the 3rd letter is an A
Goto Forum:
  


Current Time: Fri Mar 29 09:42:34 CDT 2024