Oracle Problem???

[javvym]

Dear Friends,

I have a small problem which I'm sure u people will be able to solve easily. My scenario is that I've 2 different databases, for example database1 & database2 on Oracle9i. Both databases contain the same no. of tables with the same type of structures. In short, both databases are identical. The only difference is that only database1 contains data.

Now, I've to develop a small application which will be automatically transferring selective records of database1 to database2.

Can anybody tell me with what oracle commands & methods the solution can be achieved??

[ducky]

Since its to be selective, one way would be to create an Oracle DB Link from database1 to database2. This will provide you with the ability to query/write to both databases in the same connection. Then in your vb application use ado to connect to database1 and issue your select statements for database1 and insert into statements for the database2 using the db link.

[javvym]

Dear Ducky,

I'm trying to do what u have advised. But, I'm finding problems with the Oracle commands. I've created a link in database2 like this:

SQL> create database link RC
2> connect to DATABASE1 identified by MYDB1
3> using 'OEMREP';

Database Link created.

After this I'm issuing this command which shows an error:

SQL> copy from DATABASE1/MYDB1@OEMREP -
> create CARINFO -
> using -
> select * from CARINFO

Array fetch/bind size is 15. (arraysize is 15)
Will commit when done. (copycommit is 0)
Maximum long size is 80. (long is 80)

ERROR:
ORA--18098968: Message -18098968 not found; product=RDBMS; facility=ORA

Now, I don't know why this error is coming as I have a table named as CARINFO in DATABASE1.

Can u please solve my problem.