DB link equivalent in Teradata

Database

DB link equivalent in Teradata

Hi,

I believe there is no concept of DBLINK in Teradata.
But what I wanted to know is if there is an efficient way of loading data from 1 table present in 1 database into another. These databases are on 2 different systems.
One way which I know is to use export and import. If I need to avoid that what I need to do.
Any other suggestion is welcome.

TIA..
2 REPLIES
N/A

Re: DB link equivalent in Teradata

There is an Arcmain Copy facility which will copy databases/ tables from one system to another.
N/A

Re: DB link equivalent in Teradata

But why is it failed to copy CLOB field in a table?
How could I copy/restore a table with CLOB fields?

Below is the warning message while coping a table with CLOB field:

*** Warning ARC1254:Can not restore LOB subtables to a
rehashed system.