eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.DBMS_PREUP dependencies on USER$

Line 2137: -- schema exists in USER$ below which means its

2133:
2134: --
2135: -- Grab the Component ID (varchar2) from
2136: -- registry, and then see if the
2137: -- schema exists in USER$ below which means its
2138: -- in use in this database.
2139: --
2140: OPEN reg_cursor FOR
2141: 'SELECT cid, status, version, schema#

Line 2152: EXECUTE IMMEDIATE 'SELECT name FROM sys.user$ WHERE user#=:1'

2148:
2149: -- If the status is not REMOVED or REMOVING
2150: IF n_status NOT IN (99,8)
2151: THEN
2152: EXECUTE IMMEDIATE 'SELECT name FROM sys.user$ WHERE user#=:1'
2153: INTO c_schema
2154: USING n_schema;
2155:
2156: FOR i IN 1..max_components LOOP

Line 2171: EXECUTE IMMEDIATE 'SELECT NULL FROM sys.user$ WHERE name = ''WKSYS'''

2167:
2168: -- Ultra Search not in 10.1.0.2 registry so check schema
2169: IF NOT cmp_info(wk).processed THEN
2170: BEGIN
2171: EXECUTE IMMEDIATE 'SELECT NULL FROM sys.user$ WHERE name = ''WKSYS'''
2172: INTO c_null;
2173: store_comp(wk, 'WKSYS', db_version, NULL);
2174: EXCEPTION
2175: WHEN NO_DATA_FOUND THEN NULL;

Line 2218: EXECUTE IMMEDIATE 'SELECT NULL FROM sys.user$ WHERE name = ''DVSYS'''

2214:
2215: -- Database Vault not in registry so check for dvsys schema
2216: IF NOT cmp_info(dv).processed THEN
2217: BEGIN
2218: EXECUTE IMMEDIATE 'SELECT NULL FROM sys.user$ WHERE name = ''DVSYS'''
2219: INTO c_null;
2220: store_comp(dv, 'DVSYS', '10.2.0', NULL);
2221: EXCEPTION
2222: WHEN NO_DATA_FOUND THEN NULL;

Line 6795: 'SELECT NULL FROM sys.user$ WHERE name=''AUDIT_ADMIN'''

6791: END IF;
6792:
6793: BEGIN
6794: EXECUTE IMMEDIATE
6795: 'SELECT NULL FROM sys.user$ WHERE name=''AUDIT_ADMIN'''
6796: INTO t_null;
6797: EXCEPTION
6798: WHEN NO_DATA_FOUND then roll_exists := 0;
6799: END;

Line 6878: EXECUTE IMMEDIATE 'SELECT user# FROM sys.user$ WHERE name=''APPQOSSYS'''

6874: return c_status_not_for_this_version;
6875: END IF;
6876:
6877: BEGIN
6878: EXECUTE IMMEDIATE 'SELECT user# FROM sys.user$ WHERE name=''APPQOSSYS'''
6879: INTO tmp_num1;
6880: EXCEPTION
6881: WHEN NO_DATA_FOUND then user_exists := FALSE;
6882: END;

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 6969: 'SELECT NULL FROM sys.user$ WHERE name = ''AUDSYS'''

6965: END IF;
6966:
6967: BEGIN
6968: EXECUTE IMMEDIATE
6969: 'SELECT NULL FROM sys.user$ WHERE name = ''AUDSYS'''
6970: INTO t_null;
6971: EXCEPTION
6972: WHEN NO_DATA_FOUND then user_exists := 0;
6973: END;

Line 7050: 'SELECT NULL FROM sys.user$ WHERE NAME = ''AUDIT_VIEWER'''

7046: END IF;
7047:
7048: BEGIN
7049: EXECUTE IMMEDIATE
7050: 'SELECT NULL FROM sys.user$ WHERE NAME = ''AUDIT_VIEWER'''
7051: INTO t_null;
7052: EXCEPTION
7053: WHEN NO_DATA_FOUND then roll_exists := 0;
7054: END;

Line 7132: 'SELECT NULL FROM sys.user$ WHERE NAME = ''SYSBACKUP'''

