Re: Data transfer between two 8.1.6 databases

there is also a program called Schemer out there (www.appligator.com) that will let you copy individual tables between databases:

If you have an ODBC mapped to your oracle, it will show up automatically, otherwise create a custom connection to your Oracle databases. Then, all you have to do is click on the table that you want to copy in Oracle and right-click "copy".
Then right-click on any table within the destination database select paste. It will ask you if you want to append the data to an existing db or create a new one. If there are any fields that don't automatically match-up, it will alert you, and help you through the conversion process.

Kim,Yongjun wrote:
>
>
> Dear,
> Maybe you can use two :
> 1. Database link
> 2. Export/import
>
> More information, you can find Oracle manual.
> Regards,
>
> "Beno? Oury" <boury_at_absis-group.be> wrote in message
> news:8u8tqt$hnu$1_at_rivage.news.be.easynet.net...
> >
> > Hi,
> >
> > I've two databases, they have the same structure but not the same
 data
> > one is a test database and one is a production database). How could I
> > transfer the data from one into the other one ? Of course they do not
 have
> > the same name...
> >
> > --
> > __________________
> > Benoit Oury
> > Analyste Programmeur
> > ABSIS-GROUP
> > www.absis-group.be
> > ?????????
> > *** DISCLAIMER ***
> >
> > "This e-mail and any attachments thereto may contain information
> > which is confidential and/or protected by intellectual property
> > rights and are intended for the sole use of the recipient(s) named
 above.
> > Any use of the information contained herein (including, but not limited
> > to, total or partial reproduction, communication or distribution in any
> > form)
> > by persons other than the designated recipient(s) is prohibited.
> > If you have received this e-mail in error, please notify the sender
 either
> > by telephone or by e-mail and delete the material from any computer."
> >
> > Thank you for your cooperation.
> >
> >
> >
>
>

--
Posted via CNET Help.com
http://www.help.com/