当带有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博客 ” ,链接:http://blog.itpub.net/7417681/viewspace-710207/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7417681/viewspace-710207/