7128: END IF;
7129:
7130: BEGIN
7131: EXECUTE IMMEDIATE
7132: 'SELECT NULL FROM sys.user$ WHERE NAME = ''SYSBACKUP'''
7133: INTO t_null;
7134: EXCEPTION
7135: WHEN NO_DATA_FOUND then user_exists := 0;
7136: END;

Line 7214: 'SELECT NULL FROM sys.user$ WHERE NAME = ''SYSDG'''

7210: END IF;
7211:
7212: BEGIN
7213: EXECUTE IMMEDIATE
7214: 'SELECT NULL FROM sys.user$ WHERE NAME = ''SYSDG'''
7215: INTO t_null;
7216: EXCEPTION
7217: WHEN NO_DATA_FOUND then user_exists := 0;
7218: END;

Line 7296: 'SELECT NULL FROM sys.user$ WHERE NAME = ''SYSKM'''

7292: END IF;
7293:
7294: BEGIN
7295: EXECUTE IMMEDIATE
7296: 'SELECT NULL FROM sys.user$ WHERE NAME = ''SYSKM'''
7297: INTO t_null;
7298: EXCEPTION
7299: WHEN NO_DATA_FOUND then user_exists := 0;
7300: END;

Line 7378: 'SELECT NULL FROM sys.user$ WHERE NAME = ''CAPTURE_ADMIN'''

7374: END IF;
7375:
7376: BEGIN
7377: EXECUTE IMMEDIATE
7378: 'SELECT NULL FROM sys.user$ WHERE NAME = ''CAPTURE_ADMIN'''
7379: INTO t_null;
7380: EXCEPTION
7381: WHEN NO_DATA_FOUND then role_exists := 0;
7382: END;

Line 7461: 'SELECT NULL FROM sys.user$ WHERE NAME = ''GSMCATUSER'''

7457: END IF;
7458:
7459: BEGIN
7460: EXECUTE IMMEDIATE
7461: 'SELECT NULL FROM sys.user$ WHERE NAME = ''GSMCATUSER'''
7462: INTO t_null;
7463: EXCEPTION
7464: WHEN NO_DATA_FOUND then user_exists := 0;
7465: END;

Line 7543: 'SELECT NULL FROM sys.user$ WHERE NAME = ''GSMUSER'''

7539: END IF;
7540:
7541: BEGIN
7542: EXECUTE IMMEDIATE
7543: 'SELECT NULL FROM sys.user$ WHERE NAME = ''GSMUSER'''
7544: INTO t_null;
7545: EXCEPTION
7546: WHEN NO_DATA_FOUND then user_exists := 0;
7547: END;

Line 7625: 'SELECT NULL FROM sys.user$ WHERE NAME = ''GSMADMIN_INTERNAL'''

7621: END IF;
7622:
7623: BEGIN
7624: EXECUTE IMMEDIATE
7625: 'SELECT NULL FROM sys.user$ WHERE NAME = ''GSMADMIN_INTERNAL'''
7626: INTO t_null;
7627: EXCEPTION
7628: WHEN NO_DATA_FOUND then user_exists := 0;
7629: END;

Line 7707: 'SELECT NULL FROM sys.user$ WHERE NAME = ''GSMUSER_ROLE'''

7703: END IF;
7704:
7705: BEGIN
7706: EXECUTE IMMEDIATE
7707: 'SELECT NULL FROM sys.user$ WHERE NAME = ''GSMUSER_ROLE'''
7708: INTO t_null;
7709: EXCEPTION
7710: WHEN NO_DATA_FOUND then role_exists := 0;
7711: END;

Line 7789: 'SELECT NULL FROM sys.user$ WHERE NAME = ''GSM_POOLADMIN_ROLE'''

7785: END IF;
7786:
7787: BEGIN
7788: EXECUTE IMMEDIATE
7789: 'SELECT NULL FROM sys.user$ WHERE NAME = ''GSM_POOLADMIN_ROLE'''
7790: INTO t_null;
7791: EXCEPTION
7792: WHEN NO_DATA_FOUND then role_exists := 0;
7793: END;

