inserting LONG data types

[Quoted] I have two databases.

I am trying to insert information from one of the databases to the other database using a database link.

The tables are identical.

So the table schema looks like this:

employee:

name varchar2(10)
phone varchar2(5)
address long

I am running the following query on a test database and I want to get this information from the production database.

The query:

insert into employee select * from employee_at_prod;

Why does this not work? And if this does not work, what can I do to work around?

Thanks!

-- 


====================================================================

PETER CHAN, Northern Telecom
PHONE: (613) 763-9096   FAX: (613) 763-4408   EMAIL: chanp_at_nortel.ca


====================================================================