This content has been marked as final. Show 3 replies
Apparently the WM_CONCAT public synonym (for WMSYS.WM_CONCAT) is still available in 11.2 EE, so this may just be an XE issue. Technically WM_CONCAT is not supported according to Oracle documentation, so the code should really be changed to use LISTAGG, at least for Oracle 11.2 and higher. SQL Developer only references it in a couple of xml files (RedoLogGroupSql and BackupSetFolder).
I will investigate and log a bug if necessary.
Thanks for reporting this,
SQL Developer Team
It seems WMSYS schema (workspace manager) does not exist for XE database,
Re: Features of Express Edition
suggests workspace manager is one feature not included in XE.
...so I wonder how apparent dependency on WM_CONCAT should/will be addressed by SQL Developer within XE context?
I found Bug 13850919 - RMAN BACKUP/RECOVERY > BACKUP SETS CAUSES WM_CONCAT ERROR already logged. The fix, as I speculated above, replaces WM_CONCAT with LISTAGG for Oracle 11.2 and higher releases. It will be in the next SQL Developer release and, of course, covers Oracle 11g XE.
As for Oracle 10g XE, it looks as though no fix is intended. Recommendation for 10g XE users: upgrade to Oracle 11g XE.
Note: the same comments apply to DBA/Storage/RedoLogGroup --> "SQL" viewer.-Gary