Recreate WMSYS And WMCONCAT

Buğra PARLAYAN

2 years ago

In some cases you may lose WMSYS user or WMCONCAT functionality. In such case we need to Recreate WMSYS And WMCONCAT.

To do this, simply follow the steps below.

$sqlplus / as sysdba
SQL>@$ORACLE_HOME/rdbms/admin/owmctab.plb

1 2	$sqlplus / as sysdba SQL>@$ORACLE_HOME/rdbms/admin/owmctab.plb

CREATE OR REPLACE FUNCTION wm_concat (p1 VARCHAR2)
RETURN VARCHAR2
AGGREGATE USING wm_concat_impl;
/

CREATE OR REPLACE FUNCTION wm_concat (p1 VARCHAR2)

RETURN VARCHAR2

AGGREGATE USING wm_concat_impl;