SYS.DBMS_PREUP dependencies on DBA_TABLES

Line 2328: 'SELECT tablespace_name, contents, extent_management FROM SYS.dba_tablespaces ' ||

2324: END IF;
2325: END LOOP;
2326:
2327: OPEN tmp_cursor FOR
2328: 'SELECT tablespace_name, contents, extent_management FROM SYS.dba_tablespaces ' ||
2329: 'WHERE tablespace_name in (:1,' || default_tablespaces || ') or ' ||
2330: 'tablespace_name in (SELECT distinct T.tablespace_name ' ||
2331: 'FROM sys.dba_queues Q, ' ||
2332: 'sys.dba_tables T ' ||

Line 2332: 'sys.dba_tables T ' ||

2328: 'SELECT tablespace_name, contents, extent_management FROM SYS.dba_tablespaces ' ||
2329: 'WHERE tablespace_name in (:1,' || default_tablespaces || ') or ' ||
2330: 'tablespace_name in (SELECT distinct T.tablespace_name ' ||
2331: 'FROM sys.dba_queues Q, ' ||
2332: 'sys.dba_tables T ' ||
2333: 'WHERE Q.queue_table=T.table_name AND Q.owner = T.owner) or ' ||
2334: 'tablespace_name in (SELECT temporary_tablespace ' ||
2335: 'FROM sys.dba_users ' ||
2336: 'WHERE username = ''SYS'') '

Line 2696: EXECUTE IMMEDIATE 'SELECT count(*) FROM sys.dba_tables tb, sys.dba_queues q

2692:
2693: -- For tablespaces that are not undo:
2694: -- Now look for queues in user schemas
2695: IF ts_info(t).name != db_undo_tbs THEN
2696: EXECUTE IMMEDIATE 'SELECT count(*) FROM sys.dba_tables tb, sys.dba_queues q
2697: WHERE q.queue_table = tb.table_name AND
2698: tb.tablespace_name = '' || ts_info(t).name || '' AND tb.owner NOT IN
2699: (''SYS'',''SYSTEM'',''MDSYS'',''ORDSYS'',''OLAPSYS'',''XDB'',
2700: ''LBACSYS'',''CTXSYS'',''ODM'',''DMSYS'', ''WKSYS'',''WMSYS'',

Line 5301: EXECUTE IMMEDIATE 'SELECT NULL FROM sys.dba_tables t

5297: FUNCTION ts_has_queues (tsname VARCHAR2) RETURN BOOLEAN
5298: IS
5299: t_null CHAR(1);
5300: BEGIN
5301: EXECUTE IMMEDIATE 'SELECT NULL FROM sys.dba_tables t
5302: WHERE EXISTS
5303: (SELECT 1 FROM sys.dba_queues q
5304: WHERE q.queue_table = t.table_name AND q.owner = t.owner)
5305: AND t.tablespace_name = :1 AND rownum <= 1'

Line 9037: 'SELECT count(*) FROM dba_tables

9033: -- create a table to store invalid objects (create it if necessary)
9034: IF is_db_readonly = FALSE THEN
9035: tbl_exists := 0;
9036: EXECUTE IMMEDIATE
9037: 'SELECT count(*) FROM dba_tables
9038: WHERE table_name = ''REGISTRY$SYS_INV_OBJS'''
9039: INTO tbl_exists;
9040:
9041: IF tbl_exists != 0 -- if registry$sys_inv_objs table exists

Line 9075: 'SELECT count(*) FROM dba_tables

9071:
9072: IF nonsys_invalid_objs < 5000 THEN
9073: tbl_exists := 0;
9074: EXECUTE IMMEDIATE
9075: 'SELECT count(*) FROM dba_tables
9076: WHERE table_name = ''REGISTRY$NONSYS_INV_OBJS'''
9077: INTO tbl_exists;
9078:
9079: IF tbl_exists != 0 -- if registry$nonsys_inv_objs table exists

Line 10066: SELECT count(*) INTO preaud_cnt FROM dba_tables

10062: END;
10063:
10064: -- bug 16317592: check if SYS.aud$ already exists. may be upgrade
10065: -- script was run before. If SYS.aud$ exists, don't do anything
10066: SELECT count(*) INTO preaud_cnt FROM dba_tables
10067: WHERE table_name = 'AUD$' AND owner = 'SYS';
10068:
10069: IF ((status != -1) AND (preaud_cnt != 1)) THEN
10070: BEGIN

Line 10074: EXECUTE IMMEDIATE 'SELECT count(*) FROM dba_tables where OWNER=''SYS'' AND table_name=''PREUPG_AUD$'''

10070: BEGIN
10071: --
10072: -- This check means the ols script has not been executed
10073: --
10074: EXECUTE IMMEDIATE 'SELECT count(*) FROM dba_tables where OWNER=''SYS'' AND table_name=''PREUPG_AUD$'''
10075: into preaud_cnt;
10076: IF preaud_cnt = 0 THEN
10077: condition_exists := TRUE;
10078: END IF;