1)sqlldr
2)建立dblink,insert into a (select * from a.u_dblink)
2)建立dblink,insert into a (select * from a.u_dblink)
解决方案 »
- ORACLE procedure 有参数长度 有什么办法能解决吗?
- 关于执行计划的问题
- 请问ORACLE中如何获得上月第一天的0点0分0秒
- 求一条高难SQL!
- 行---列 倒置
- 如何在oracle或sqlserver中用insert into 命令或者其他命令插入多行值
- 请问"期数"这个字段用英文应该怎么表示
- 如何得到小时差结果?
- 安装oracle9 for 98 机器最底配置怎样?
- ORA-01562: 扩展重算段号3失败 ORA-01628: 已达到 max # extents (121)(重算段RB1) 是什么错误?如何解决?
- VC中用ADO方法select CLOB字段的问题
- 有一組數據,如果我想更新其中的第n條,該怎麼寫?
Connections from Oracle 9.2 to Oracle7 are Not Supported
This alert documents a restriction introduced in Oracle 9.2.0.1 which was omitted from the shipped documentation / README files.
Versions Affected
Oracle9i Release 2 (9.2.0.1) onwards is affected.
Platforms Affected
GENERIC , all platforms are affected
Description
Contrary to references in the documentation which may indicate otherwise connections from an Oracle 9.2 client to any Oracle7 database are NOT supported. This includes any form of Oracle 9.2 client such as:
Client code statically linked with Oracle 9.2 client libraries
Dynamically linked client code which uses Oracle 9.2 shared client libraries
Database link connections from Oracle 9.2 to any Oracle7 database or gateway
This alert is to warn customers of this restriction. Oracle 9.2 does not report an error at connect time but subsequent operations may fail with unexpected errors or dumps.
powerbuilder的数据管道。