Navigation within SQL Developer version 3.1.06.44 DBA module "RMAN Backup/Recovery"->"Backup Sets" connected to XE 11gR2 results in error "ORA-00904: WM_CONCAT: invalid identifier". I've searched OTN forums a bit and it seems undocumented WM_CONCAT function no longer exists in 11gR2 which seems to suggest this may be a SQL Developer bug. Can anyone provide additional insight? Is there anyone out there successfully using this area of functionality within SQL Developer to perform XE backups via RMAN? Thanks, Glenn
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,
This link, 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.