Loading data across platforms

[smoothyc]

Help needed when inserting data from a UNIX box running Oracle 7.3.4 to an NT box running Oracle 8.1.6.

When trying to insert data from the UNIX box to the NT box I receive the following error:

ORA-02085: database link SYS_LINK.CCB.COM connects to SYS.WORLD

1) On the NT box I created the following database link:
create database link sys_link connect to scott identified by tiger using 'sys';

2) I submitted the SQL statement:
insert into table_a
select * from table_a@sys_link;

3) I receive this error:
ORA-02085: database link SYS_LINK.CCB.COM connects to SYS.WORLD


The tables on both boxes are setup exactly the same. I can insert from one instance to other just as long as I'm on the same platform. It's when I try to cross platforms when I receive the error.

Any help would be greatly appreciated.

Thanks,
Charles

[smoothyc]

Table is to large. 4.5 million rows.

Is there a way to export a certain number of records?