2014年10月_rudy_gao

10月 09月 08月 07月 06月 05月 04月 03月 02月 01月

转载 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 1804

转载 ORACLE直接路径操作

总结：直接路径插入直接在高水位线以外分配空间，绕过了数据缓冲区，直接将数据插入进表所在数据文件中。直接路径插入不产生Redo（数据库处于NOARCHIVELOG模式下插入或者NOLOGGING属性的表格上插入）和Undo Log，依赖高水点实现回滚。 *数据库日志模式http://blog.csdn.net/fw0124/article/details/690172

2014-10-20 10:08:37 1881