Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: moveing tables ??

Re: moveing tables ??

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Mon, 11 Feb 2002 13:54:06 +0400
Message-ID: <435f6u0ch3svl4lrrangjps1cpuull954j@4ax.com>


1, Connect and Use the Copy COmmand in SQlplus. 2. Export the table and Import it into the Other DB 3. If the Table is Big and is contained in Only One Tablespace u can use the transporatable TS feature of 8i.

the third will be a Over Kill for this Issue. The Best Would be to use the copy command.

HTH On Mon, 11 Feb 2002 13:30:52 +0530, "Aditya" <aditya_singh_at_pspl.co.in> wrote:

>I wish to move some table from one machine using Oracle 8i to another
>machine using the same Oracle 8i. How can I do this ??
>Some examples will be helpful. Thanks!
>
>
>

[Additions and Corrections Always Welcome.] Best Regards,
Ganesh R Received on Mon Feb 11 2002 - 03:54:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US