- 博客(3)
- 资源 (12)
- 收藏
- 关注
转载 Referencing User Defined Types over DBLink
Consider a PL/SQL call to a function which returns a user-defined type (UDT) – say, a SQL Type object. This works well as long as the called function resides in the same database as the calling PL/SQL
2014-10-22 20:42:01 825
转载 ORA-22804: remote operations not permitted on object tables or user-defined type columns
Query user defined types over database linkMay 10, 2014 by Domagoj Smoljanović.Querying tables over database link is very common today. But what happens when we have a table that depends o
2014-10-22 20:05:34 1808
转载 ORACLE直接路径操作
总结:直接路径插入直接在高水位线以外分配空间,绕过了数据缓冲区,直接将数据插入进表所在数据文件中。直接路径插入不产生Redo(数据库处于NOARCHIVELOG模式下插入或者NOLOGGING属性的表格上插入)和Undo Log,依赖高水点实现回滚。 *数据库日志模式http://blog.csdn.net/fw0124/article/details/690172
2014-10-20 10:08:37 1883
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人