Line 7871: 'SELECT NULL FROM sys.user$ WHERE NAME = ''GSMADMIN_ROLE'''

7867: END IF;
7868:
7869: BEGIN
7870: EXECUTE IMMEDIATE
7871: 'SELECT NULL FROM sys.user$ WHERE NAME = ''GSMADMIN_ROLE'''
7872: INTO t_null;
7873: EXCEPTION
7874: WHEN NO_DATA_FOUND then role_exists := 0;
7875: END;

Line 7953: 'SELECT NULL FROM sys.user$ WHERE NAME = ''GDS_CATALOG_SELECT'''

7949: END IF;
7950:
7951: BEGIN
7952: EXECUTE IMMEDIATE
7953: 'SELECT NULL FROM sys.user$ WHERE NAME = ''GDS_CATALOG_SELECT'''
7954: INTO t_null;
7955: EXCEPTION
7956: WHEN NO_DATA_FOUND then role_exists := 0;
7957: END;

Line 8784: 'SELECT NULL FROM sys.user$ WHERE (name=''FILES_BACKUP_MODE'' and type#=0)'

8780: END IF;
8781:
8782: BEGIN
8783: EXECUTE IMMEDIATE
8784: 'SELECT NULL FROM sys.user$ WHERE (name=''FILES_BACKUP_MODE'' and type#=0)'
8785: INTO t_null;
8786: EXCEPTION
8787: WHEN NO_DATA_FOUND then roll_exists := 0;
8788: END;

Line 8801: 'SELECT name FROM sys.user$ WHERE (name=''FILES_BACKUP_MODE'' and type#=0)',

8797: 'There are files in backup mode. Ensure no files are in backup mode prior to upgrade.',
8798: 'Ensure no files are in backup mode prior to upgrade.',
8799: 'Ensure no files are in backup mode prior to upgrade.',
8800: c_dbua_detail_type_sql,
8801: 'SELECT name FROM sys.user$ WHERE (name=''FILES_BACKUP_MODE'' and type#=0)',
8802: c_dbua_fixup_type_manual,
8803: c_dbua_fixup_stage_pre);
8804: ELSE
8805: result_txt := FILES_BACKUP_MODE_gethelp(c_help_overview);

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 9294: t_schema sys.user$.name%TYPE;

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);
9298: t_error BOOLEAN := FALSE;

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 9479: t_schema sys.user$.name%TYPE;

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);
9483: t_error BOOLEAN := FALSE;

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 9900: 'SELECT user# from SYS.USER$ WHERE name=''ORACLE_OCM'''

9896:
9897: user_exists := TRUE;
9898: BEGIN
9899: EXECUTE IMMEDIATE
9900: 'SELECT user# from SYS.USER$ WHERE name=''ORACLE_OCM'''
9901: INTO tmp_num1;
9902: EXCEPTION WHEN NO_DATA_FOUND then user_exists := FALSE;
9903: END;
9904:

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

Line 10450: EXECUTE IMMEDIATE 'SELECT NULL FROM sys.user$ WHERE name=''DMSYS'''

10446: RETURN c_status_success;
10447: END IF;
10448:
10449: BEGIN
10450: EXECUTE IMMEDIATE 'SELECT NULL FROM sys.user$ WHERE name=''DMSYS'''
10451: INTO t_null;
10452: status := 1;
10453: EXCEPTION
10454: WHEN NO_DATA_FOUND THEN NULL;

Line 10472: 'select name from sys.user$ where name=''DMSYS''',

10468: 'The DMSYS schema exists in the database.',
10469: 'Refer to the Oracle Data Mining User''s Guide for '
10470: || 'instructions on how to perform this task.',
10471: c_dbua_detail_type_sql,
10472: 'select name from sys.user$ where name=''DMSYS''',
10473: c_dbua_fixup_type_manual,
10474: c_dbua_fixup_stage_pre );
10475: ELSE
10476: result_txt := REMOVE_DMSYS_gethelp(c_help_overview);

Line 10535: EXECUTE IMMEDIATE 'SELECT NULL FROM sys.user$ WHERE name=''XBRLSYS'''

