insert all into 表1@链接名 values(A)
into 表2@链接名 values(B)select A,B from 表怎么会报 ora -02021 ?????????????单独执行insert into 表1@链接名 values(A)没有错
into 表2@链接名 values(B)select A,B from 表怎么会报 ora -02021 ?????????????单独执行insert into 表1@链接名 values(A)没有错
解决方案 »
- 想统计数据库指定时间段内的库表读取次数,有什么思路
- 2个date类型日期相减提示invalid number错误
- 求助:从informix向Oracle做数据迁移有什么好的方法
- 一个关于SQLCODE的简单问题,高分!
- 请问如何用命令来运行Oracle带参数的存储过程
- LDAP资料
- 对同一个表怎么进行多次统计查询
- 那个更快
- 有个数据库异地一致性的问题
- 存错过程求助:oracle存储过程报: 出现符号 "end-of-file"在需要下列之一时....
- ORA-01446: 无法使用distinct, group by 等子句从试图中选择rowid或采样
- 菜鸟问题,主键不匹配~~~~~~~~~~~~~~~~~~~~
DDL operations are not allowed on a remote database
Cause: An attempt was made to use a DDL operation on a remote database. For example, "CREATE TABLE tablename@remotedbname ...".
Action: To alter the remote database structure, you must connect to the remote database with the appropriate privileges.
你看看是不是有其他什么操作
有人能说说一条语句能多表插入远程数据库操作的吗
但是insert all就是不行,
这是ORACLE的限制,不能想当然。既然一条不支持,那么可以多条,写成一个事务就行了放入PL/SQL块或存储过程就行了。
Multitable inserts are subject to the following restrictions:•You can perform multitable inserts only on tables, not on views or materialized views.•You cannot perform a multitable insert into a remote table.•You cannot specify a table collection expression when performing a multitable insert.•In a multitable insert, all of the insert_into_clauses cannot combine to specify more than 999 target columns.•Multitable inserts are not parallelized if any target table is index organized or if any target table has a bitmap index defined on it.•Plan stability is not supported for multitable insert statements.•The subquery of the multitable insert statement cannot use a sequence.