Transferring data from a remote table to a local one [message #38159] |
Tue, 26 March 2002 06:41 |
Francisco Montes
Messages: 1 Registered: March 2002
|
Junior Member |
|
|
Hi everyone, hope somebody can help me with this one.
I have got two oracle servers and i want to transfer a table (structure + data) from one to another. Letīs assume that i am issuing SQL commands from the TARGET server. I have an DB Link already pointing to the tablespace on the source server so reading from the source table is not a problem, in fact, it works quick and nicely with commands like:
INSERT INTO Table USING
SELECT *
FROM Table@DBLink_to_Remote_DB
The problem starts when i try to transfer a table with a LONG column in its structure. It gives me an ORA-00600 Oracle Internal Error. It doesnīt look good at all. Should i assume that someone else have already tried this with no problems, and, thus, consider that this is an Oracle bug? Anyway... could i transfer this table using a DB Link at all? Any other suggestions?
Thanks a lot in advance
Francisco
|
|
|
|