[20160806]12c 与 WMSYS.WM_CONCAT.txt

[20160806]12c 与 WMSYS.WM_CONCAT.txt

--前几天有人问临时表空间消耗的问题,链接:
http://www.itpub.net/thread-2065053-1-1.html
--我提到11g的wmsys.wm_concat也会使用临时表空间.
--链接:http://blog.itpub.net/267265/viewspace-1356256/

--但是在12c测试发现12c已经不存在WMSYS.WM_CONCAT,看来要建议开发不要在使用它连接字符串.
--测试如下:

1.环境:
SCOTT@test01p> @ ver1
PORT_STRING                    VERSION        BANNER                                                                               CON_ID
------------------------------ -------------- -------------------------------------------------------------------------------- ----------
IBMPC/WIN_NT64-9.1.0           12.1.0.1.0     Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production              0

2.测试:
SCOTT@test01p> select wmsys.wm_concat(dname) c60 from dept;
select wmsys.wm_concat(dname) c60 from dept
       *
ERROR at line 1:
ORA-00904: "WMSYS"."WM_CONCAT": invalid identifier

SCOTT@test01p> select owner,object_name,object_type from dba_objects where object_name='WM_CONCAT';
no rows selected

SCOTT@test01p> select * from dba_objects where owner='WMSYS' and object_type='FUNCTION';
no rows selected