SYS.DBMS_PREUP dependencies on OBJ$

Line 6887: 'SELECT NULL FROM sys.obj$ WHERE owner# = (SELECT user# from SYS.USER$

6883:
6884: IF user_exists THEN
6885: BEGIN
6886: EXECUTE IMMEDIATE
6887: 'SELECT NULL FROM sys.obj$ WHERE owner# = (SELECT user# from SYS.USER$
6888: WHERE name=''APPQOSSYS'') AND
6889: name =''WLM_METRICS_STREAM'' AND type# = 2'
6890: INTO t_null;
6891: EXCEPTION

Line 9215: 'FROM SYS.OBJ$ o, SYS.COL$ c, SYS.COLTYPE$ t, SYS.USER$ u ' ||

9211: BEGIN
9212: --
9213: BEGIN
9214: EXECUTE IMMEDIATE 'SELECT COUNT(*) ' ||
9215: 'FROM SYS.OBJ$ o, SYS.COL$ c, SYS.COLTYPE$ t, SYS.USER$ u ' ||
9216: 'WHERE o.OBJ# = t.OBJ# AND c.OBJ# = t.OBJ# ' ||
9217: 'AND c.COL# = t.COL# AND t.INTCOL# = c.INTCOL# ' ||
9218: 'AND BITAND(t.FLAGS, 256) = 256 AND o.OWNER# = u.USER# ' ||
9219: 'AND o.OWNER# in ' ||

Line 9293: t_tabname sys.obj$.name%TYPE;

9289: result_txt IN OUT VARCHAR2,
9290: pSqlcode IN OUT NUMBER) RETURN number
9291: IS
9292: t_cursor cursor_t;
9293: t_tabname sys.obj$.name%TYPE;
9294: t_schema sys.user$.name%TYPE;
9295: t_full_name VARCHAR2(261); -- extra for quotes and .
9296: t_sqltxt VARCHAR2(4000);
9297: t_new_err VARCHAR2(500);

Line 9307: 'FROM SYS.OBJ$ o, SYS.COL$ c, SYS.COLTYPE$ t, SYS.USER$ u ' ||

9303: BEGIN
9304: result_txt := '';
9305:
9306: OPEN t_cursor FOR 'SELECT DISTINCT (o.NAME), u.NAME ' ||
9307: 'FROM SYS.OBJ$ o, SYS.COL$ c, SYS.COLTYPE$ t, SYS.USER$ u ' ||
9308: 'WHERE o.OBJ# = t.OBJ# AND c.OBJ# = t.OBJ# ' ||
9309: 'AND c.COL# = t.COL# AND t.INTCOL# = c.INTCOL# ' ||
9310: 'AND BITAND(t.FLAGS, 256) = 256 AND o.OWNER# = u.USER# ' ||
9311: 'AND o.OWNER# in (SELECT r.schema# FROM SYS.REGISTRY$ r ' ||

Line 9399: 'FROM SYS.OBJ$ o, SYS.COL$ c, SYS.COLTYPE$ t, SYS.USER$ u ' ||

9395: -- by using NOT IN clause
9396: --
9397: BEGIN
9398: EXECUTE IMMEDIATE 'SELECT COUNT(*) ' ||
9399: 'FROM SYS.OBJ$ o, SYS.COL$ c, SYS.COLTYPE$ t, SYS.USER$ u ' ||
9400: 'WHERE o.OBJ# = t.OBJ# AND c.OBJ# = t.OBJ# ' ||
9401: 'AND c.COL# = t.COL# AND t.INTCOL# = c.INTCOL# ' ||
9402: 'AND BITAND(t.FLAGS, 256) = 256 AND o.OWNER# = u.USER# ' ||
9403: 'AND o.OWNER# NOT IN ' ||

Line 9478: t_tabname sys.obj$.name%TYPE;

9474: result_txt IN OUT VARCHAR2,
9475: pSqlcode IN OUT NUMBER) RETURN number
9476: IS
9477: t_cursor cursor_t;
9478: t_tabname sys.obj$.name%TYPE;
9479: t_schema sys.user$.name%TYPE;
9480: t_full_name VARCHAR2(256);
9481: t_sqltxt VARCHAR2(4000);
9482: t_new_err VARCHAR2(500);

Line 9492: 'FROM SYS.OBJ$ o, SYS.COL$ c, SYS.COLTYPE$ t, SYS.USER$ u ' ||

9488: BEGIN
9489: result_txt := '';
9490:
9491: OPEN t_cursor FOR 'SELECT DISTINCT (o.NAME), u.NAME ' ||
9492: 'FROM SYS.OBJ$ o, SYS.COL$ c, SYS.COLTYPE$ t, SYS.USER$ u ' ||
9493: 'WHERE o.OBJ# = t.OBJ# AND c.OBJ# = t.OBJ# ' ||
9494: 'AND c.COL# = t.COL# AND t.INTCOL# = c.INTCOL# ' ||
9495: 'AND BITAND(t.FLAGS, 256) = 256 AND o.OWNER# = u.USER# ' ||
9496: 'AND o.OWNER# NOT IN (SELECT UNIQUE (d.USER_ID) FROM ' ||

Line 9908: 'SELECT NULL FROM sys.obj$ WHERE owner# = (SELECT user# from SYS.USER$

9904:
9905: IF user_exists THEN
9906: BEGIN
9907: EXECUTE IMMEDIATE
9908: 'SELECT NULL FROM sys.obj$ WHERE owner# = (SELECT user# from SYS.USER$
9909: WHERE name=''ORACLE_OCM'') AND
9910: name =''MGMT_DB_LL_METRICS'' AND type# = 9'
9911: INTO t_null;
9912: EXCEPTION