10531: RETURN c_status_success;
10532: END IF;
10533:
10534: BEGIN
10535: EXECUTE IMMEDIATE 'SELECT NULL FROM sys.user$ WHERE name=''XBRLSYS'''
10536: INTO t_null;
10537: status := 1;
10538: EXCEPTION
10539: WHEN NO_DATA_FOUND THEN NULL;

Line 10557: 'select name from sys.user$ where name=''XBRLSYS''',

10553: 'The XBRLSYS schema exists in the database.',
10554: 'Refer to the Oracle Support Note for the latest available '
10555: || 'version on the current database.',
10556: c_dbua_detail_type_sql,
10557: 'select name from sys.user$ where name=''XBRLSYS''',
10558: c_dbua_fixup_type_manual,
10559: c_dbua_fixup_stage_pre );
10560: ELSE
10561: result_txt := XBRL_VERSION_gethelp(c_help_overview);

Line 11146: 'SELECT NULL FROM sys.user$ WHERE name = ''PROVISIONER'''

11142: END IF;
11143:
11144: BEGIN
11145: EXECUTE IMMEDIATE
11146: 'SELECT NULL FROM sys.user$ WHERE name = ''PROVISIONER'''
11147: INTO t_null;
11148: EXCEPTION
11149: WHEN NO_DATA_FOUND then user_exists := 0;
11150: END;

Line 11226: 'SELECT NULL FROM sys.user$ WHERE name = ''XS_RESOURCE'''

11222: END IF;
11223:
11224: BEGIN
11225: EXECUTE IMMEDIATE
11226: 'SELECT NULL FROM sys.user$ WHERE name = ''XS_RESOURCE'''
11227: INTO t_null;
11228: EXCEPTION
11229: WHEN NO_DATA_FOUND then user_exists := 0;
11230: END;

Line 11306: 'SELECT NULL FROM sys.user$ WHERE name = ''XS_SESSION_ADMIN'''

11302: END IF;
11303:
11304: BEGIN
11305: EXECUTE IMMEDIATE
11306: 'SELECT NULL FROM sys.user$ WHERE name = ''XS_SESSION_ADMIN'''
11307: INTO t_null;
11308: EXCEPTION
11309: WHEN NO_DATA_FOUND then user_exists := 0;
11310: END;

Line 11387: 'SELECT NULL FROM sys.user$ WHERE name = ''XS_NAMESPACE_ADMIN'''

11383: END IF;
11384:
11385: BEGIN
11386: EXECUTE IMMEDIATE
11387: 'SELECT NULL FROM sys.user$ WHERE name = ''XS_NAMESPACE_ADMIN'''
11388: INTO t_null;
11389: EXCEPTION
11390: WHEN NO_DATA_FOUND then user_exists := 0;
11391: END;

Line 11468: 'SELECT NULL FROM sys.user$ WHERE name = ''XS_CACHE_ADMIN'''

11464: END IF;
11465:
11466: BEGIN
11467: EXECUTE IMMEDIATE
11468: 'SELECT NULL FROM sys.user$ WHERE name = ''XS_CACHE_ADMIN'''
11469: INTO t_null;
11470: EXCEPTION
11471: WHEN NO_DATA_FOUND then user_exists := 0;
11472: END;

Line 11655: 'SELECT NULL FROM sys.user$ WHERE NAME = ''EM_EXPRESS_BASIC'''

11651: END IF;
11652:
11653: BEGIN
11654: EXECUTE IMMEDIATE
11655: 'SELECT NULL FROM sys.user$ WHERE NAME = ''EM_EXPRESS_BASIC'''
11656: INTO t_null;
11657: EXCEPTION
11658: WHEN NO_DATA_FOUND then role_exists := 0;
11659: END;

Line 11737: 'SELECT NULL FROM sys.user$ WHERE NAME = ''EM_EXPRESS_ALL'''

11733: END IF;
11734:
11735: BEGIN
11736: EXECUTE IMMEDIATE
11737: 'SELECT NULL FROM sys.user$ WHERE NAME = ''EM_EXPRESS_ALL'''
11738: INTO t_null;
11739: EXCEPTION
11740: WHEN NO_DATA_FOUND then role_exists := 0;
11741: END;