RE: Data Pump over NETWORK_LINK
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <Brandon.Allen@xxxxxxxxxxx>, <Richard.Goulet@xxxxxxxxxxx>, <vnulllists@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <Roger.Xu@xxxxxxxx>
- Date: Tue, 21 Apr 2009 14:44:14 -0400
If you have sqlplus and set long to at least the length of your longest
actual long value, then you can use the sqlplus copy command (subject to
other possible type limitations).
Do be advised that sqlplus copy will silently truncate any longs transmitted
to the actual length or the long setting, whichever is shorter.
Regards,
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Allen, Brandon
Sent: Tuesday, April 21, 2009 12:51 PM
To: Richard.Goulet@xxxxxxxxxxx; vnulllists@xxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx; Roger.Xu@xxxxxxxx
Subject: RE: Data Pump over NETWORK_LINK
Mr. Goulet and I had some further discussion and ran some tests and found
that impdp can indeed move a LONG column *definition* over a network link,
but it can't move any LONG *data*. So, if you have a table with a LONG
column, you should be able to move it if there isn't any data in that
column, however if even one row has data in the LONG column, then it will
fail with the following error:
"ORA-31679: Table data object "<username>"."<table_name>" has long columns,
and longs can not be loaded/unloaded using a network link"
I also found another Metalink Note documenting this restriction: 553337.1
The workaround is to use regular file-based data pump - it does support
LONGs, just not over a network link.
Regards,
Brandon
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions
and other information in this message that do not relate to the official
business of this company shall be understood as neither given nor endorsed
by it.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
