外部表卸载数据的限制
当带有as子句的可卸载数据的外部表建成之后，就不再可以从该外部表中的数据进行修改，即，不可增、删、改等操作。
如下：
--drop table all_objects_unload;
create table all_objects_unload
organization external
(
type oracle_datapump
default directory marcus_dump_dir
location('all_objects_unload.dat')
)
as
select * from all_objects;
insert into all_objects_unload
select * from all_objects_unload;
SQL Error: ORA-30657: operation not supported on external organized table
30657.0000 - "operation not supported on external organized table"
*Cause: User attempted on operation on an external table which is
not supported.
*Action: Don't do that!
此时如果再对外部表插入数据则会报错，这是一个让人比较蛋疼的限制，没有想明白为什么是这个样子。。。
如下：
--drop table all_objects_unload;
create table all_objects_unload
organization external
(
type oracle_datapump
default directory marcus_dump_dir
location('all_objects_unload.dat')
)
as
select * from all_objects;
insert into all_objects_unload
select * from all_objects_unload;
SQL Error: ORA-30657: operation not supported on external organized table
30657.0000 - "operation not supported on external organized table"
*Cause: User attempted on operation on an external table which is
not supported.
*Action: Don't do that!
此时如果再对外部表插入数据则会报错，这是一个让人比较蛋疼的限制，没有想明白为什么是这个样子。。。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7417681/viewspace-710207/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 区分exp&expdp导出的dmp文件
- ORA-27300、ORA-27301、ORA-27302、ORA-27303
- 字段 与 变量 同名造成的sql问题
- Configuring the Reserved Pool
- char, varchar2, nchar, nvarchar2
- ORA-39714: upgrade script utlmmig.sql failed
- Archive log rejected (thread 1 sequence 2200) at host 'standby'
- 数据文件offline后unusable索引造成的问题
- 物理备库open ORA-10458
- lsnrctl start - Linux Error 29 Illegal seek
