Thanks for the question, sateesh kumar.
Asked: September 07, 2000 - 9:53 am UTC
Last updated: September 07, 2000 - 9:53 am UTC
Version: 8.1.5
Viewed 1000+ times
You Asked
Hi,
I was trying to transfer data for a table from one database to another database. It comes out giving an error ora 0997. Tables are of same structure on both databases .
The insert statement is
insert into tbl_name
select * from tbl_name@dblnk
Can we not transfer data when a table has a long datatype.
Thanks
Sateesh
and Tom said...
No, you cannot use longs in that way. In Oracle8i, (8.0 and up actually) the appropriate type to use would be a CLOB -- Lobs do not suffer the limitations of a LONG or LONG RAW.
To move the long, you can either use EXP/IMP (export from source, import into target) or you can use the sqlplus copy command -- see
</code>
http://asktom.oracle.com/Misc/MoveLongs.html <code>
for the howto on that.
Is this answer out of date? If it is, please let us know via a Comment