Oracle Live SQL - Script: large_archive

Statement 1

SELECT * 
  FROM v$version


BANNER BANNER_FULL BANNER_LEGACY CON_ID
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.17.0.0.0 Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production 0

BANNER	BANNER_FULL	BANNER_LEGACY	CON_ID
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production	Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Version 19.17.0.0.0	Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production	0

Statement 2

CREATE TABLE xx_test_stg 
( 
  order_id   VARCHAR2(150) 
, line_id    VARCHAR2(150) 
, order_date DATE 
, net_value  NUMBER 
)

Table created.

Statement 3

CREATE INDEX xx_test_idx_01  
    ON xx_test_stg (order_id)

Index created.

Statement 4

CREATE INDEX xx_test_idx_02  
    ON xx_test_stg (line_id)

Index created.

Statement 5

SELECT * 
  FROM user_indexes


INDEX_NAME INDEX_TYPE TABLE_OWNER TABLE_NAME TABLE_TYPE UNIQUENESS COMPRESSION PREFIX_LENGTH TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOGGING BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE LAST_ANALYZED DEGREE INSTANCES PARTITIONED TEMPORARY GENERATED SECONDARY BUFFER_POOL FLASH_CACHE CELL_FLASH_CACHE USER_STATS DURATION PCT_DIRECT_ACCESS ITYP_OWNER ITYP_NAME PARAMETERS GLOBAL_STATS DOMIDX_STATUS DOMIDX_OPSTATUS FUNCIDX_STATUS JOIN_INDEX IOT_REDUNDANT_PKEY_ELIM DROPPED VISIBILITY DOMIDX_MANAGEMENT SEGMENT_CREATED ORPHANED_ENTRIES INDEXING AUTO CONSTRAINT_INDEX
XX_TEST_IDX_01 NORMAL SQL_YTNJIDSIIMIUZSDTLJJTHWVLS XX_TEST_STG TABLE NONUNIQUE DISABLED  - LIVESQL_USERS 2 255  -  -  -  -  -  -  -  -  - 10 YES 0 0 0 0 0 0 VALID 0 0 04-SEP-24 1 1 NO N N N DEFAULT DEFAULT DEFAULT NO  -  -  -  -  - YES  -  -  - NO NO NO VISIBLE  - NO NO FULL NO NO
XX_TEST_IDX_02 NORMAL SQL_YTNJIDSIIMIUZSDTLJJTHWVLS XX_TEST_STG TABLE NONUNIQUE DISABLED  - LIVESQL_USERS 2 255  -  -  -  -  -  -  -  -  - 10 YES 0 0 0 0 0 0 VALID 0 0 04-SEP-24 1 1 NO N N N DEFAULT DEFAULT DEFAULT NO  -  -  -  -  - YES  -  -  - NO NO NO VISIBLE  - NO NO FULL NO NO

2 rows selected.

Statement 6

SELECT * 
  FROM user_ind_columns


INDEX_NAME TABLE_NAME COLUMN_NAME COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESCEND COLLATED_COLUMN_ID
XX_TEST_IDX_01 XX_TEST_STG ORDER_ID 1 150 150 ASC  - 
XX_TEST_IDX_02 XX_TEST_STG LINE_ID 1 150 150 ASC  - 

2 rows selected.

INDEX_NAME	TABLE_NAME	COLUMN_NAME	COLUMN_POSITION	COLUMN_LENGTH	CHAR_LENGTH	DESCEND	COLLATED_COLUMN_ID
XX_TEST_IDX_01	XX_TEST_STG	ORDER_ID	1	150	150	ASC	-
XX_TEST_IDX_02	XX_TEST_STG	LINE_ID	1	150	150	ASC	-

Statement 7

SELECT * 
  FROM v$version


BANNER BANNER_FULL BANNER_LEGACY CON_ID
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.17.0.0.0 Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production 0

BANNER	BANNER_FULL	BANNER_LEGACY	CON_ID
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production	Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Version 19.17.0.0.0	Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production	0

Statement 8

CREATE INDEX xx_test_idx_01  
    ON xx_test_stg (order_id)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 9

CREATE INDEX xx_test_idx_02  
    ON xx_test_stg (line_id)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 10

SELECT * 
  FROM dba_objects do1

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 11

SELECT * 
  FROM v$version


BANNER BANNER_FULL BANNER_LEGACY CON_ID
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.17.0.0.0 Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production 0

BANNER	BANNER_FULL	BANNER_LEGACY	CON_ID
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production	Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Version 19.17.0.0.0	Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production	0

Statement 12

CREATE TABLE xx_test_stg 
( 
  order_id   VARCHAR2(150) 
, line_id    VARCHAR2(150) 
, order_date DATE 
, net_value  NUMBER 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 13

CREATE INDEX xx_test_idx_01  
    ON xx_test_stg (order_id)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 14

CREATE INDEX xx_test_idx_02  
    ON xx_test_stg (line_id)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 15

SELECT * 
  FROM dba_objects do1

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 16

SELECT * 
  FROM v$version


BANNER BANNER_FULL BANNER_LEGACY CON_ID
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.17.0.0.0 Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production 0

BANNER	BANNER_FULL	BANNER_LEGACY	CON_ID
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production	Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Version 19.17.0.0.0	Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production	0

Statement 17

CREATE TABLE xx_test_stg 
( 
  order_id   VARCHAR2(150) 
, line_id    VARCHAR2(150) 
, order_date DATE 
, net_value  NUMBER 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 18

CREATE INDEX xx_test_idx_01  
    ON xx_test_stg (order_id)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 19

CREATE INDEX xx_test_idx_02  
    ON xx_test_stg (line_id)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 20

SELECT * 
  FROM dba_objects do1

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 21

SELECT * 
  FROM v$version


BANNER BANNER_FULL BANNER_LEGACY CON_ID
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.17.0.0.0 Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production 0

BANNER	BANNER_FULL	BANNER_LEGACY	CON_ID
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production	Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Version 19.17.0.0.0	Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production	0

Statement 22

CREATE TABLE xx_test_stg 
( 
  order_id   VARCHAR2(150) 
, line_id    VARCHAR2(150) 
, order_date DATE 
, net_value  NUMBER 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 23

CREATE INDEX xx_test_idx_01  
    ON xx_test_stg (order_id)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 24

CREATE INDEX xx_test_idx_02  
    ON xx_test_stg (line_id)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 25

SELECT * 
  FROM dba_objects do1

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 26

SELECT * 
  FROM dba_objects do1

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 27

SELECT * 
  FROM v$version


BANNER BANNER_FULL BANNER_LEGACY CON_ID
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.17.0.0.0 Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production 0

BANNER	BANNER_FULL	BANNER_LEGACY	CON_ID
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production	Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Version 19.17.0.0.0	Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production	0

Statement 28

CREATE TABLE xx_test_stg 
( 
  order_id   VARCHAR2(150) 
, line_id    VARCHAR2(150) 
, order_date DATE 
, net_value  NUMBER 
)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 29

CREATE INDEX xx_test_idx_01  
    ON xx_test_stg (order_id)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 30

CREATE INDEX xx_test_idx_02  
    ON xx_test_stg (line_id)

ORA-00955: name is already used by an existing object

More Details: https://docs.oracle.com/error-help/db/ora-00955

Statement 31

SELECT * 
  FROM user_objects do1


OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS TEMPORARY GENERATED SECONDARY NAMESPACE EDITION_NAME SHARING EDITIONABLE ORACLE_MAINTAINED APPLICATION DEFAULT_COLLATION DUPLICATED SHARDED CREATED_APPID CREATED_VSNID MODIFIED_APPID MODIFIED_VSNID
DBMS_XPLAN  - 234812162  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
V$OPEN_CURSOR  - 234812161  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
V$SESSION  - 234812133  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
V$SQL  - 234812130  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
V$SQLSTATS  - 234812132  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
V$SQL_BIND_CAPTURE  - 234812160  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
V$SQL_PLAN  - 234812131  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
V$SQL_PLAN_STATISTICS_ALL  - 234812159  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
XX_TEST_IDX_01  - 234849584 234849584 INDEX 04-SEP-24 04-SEP-24 2024-09-04:00:48:14 VALID N N N 4  - NONE  - N N  - N N  -  -  -  - 
XX_TEST_IDX_02  - 234849624 234849624 INDEX 04-SEP-24 04-SEP-24 2024-09-04:00:48:35 VALID N N N 4  - NONE  - N N  - N N  -  -  -  - 
XX_TEST_STG  - 234849498 234849498 TABLE 04-SEP-24 04-SEP-24 2024-09-04:00:47:03 VALID N N N 1  - NONE  - N N USING_NLS_COMP N N  -  -  -  - 

11 rows selected.

Statement 32

SELECT * 
  FROM user_objects do1


OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS TEMPORARY GENERATED SECONDARY NAMESPACE EDITION_NAME SHARING EDITIONABLE ORACLE_MAINTAINED APPLICATION DEFAULT_COLLATION DUPLICATED SHARDED CREATED_APPID CREATED_VSNID MODIFIED_APPID MODIFIED_VSNID
DBMS_XPLAN  - 234812162  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
V$OPEN_CURSOR  - 234812161  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
V$SESSION  - 234812133  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
V$SQL  - 234812130  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
V$SQLSTATS  - 234812132  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
V$SQL_BIND_CAPTURE  - 234812160  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
V$SQL_PLAN  - 234812131  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
V$SQL_PLAN_STATISTICS_ALL  - 234812159  - SYNONYM 03-SEP-24 03-SEP-24 2024-09-03:16:10:21 VALID N N N 1  - NONE Y N N  - N N  -  -  -  - 
XX_TEST_IDX_01  - 234849584 234849584 INDEX 04-SEP-24 04-SEP-24 2024-09-04:00:48:14 VALID N N N 4  - NONE  - N N  - N N  -  -  -  - 
XX_TEST_IDX_02  - 234849624 234849624 INDEX 04-SEP-24 04-SEP-24 2024-09-04:00:48:35 VALID N N N 4  - NONE  - N N  - N N  -  -  -  - 
XX_TEST_STG  - 234849498 234849498 TABLE 04-SEP-24 04-SEP-24 2024-09-04:00:47:03 VALID N N N 1  - NONE  - N N USING_NLS_COMP N N  -  -  -  - 

11 rows selected.

Statement 33

SELECT COUNT(1) 
  FROM user_objects do1


COUNT(1)
11

COUNT(1)
11

Statement 34

SELECT COUNT(1) 
  FROM sys.dba_objects do1

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 35

SELECT COUNT(1) 
  FROM sys.dba_objects do1

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 36

SELECT COUNT(1) 
  FROM sys.dba_objects do1

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 37

SELECT COUNT(1) 
  FROM all_objects do1


COUNT(1)
53784

COUNT(1)
53784

Statement 38

SELECT * 
  FROM all_objects do1


OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS TEMPORARY GENERATED SECONDARY NAMESPACE EDITION_NAME SHARING EDITIONABLE ORACLE_MAINTAINED APPLICATION DEFAULT_COLLATION DUPLICATED SHARDED CREATED_APPID CREATED_VSNID MODIFIED_APPID MODIFIED_VSNID
SYS ORA$BASE  - 134  - EDITION 16-FEB-18 16-FEB-18 2018-02-16:05:00:13 VALID N N N 64  - NONE  - Y N  - N N  -  -  -  - 
SYS DUAL  - 143 143 TABLE 16-FEB-18 28-MAY-24 2018-02-16:05:00:13 VALID N N N 1  - METADATA LINK  - Y N USING_NLS_COMP N N  -  -  -  - 
PUBLIC DUAL  - 144  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:00:13 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC MAP_OBJECT  - 428  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:00:17 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC SYSTEM_PRIVILEGE_MAP  - 532  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:00:18 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC TABLE_PRIVILEGE_MAP  - 535  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:00:18 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
SYS USER_PRIVILEGE_MAP  - 536 536 TABLE 16-FEB-18 16-FEB-18 2018-02-16:05:00:18 VALID N N N 1  - DATA LINK  - Y N USING_NLS_COMP N N  -  -  -  - 
SYS I_USER_PRIVILEGE_MAP  - 537 537 INDEX 16-FEB-18 16-FEB-18 2018-02-16:05:00:18 VALID N N N 4  - NONE  - Y N  - N N  -  -  -  - 
PUBLIC USER_PRIVILEGE_MAP  - 538  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:00:18 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC STMT_AUDIT_OPTION_MAP  - 541  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:00:19 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
SYS MODELGTTRAW$  - 1401  - TABLE 16-FEB-18 08-MAR-24 2018-02-16:05:00:26 VALID Y N N 1  - METADATA LINK  - Y N USING_NLS_COMP N N  -  -  -  - 
SYS STANDARD  - 1750  - PACKAGE 16-FEB-18 16-JAN-19 2018-07-16:00:00:00 VALID N N N 1  - METADATA LINK N Y N USING_NLS_COMP N N  -  -  -  - 
SYS DBMS_STANDARD  - 1752  - PACKAGE 16-FEB-18 16-JAN-19 2018-02-16:05:01:31 VALID N N N 1  - METADATA LINK N Y N USING_NLS_COMP N N  -  -  -  - 
PUBLIC DBMS_STANDARD  - 1753  - SYNONYM 16-FEB-18 16-JAN-19 2018-02-16:05:01:31 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
SYS UTL_RAW  - 1763  - PACKAGE 16-FEB-18 14-DEC-22 2018-02-16:05:01:31 VALID N N N 1  - METADATA LINK N Y N USING_NLS_COMP N N  -  -  -  - 
PUBLIC V$MAP_LIBRARY  - 1765  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:31 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$MAP_FILE  - 1767  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:31 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$MAP_FILE_EXTENT  - 1769  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:31 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$MAP_ELEMENT  - 1771  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:31 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$MAP_EXT_ELEMENT  - 1773  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:31 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$MAP_COMP_LIST  - 1775  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:31 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$MAP_SUBELEMENT  - 1777  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:31 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$MAP_FILE_IO_STACK  - 1779  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:31 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$SQL_REDIRECTION  - 1781  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:31 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$SQL_PLAN  - 1783  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:31 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$SQL_PLAN_STATISTICS  - 1785  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$SQL_PLAN_STATISTICS_ALL  - 1787  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$ADVISOR_CURRENT_SQLPLAN  - 1789  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$SQL_WORKAREA  - 1791  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$SQL_WORKAREA_ACTIVE  - 1793  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$SQL_WORKAREA_HISTOGRAM  - 1795  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$PGA_TARGET_ADVICE  - 1797  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$PGA_TARGET_ADVICE_HISTOGRAM  - 1799  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$PGASTAT  - 1801  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$SYS_OPTIMIZER_ENV  - 1803  - SYNONYM 16-FEB-18 16-JAN-19 2019-01-16:03:54:01 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$SES_OPTIMIZER_ENV  - 1805  - SYNONYM 16-FEB-18 16-JAN-19 2019-01-16:03:54:01 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$SQL_OPTIMIZER_ENV  - 1807  - SYNONYM 16-FEB-18 16-JAN-19 2019-01-16:03:54:01 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$DLM_MISC  - 1809  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$DLM_LATCH  - 1811  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$DLM_CONVERT_LOCAL  - 1813  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$DLM_CONVERT_REMOTE  - 1815  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$DLM_ALL_LOCKS  - 1817  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$DLM_LOCKS  - 1819  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$DLM_RESS  - 1821  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$HVMASTER_INFO  - 1823  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$GCSHVMASTER_INFO  - 1825  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$GCSPFMASTER_INFO  - 1827  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC GV$DLM_TRAFFIC_CONTROLLER  - 1829  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC V$DLM_TRAFFIC_CONTROLLER  - 1831  - SYNONYM 16-FEB-18 16-FEB-18 2018-02-16:05:01:32 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 
PUBLIC GV$DYNAMIC_REMASTER_STATS  - 1833  - SYNONYM 16-FEB-18 16-JAN-19 2019-01-16:03:54:01 VALID N N N 1  - METADATA LINK N Y N  - N N  -  -  -  - 

Rows 1 - 50. More rows exist.

Statement 39

SELECT owner 
     , object_name||ROWNUM 
     , created 
     , object_id 
  FROM all_objects do1


OWNER OBJECT_NAME||ROWNUM CREATED OBJECT_ID
SYS ORA$BASE1 16-FEB-18 134
SYS DUAL2 16-FEB-18 143
PUBLIC DUAL3 16-FEB-18 144
PUBLIC MAP_OBJECT4 16-FEB-18 428
PUBLIC SYSTEM_PRIVILEGE_MAP5 16-FEB-18 532
PUBLIC TABLE_PRIVILEGE_MAP6 16-FEB-18 535
SYS USER_PRIVILEGE_MAP7 16-FEB-18 536
SYS I_USER_PRIVILEGE_MAP8 16-FEB-18 537
PUBLIC USER_PRIVILEGE_MAP9 16-FEB-18 538
PUBLIC STMT_AUDIT_OPTION_MAP10 16-FEB-18 541
SYS MODELGTTRAW$11 16-FEB-18 1401
SYS STANDARD12 16-FEB-18 1750
SYS DBMS_STANDARD13 16-FEB-18 1752
PUBLIC DBMS_STANDARD14 16-FEB-18 1753
SYS UTL_RAW15 16-FEB-18 1763
PUBLIC V$MAP_LIBRARY16 16-FEB-18 1765
PUBLIC V$MAP_FILE17 16-FEB-18 1767
PUBLIC V$MAP_FILE_EXTENT18 16-FEB-18 1769
PUBLIC V$MAP_ELEMENT19 16-FEB-18 1771
PUBLIC V$MAP_EXT_ELEMENT20 16-FEB-18 1773
PUBLIC V$MAP_COMP_LIST21 16-FEB-18 1775
PUBLIC V$MAP_SUBELEMENT22 16-FEB-18 1777
PUBLIC V$MAP_FILE_IO_STACK23 16-FEB-18 1779
PUBLIC V$SQL_REDIRECTION24 16-FEB-18 1781
PUBLIC V$SQL_PLAN25 16-FEB-18 1783
PUBLIC V$SQL_PLAN_STATISTICS26 16-FEB-18 1785
PUBLIC V$SQL_PLAN_STATISTICS_ALL27 16-FEB-18 1787
PUBLIC V$ADVISOR_CURRENT_SQLPLAN28 16-FEB-18 1789
PUBLIC V$SQL_WORKAREA29 16-FEB-18 1791
PUBLIC V$SQL_WORKAREA_ACTIVE30 16-FEB-18 1793
PUBLIC V$SQL_WORKAREA_HISTOGRAM31 16-FEB-18 1795
PUBLIC V$PGA_TARGET_ADVICE32 16-FEB-18 1797
PUBLIC V$PGA_TARGET_ADVICE_HISTOGRAM33 16-FEB-18 1799
PUBLIC V$PGASTAT34 16-FEB-18 1801
PUBLIC V$SYS_OPTIMIZER_ENV35 16-FEB-18 1803
PUBLIC V$SES_OPTIMIZER_ENV36 16-FEB-18 1805
PUBLIC V$SQL_OPTIMIZER_ENV37 16-FEB-18 1807
PUBLIC V$DLM_MISC38 16-FEB-18 1809
PUBLIC V$DLM_LATCH39 16-FEB-18 1811
PUBLIC V$DLM_CONVERT_LOCAL40 16-FEB-18 1813
PUBLIC V$DLM_CONVERT_REMOTE41 16-FEB-18 1815
PUBLIC V$DLM_ALL_LOCKS42 16-FEB-18 1817
PUBLIC V$DLM_LOCKS43 16-FEB-18 1819
PUBLIC V$DLM_RESS44 16-FEB-18 1821
PUBLIC V$HVMASTER_INFO45 16-FEB-18 1823
PUBLIC V$GCSHVMASTER_INFO46 16-FEB-18 1825
PUBLIC V$GCSPFMASTER_INFO47 16-FEB-18 1827
PUBLIC GV$DLM_TRAFFIC_CONTROLLER48 16-FEB-18 1829
PUBLIC V$DLM_TRAFFIC_CONTROLLER49 16-FEB-18 1831
PUBLIC GV$DYNAMIC_REMASTER_STATS50 16-FEB-18 1833

Rows 1 - 50. More rows exist.

OWNER	OBJECT_NAME\|\|ROWNUM	CREATED	OBJECT_ID
SYS	ORA$BASE1	16-FEB-18	134
SYS	DUAL2	16-FEB-18	143
PUBLIC	DUAL3	16-FEB-18	144
PUBLIC	MAP_OBJECT4	16-FEB-18	428
PUBLIC	SYSTEM_PRIVILEGE_MAP5	16-FEB-18	532
PUBLIC	TABLE_PRIVILEGE_MAP6	16-FEB-18	535
SYS	USER_PRIVILEGE_MAP7	16-FEB-18	536
SYS	I_USER_PRIVILEGE_MAP8	16-FEB-18	537
PUBLIC	USER_PRIVILEGE_MAP9	16-FEB-18	538
PUBLIC	STMT_AUDIT_OPTION_MAP10	16-FEB-18	541
SYS	MODELGTTRAW$11	16-FEB-18	1401
SYS	STANDARD12	16-FEB-18	1750
SYS	DBMS_STANDARD13	16-FEB-18	1752
PUBLIC	DBMS_STANDARD14	16-FEB-18	1753
SYS	UTL_RAW15	16-FEB-18	1763
PUBLIC	V$MAP_LIBRARY16	16-FEB-18	1765
PUBLIC	V$MAP_FILE17	16-FEB-18	1767
PUBLIC	V$MAP_FILE_EXTENT18	16-FEB-18	1769
PUBLIC	V$MAP_ELEMENT19	16-FEB-18	1771
PUBLIC	V$MAP_EXT_ELEMENT20	16-FEB-18	1773
PUBLIC	V$MAP_COMP_LIST21	16-FEB-18	1775
PUBLIC	V$MAP_SUBELEMENT22	16-FEB-18	1777
PUBLIC	V$MAP_FILE_IO_STACK23	16-FEB-18	1779
PUBLIC	V$SQL_REDIRECTION24	16-FEB-18	1781
PUBLIC	V$SQL_PLAN25	16-FEB-18	1783
PUBLIC	V$SQL_PLAN_STATISTICS26	16-FEB-18	1785
PUBLIC	V$SQL_PLAN_STATISTICS_ALL27	16-FEB-18	1787
PUBLIC	V$ADVISOR_CURRENT_SQLPLAN28	16-FEB-18	1789
PUBLIC	V$SQL_WORKAREA29	16-FEB-18	1791
PUBLIC	V$SQL_WORKAREA_ACTIVE30	16-FEB-18	1793
PUBLIC	V$SQL_WORKAREA_HISTOGRAM31	16-FEB-18	1795
PUBLIC	V$PGA_TARGET_ADVICE32	16-FEB-18	1797
PUBLIC	V$PGA_TARGET_ADVICE_HISTOGRAM33	16-FEB-18	1799
PUBLIC	V$PGASTAT34	16-FEB-18	1801
PUBLIC	V$SYS_OPTIMIZER_ENV35	16-FEB-18	1803
PUBLIC	V$SES_OPTIMIZER_ENV36	16-FEB-18	1805
PUBLIC	V$SQL_OPTIMIZER_ENV37	16-FEB-18	1807
PUBLIC	V$DLM_MISC38	16-FEB-18	1809
PUBLIC	V$DLM_LATCH39	16-FEB-18	1811
PUBLIC	V$DLM_CONVERT_LOCAL40	16-FEB-18	1813
PUBLIC	V$DLM_CONVERT_REMOTE41	16-FEB-18	1815
PUBLIC	V$DLM_ALL_LOCKS42	16-FEB-18	1817
PUBLIC	V$DLM_LOCKS43	16-FEB-18	1819
PUBLIC	V$DLM_RESS44	16-FEB-18	1821
PUBLIC	V$HVMASTER_INFO45	16-FEB-18	1823
PUBLIC	V$GCSHVMASTER_INFO46	16-FEB-18	1825
PUBLIC	V$GCSPFMASTER_INFO47	16-FEB-18	1827
PUBLIC	GV$DLM_TRAFFIC_CONTROLLER48	16-FEB-18	1829
PUBLIC	V$DLM_TRAFFIC_CONTROLLER49	16-FEB-18	1831
PUBLIC	GV$DYNAMIC_REMASTER_STATS50	16-FEB-18	1833

Statement 40

SELECT do1.owner 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM all_objects do1 
     , all_objects do2


OWNER DO1.OBJECT_NAME||ROWNUM CREATED OBJECT_ID
SYS ORA$BASE1 16-FEB-18 134
SYS DUAL2 16-FEB-18 143
SYS USER_PRIVILEGE_MAP3 16-FEB-18 536
SYS I_USER_PRIVILEGE_MAP4 16-FEB-18 537
SYS MODELGTTRAW$5 16-FEB-18 1401
SYS STANDARD6 16-FEB-18 1750
SYS DBMS_STANDARD7 16-FEB-18 1752
SYS UTL_RAW8 16-FEB-18 1763
SYS V_$LATCH9 16-FEB-18 1916
SYS V_$SESSTAT10 16-FEB-18 1936
SYS V_$MYSTAT11 16-FEB-18 1938
SYS V_$STATNAME12 16-FEB-18 1946
SYS V_$VERSION13 16-FEB-18 2064
SYS V_$TIMER14 16-FEB-18 2092
SYS V_$SESSION_EVENT15 16-FEB-18 2180
SYS V_$SESS_IO16 16-FEB-18 2210
SYS V_$SQL_CURSOR17 16-FEB-18 2235
SYS V_$SQL_BIND_METADATA18 16-FEB-18 2237
SYS V_$SQL_BIND_DATA19 16-FEB-18 2239
SYS V_$TIMEZONE_NAMES20 16-FEB-18 2389
SYS NLS_SESSION_PARAMETERS21 16-FEB-18 3512
SYS NLS_INSTANCE_PARAMETERS22 16-FEB-18 3514
SYS NLS_DATABASE_PARAMETERS23 16-FEB-18 3516
SYS DATABASE_COMPATIBLE_LEVEL24 16-FEB-18 3518
SYS PRODUCT_COMPONENT_VERSION25 16-FEB-18 3520
SYS TAB26 16-FEB-18 4522
SYS COL27 16-FEB-18 4525
SYS USER_TABLES28 16-FEB-18 4536
SYS USER_OBJECT_TABLES29 16-FEB-18 4539
SYS USER_ALL_TABLES30 16-FEB-18 4541
SYS ALL_TABLES31 16-FEB-18 4543
SYS ALL_OBJECT_TABLES32 16-FEB-18 4545
SYS ALL_ALL_TABLES33 16-FEB-18 4547
SYS DATABASE_PROPERTIES34 16-FEB-18 4561
SYS USER_CATALOG35 16-FEB-18 4567
SYS USER_OBJECTS36 16-FEB-18 4576
SYS USER_OBJECTS_AE37 16-FEB-18 4577
SYS ALL_OBJECTS38 16-FEB-18 4581
SYS USER_EDITIONING_VIEWS39 16-FEB-18 4597
SYS USER_EDITIONING_VIEWS_AE40 16-FEB-18 4598
SYS USER_EDITIONING_VIEW_COLS41 16-FEB-18 4613
SYS USER_EDITIONING_VIEW_COLS_AE42 16-FEB-18 4614
SYS USER_EDITIONED_TYPES43 16-FEB-18 4643
SYS USER_RESUMABLE44 16-FEB-18 4655
SYS USER_INDEXES45 16-FEB-18 4657
SYS ALL_INDEXES46 16-FEB-18 4660
SYS USER_IND_COLUMNS47 16-FEB-18 4666
SYS ALL_IND_COLUMNS48 16-FEB-18 4668
SYS USER_IND_EXPRESSIONS49 16-FEB-18 4675
SYS ALL_IND_EXPRESSIONS50 16-FEB-18 4677

Rows 1 - 50. More rows exist.

OWNER	DO1.OBJECT_NAME\|\|ROWNUM	CREATED	OBJECT_ID
SYS	ORA$BASE1	16-FEB-18	134
SYS	DUAL2	16-FEB-18	143
SYS	USER_PRIVILEGE_MAP3	16-FEB-18	536
SYS	I_USER_PRIVILEGE_MAP4	16-FEB-18	537
SYS	MODELGTTRAW$5	16-FEB-18	1401
SYS	STANDARD6	16-FEB-18	1750
SYS	DBMS_STANDARD7	16-FEB-18	1752
SYS	UTL_RAW8	16-FEB-18	1763
SYS	V_$LATCH9	16-FEB-18	1916
SYS	V_$SESSTAT10	16-FEB-18	1936
SYS	V_$MYSTAT11	16-FEB-18	1938
SYS	V_$STATNAME12	16-FEB-18	1946
SYS	V_$VERSION13	16-FEB-18	2064
SYS	V_$TIMER14	16-FEB-18	2092
SYS	V_$SESSION_EVENT15	16-FEB-18	2180
SYS	V_$SESS_IO16	16-FEB-18	2210
SYS	V_$SQL_CURSOR17	16-FEB-18	2235
SYS	V_$SQL_BIND_METADATA18	16-FEB-18	2237
SYS	V_$SQL_BIND_DATA19	16-FEB-18	2239
SYS	V_$TIMEZONE_NAMES20	16-FEB-18	2389
SYS	NLS_SESSION_PARAMETERS21	16-FEB-18	3512
SYS	NLS_INSTANCE_PARAMETERS22	16-FEB-18	3514
SYS	NLS_DATABASE_PARAMETERS23	16-FEB-18	3516
SYS	DATABASE_COMPATIBLE_LEVEL24	16-FEB-18	3518
SYS	PRODUCT_COMPONENT_VERSION25	16-FEB-18	3520
SYS	TAB26	16-FEB-18	4522
SYS	COL27	16-FEB-18	4525
SYS	USER_TABLES28	16-FEB-18	4536
SYS	USER_OBJECT_TABLES29	16-FEB-18	4539
SYS	USER_ALL_TABLES30	16-FEB-18	4541
SYS	ALL_TABLES31	16-FEB-18	4543
SYS	ALL_OBJECT_TABLES32	16-FEB-18	4545
SYS	ALL_ALL_TABLES33	16-FEB-18	4547
SYS	DATABASE_PROPERTIES34	16-FEB-18	4561
SYS	USER_CATALOG35	16-FEB-18	4567
SYS	USER_OBJECTS36	16-FEB-18	4576
SYS	USER_OBJECTS_AE37	16-FEB-18	4577
SYS	ALL_OBJECTS38	16-FEB-18	4581
SYS	USER_EDITIONING_VIEWS39	16-FEB-18	4597
SYS	USER_EDITIONING_VIEWS_AE40	16-FEB-18	4598
SYS	USER_EDITIONING_VIEW_COLS41	16-FEB-18	4613
SYS	USER_EDITIONING_VIEW_COLS_AE42	16-FEB-18	4614
SYS	USER_EDITIONED_TYPES43	16-FEB-18	4643
SYS	USER_RESUMABLE44	16-FEB-18	4655
SYS	USER_INDEXES45	16-FEB-18	4657
SYS	ALL_INDEXES46	16-FEB-18	4660
SYS	USER_IND_COLUMNS47	16-FEB-18	4666
SYS	ALL_IND_COLUMNS48	16-FEB-18	4668
SYS	USER_IND_EXPRESSIONS49	16-FEB-18	4675
SYS	ALL_IND_EXPRESSIONS50	16-FEB-18	4677

Statement 41

SELECT COUNT(1) 
  FROM all_objects do1 
     , all_objects do2

ORA-00040: active time limit exceeded - call aborted

More Details: https://docs.oracle.com/error-help/db/ora-00040

Statement 42

SELECT COUNT(1) 
  FROM all_objects do1 
     , all_objects do2

ORA-00040: active time limit exceeded - call aborted

More Details: https://docs.oracle.com/error-help/db/ora-00040

Statement 43

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.owner 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM all_objects do1 
     , all_objects do2

ORA-01536: space quota exceeded for tablespace 'LIVESQL_USERS' ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-01536

Statement 44

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.owner 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM all_objects do1

ORA-01536: space quota exceeded for tablespace 'LIVESQL_USERS' ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-01536

Statement 45

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.owner 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM all_objects do1

ORA-01536: space quota exceeded for tablespace 'LIVESQL_USERS' ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-01536

Statement 46

SELECT * 
  FROM v$version


BANNER BANNER_FULL BANNER_LEGACY CON_ID
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.17.0.0.0 Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production 0

BANNER	BANNER_FULL	BANNER_LEGACY	CON_ID
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production	Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Version 19.17.0.0.0	Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production	0

Statement 47

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.owner 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM all_objects do1

ORA-01536: space quota exceeded for tablespace 'LIVESQL_USERS' ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-01536

Statement 48

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.owner 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM all_objects do1

ORA-01536: space quota exceeded for tablespace 'LIVESQL_USERS' ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-01536

Statement 49

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.owner 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

ORA-00904: "DO1"."OWNER": invalid identifier

More Details: https://docs.oracle.com/error-help/db/ora-00904

Statement 50

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.owner 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

ORA-00904: "DO1"."OWNER": invalid identifier

More Details: https://docs.oracle.com/error-help/db/ora-00904

Statement 51

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.owner 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM all_objects do1

ORA-01536: space quota exceeded for tablespace 'LIVESQL_USERS' ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-01536

Statement 52

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

11 row(s) inserted.

Statement 53

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM all_objects do1

ORA-00904: "DO1"."TYPE": invalid identifier

More Details: https://docs.oracle.com/error-help/db/ora-00904

Statement 54

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM all_objects do1

ORA-01536: space quota exceeded for tablespace 'LIVESQL_USERS' ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-01536

Statement 55

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

11 row(s) inserted.

Statement 56

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

11 row(s) inserted.

Statement 57

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

11 row(s) inserted.

Statement 58

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

11 row(s) inserted.

Statement 59

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

11 row(s) inserted.

Statement 60

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

11 row(s) inserted.

Statement 61

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

11 row(s) inserted.

Statement 62

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

11 row(s) inserted.

Statement 63

SELECT COUNT(1) 
  FROM xx_test_stg


COUNT(1)
99

COUNT(1)
99

Statement 64

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

11 row(s) inserted.

Statement 65

SELECT COUNT(1) 
  FROM xx_test_stg


COUNT(1)
110

COUNT(1)
110

Statement 66

CREATE INDEX xx_test_arch_idx_01  
    ON xx_test_arch (order_id)

ORA-00942: table or view does not exist

More Details: https://docs.oracle.com/error-help/db/ora-00942

Statement 67

CREATE TABLE xx_test_arch 
( 
  order_id   VARCHAR2(150) 
, line_id    VARCHAR2(150) 
, order_date DATE 
, net_value  NUMBER 
)

Table created.

Statement 68

CREATE INDEX xx_test_arch_idx_01  
    ON xx_test_arch (order_id)

Index created.

Statement 69

CREATE INDEX xxx_test_arch_idx_02  
    ON xx_test_arch (line_id)

Index created.

Statement 70

INSERT /*+ APPEND */ 
  INTO xx_test_arch 
SELECT * 
  FROM xx_test_stg

ORA-01536: space quota exceeded for tablespace 'LIVESQL_USERS' ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-01536

Statement 71

truncate table xx_test_stg

Table truncated.

Statement 72

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

14 row(s) inserted.

Statement 73

INSERT /*+ APPEND */ 
  INTO xx_test_arch 
SELECT * 
  FROM xx_test_stg

14 row(s) inserted.

Statement 74

TRUNCATE TABLE xx_test_stg

Table truncated.

Statement 75

SELECT COUNT(1) 
  FROM xx_test_stg


COUNT(1)
14

COUNT(1)
14

Statement 76

SELECT COUNT(1) 
  FROM xx_test_arch


COUNT(1)
14

COUNT(1)
14

Statement 77

TRUNCATE TABLE xx_test_stg;

ORA-03291: Invalid truncate option - missing STORAGE keyword

More Details: https://docs.oracle.com/error-help/db/ora-03291

Statement 78

SELECT COUNT(1) 
  FROM xx_test_arch


COUNT(1)
14

COUNT(1)
14

Statement 79

SELECT * 
  FROM xx_test_stg

no data found

Statement 80

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

14 row(s) inserted.

Statement 81

DECLARE 
  l_insert_row_count NUMBER DEFAULT 0; 
BEGIN 
  INSERT /*+ APPEND */ 
    INTO xx_test_arch 
  SELECT * 
      FROM xx_test_stg; 
   
  dbms_output.put_line('No of rows inserted: '||SQL%ROWCOUNT); 
  COMMIT; 
 
  -- Delete statements are taking time when data volume is huge. Hence, using TRUNCATE 
  -- here to improve the performance. 
  EXECUTE IMMEDIATE 'TRUNCATE TABLE xx_test_stg'; 
EXCEPTION  
  WHEN OTHERS THEN 
    dbms_output.put_line('Error: '||SQLERRM) 
END;

ORA-06550: line 18, column 1:
PLS-00103: Encountered the symbol "END" when expecting one of the following:

   := . ( % ;
The symbol ";" was substituted for "END" to continue.

More Details: https://docs.oracle.com/error-help/db/ora-06550

Statement 82

DECLARE 
  l_insert_row_count NUMBER DEFAULT 0; 
BEGIN 
  INSERT /*+ APPEND */ 
    INTO xx_test_arch 
  SELECT * 
      FROM xx_test_stg; 
   
  dbms_output.put_line('No of rows inserted: '||SQL%ROWCOUNT); 
  COMMIT; 
 
  -- Delete statements are taking time when data volume is huge. Hence, using TRUNCATE 
  -- here to improve the performance. 
  EXECUTE IMMEDIATE 'TRUNCATE TABLE xx_test_stg'; 
EXCEPTION  
  WHEN OTHERS THEN 
    dbms_output.put_line('Error: '||SQLERRM); 
END;

Table truncated.
No of rows inserted: 14

Statement 83

DECLARE 
  l_bc_limit          NUMBER DEFAULT 100000; 
  l_select_rec_count  NUMBER DEFAULT 0; 
  l_insert_rec_count  NUMBER DEFAULT 0; 
  e_data_mismatch     EXCEPTION; 
 
  CURSOR l_stg_data_cur 
      IS 
  SELECT * 
    FROM xx_test_stg; 
 
    TYPE l_stg_tab_type 
      IS 
   TABLE OF xx_test_stg%ROWTYPE 
   INDEX BY SIMPLE_INTEGER; 
 
  l_stg_tab_t l_stg_tab_type; 
BEGIN 
    OPEN l_stg_data_cur; 
    LOOP 
      FETCH l_stg_data_cur 
       BULK COLLECT 
       INTO l_stg_tab_t 
      LIMIT l_bc_limit; 
 
      FORALL l_idx IN l_stg_tab_t.FIRST .. l_stg_tab_t.LAST 
        INSERT INTO xx_test_arch 
             VALUES l_stg_tab_t(l_idx); 
 
      EXIT WHEN l_stg_tab_t.COUNT < l_bc_limit; 
    END LOOP; 
    CLOSE l_stg_data_cur; 
 
  COMMIT; 
 
  -- Delete statements are taking time when data volume is huge. Hence, using TRUNCATE 
  -- here to improve the performance. 
  EXECUTE IMMEDIATE 'TRUNCATE TABLE xx_test_stg'; 
EXCEPTION  
  WHEN OTHERS THEN 
    dbms_output.put_line('Error: '||SQLERRM); 
END;

Statement processed.

Statement 84

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

14 row(s) inserted.

Statement 85

INSERT /*+ APPEND */ 
  INTO xx_test_stg    
SELECT do1.object_type 
     , do1.object_name||ROWNUM 
     , do1.created 
     , do1.object_id 
  FROM user_objects do1

14 row(s) inserted.

Statement 86

DECLARE 
  l_bc_limit          NUMBER DEFAULT 100000; 
  l_select_rec_count  NUMBER DEFAULT 0; 
  l_insert_rec_count  NUMBER DEFAULT 0; 
  e_data_mismatch     EXCEPTION; 
 
  CURSOR l_stg_data_cur 
      IS 
  SELECT * 
    FROM xx_test_stg; 
 
    TYPE l_stg_tab_type 
      IS 
   TABLE OF xx_test_stg%ROWTYPE 
   INDEX BY SIMPLE_INTEGER; 
 
  l_stg_tab_t l_stg_tab_type; 
BEGIN 
    OPEN l_stg_data_cur; 
    LOOP 
      FETCH l_stg_data_cur 
       BULK COLLECT 
       INTO l_stg_tab_t 
      LIMIT l_bc_limit; 
 
      l_select_rec_count := l_select_rec_count + l_stg_tab_t.COUNT; 
 
      FORALL l_idx IN l_stg_tab_t.FIRST .. l_stg_tab_t.LAST 
        INSERT INTO xx_test_arch 
             VALUES l_stg_tab_t(l_idx); 
 
      l_insert_rec_count := l_insert_rec_count + NVL(SQL%ROWCOUNT, 0); 
 
      EXIT WHEN l_stg_tab_t.COUNT < l_bc_limit; 
    END LOOP; 
    CLOSE l_stg_data_cur; 
 
  dbms_output.put_line('Select Count: '||l_select_rec_count); 
  dbms_output.put_line('Insert Count: '||l_insert_rec_count); 
  COMMIT; 
 
  -- Delete statements are taking time when data volume is huge. Hence, using TRUNCATE 
  -- here to improve the performance. 
  EXECUTE IMMEDIATE 'TRUNCATE TABLE xx_test_stg'; 
EXCEPTION  
  WHEN OTHERS THEN 
    dbms_output.put_line('Error: '||SQLERRM); 
END;

Statement processed.
Select Count: 14
Insert Count: 14

large_archive_table.sql

Additional Information

INDEX_NAME	INDEX_TYPE	TABLE_OWNER	TABLE_NAME	TABLE_TYPE	UNIQUENESS	COMPRESSION	PREFIX_LENGTH	TABLESPACE_NAME	INI_TRANS	MAX_TRANS	INITIAL_EXTENT	NEXT_EXTENT	MIN_EXTENTS	MAX_EXTENTS	PCT_INCREASE	PCT_THRESHOLD	INCLUDE_COLUMN	FREELISTS	FREELIST_GROUPS	PCT_FREE	LOGGING	BLEVEL	LEAF_BLOCKS	DISTINCT_KEYS	AVG_LEAF_BLOCKS_PER_KEY	AVG_DATA_BLOCKS_PER_KEY	CLUSTERING_FACTOR	STATUS	NUM_ROWS	SAMPLE_SIZE	LAST_ANALYZED	DEGREE	INSTANCES	PARTITIONED	TEMPORARY	GENERATED	SECONDARY	BUFFER_POOL	FLASH_CACHE	CELL_FLASH_CACHE	USER_STATS	DURATION	PCT_DIRECT_ACCESS	ITYP_OWNER	ITYP_NAME	PARAMETERS	GLOBAL_STATS	DOMIDX_STATUS	DOMIDX_OPSTATUS	FUNCIDX_STATUS	JOIN_INDEX	IOT_REDUNDANT_PKEY_ELIM	DROPPED	VISIBILITY	DOMIDX_MANAGEMENT	SEGMENT_CREATED	ORPHANED_ENTRIES	INDEXING	AUTO	CONSTRAINT_INDEX
XX_TEST_IDX_01	NORMAL	SQL_YTNJIDSIIMIUZSDTLJJTHWVLS	XX_TEST_STG	TABLE	NONUNIQUE	DISABLED	-	LIVESQL_USERS	2	255	-	-	-	-	-	-	-	-	-	10	YES	0	0	0	0	0	0	VALID	0	0	04-SEP-24	1	1	NO	N	N	N	DEFAULT	DEFAULT	DEFAULT	NO	-	-	-	-	-	YES	-	-	-	NO	NO	NO	VISIBLE	-	NO	NO	FULL	NO	NO
XX_TEST_IDX_02	NORMAL	SQL_YTNJIDSIIMIUZSDTLJJTHWVLS	XX_TEST_STG	TABLE	NONUNIQUE	DISABLED	-	LIVESQL_USERS	2	255	-	-	-	-	-	-	-	-	-	10	YES	0	0	0	0	0	0	VALID	0	0	04-SEP-24	1	1	NO	N	N	N	DEFAULT	DEFAULT	DEFAULT	NO	-	-	-	-	-	YES	-	-	-	NO	NO	NO	VISIBLE	-	NO	NO	FULL	NO	NO

OBJECT_NAME	SUBOBJECT_NAME	OBJECT_ID	DATA_OBJECT_ID	OBJECT_TYPE	CREATED	LAST_DDL_TIME	TIMESTAMP	STATUS	TEMPORARY	GENERATED	SECONDARY	NAMESPACE	EDITION_NAME	SHARING	EDITIONABLE	ORACLE_MAINTAINED	APPLICATION	DEFAULT_COLLATION	DUPLICATED	SHARDED	CREATED_APPID	CREATED_VSNID	MODIFIED_APPID	MODIFIED_VSNID
DBMS_XPLAN	-	234812162	-	SYNONYM	03-SEP-24	03-SEP-24	2024-09-03:16:10:21	VALID	N	N	N	1	-	NONE	Y	N	N	-	N	N	-	-	-	-
V$OPEN_CURSOR	-	234812161	-	SYNONYM	03-SEP-24	03-SEP-24	2024-09-03:16:10:21	VALID	N	N	N	1	-	NONE	Y	N	N	-	N	N	-	-	-	-
V$SESSION	-	234812133	-	SYNONYM	03-SEP-24	03-SEP-24	2024-09-03:16:10:21	VALID	N	N	N	1	-	NONE	Y	N	N	-	N	N	-	-	-	-
V$SQL	-	234812130	-	SYNONYM	03-SEP-24	03-SEP-24	2024-09-03:16:10:21	VALID	N	N	N	1	-	NONE	Y	N	N	-	N	N	-	-	-	-
V$SQLSTATS	-	234812132	-	SYNONYM	03-SEP-24	03-SEP-24	2024-09-03:16:10:21	VALID	N	N	N	1	-	NONE	Y	N	N	-	N	N	-	-	-	-
V$SQL_BIND_CAPTURE	-	234812160	-	SYNONYM	03-SEP-24	03-SEP-24	2024-09-03:16:10:21	VALID	N	N	N	1	-	NONE	Y	N	N	-	N	N	-	-	-	-
V$SQL_PLAN	-	234812131	-	SYNONYM	03-SEP-24	03-SEP-24	2024-09-03:16:10:21	VALID	N	N	N	1	-	NONE	Y	N	N	-	N	N	-	-	-	-
V$SQL_PLAN_STATISTICS_ALL	-	234812159	-	SYNONYM	03-SEP-24	03-SEP-24	2024-09-03:16:10:21	VALID	N	N	N	1	-	NONE	Y	N	N	-	N	N	-	-	-	-
XX_TEST_IDX_01	-	234849584	234849584	INDEX	04-SEP-24	04-SEP-24	2024-09-04:00:48:14	VALID	N	N	N	4	-	NONE	-	N	N	-	N	N	-	-	-	-
XX_TEST_IDX_02	-	234849624	234849624	INDEX	04-SEP-24	04-SEP-24	2024-09-04:00:48:35	VALID	N	N	N	4	-	NONE	-	N	N	-	N	N	-	-	-	-
XX_TEST_STG	-	234849498	234849498	TABLE	04-SEP-24	04-SEP-24	2024-09-04:00:47:03	VALID	N	N	N	1	-	NONE	-	N	N	USING_NLS_COMP	N	N	-	-	-	-

OWNER	OBJECT_NAME	SUBOBJECT_NAME	OBJECT_ID	DATA_OBJECT_ID	OBJECT_TYPE	CREATED	LAST_DDL_TIME	TIMESTAMP	STATUS	TEMPORARY	GENERATED	SECONDARY	NAMESPACE	EDITION_NAME	SHARING	EDITIONABLE	ORACLE_MAINTAINED	APPLICATION	DEFAULT_COLLATION	DUPLICATED	SHARDED	CREATED_APPID	CREATED_VSNID	MODIFIED_APPID	MODIFIED_VSNID
SYS	ORA$BASE	-	134	-	EDITION	16-FEB-18	16-FEB-18	2018-02-16:05:00:13	VALID	N	N	N	64	-	NONE	-	Y	N	-	N	N	-	-	-	-
SYS	DUAL	-	143	143	TABLE	16-FEB-18	28-MAY-24	2018-02-16:05:00:13	VALID	N	N	N	1	-	METADATA LINK	-	Y	N	USING_NLS_COMP	N	N	-	-	-	-
PUBLIC	DUAL	-	144	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:00:13	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	MAP_OBJECT	-	428	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:00:17	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	SYSTEM_PRIVILEGE_MAP	-	532	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:00:18	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	TABLE_PRIVILEGE_MAP	-	535	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:00:18	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
SYS	USER_PRIVILEGE_MAP	-	536	536	TABLE	16-FEB-18	16-FEB-18	2018-02-16:05:00:18	VALID	N	N	N	1	-	DATA LINK	-	Y	N	USING_NLS_COMP	N	N	-	-	-	-
SYS	I_USER_PRIVILEGE_MAP	-	537	537	INDEX	16-FEB-18	16-FEB-18	2018-02-16:05:00:18	VALID	N	N	N	4	-	NONE	-	Y	N	-	N	N	-	-	-	-
PUBLIC	USER_PRIVILEGE_MAP	-	538	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:00:18	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	STMT_AUDIT_OPTION_MAP	-	541	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:00:19	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
SYS	MODELGTTRAW$	-	1401	-	TABLE	16-FEB-18	08-MAR-24	2018-02-16:05:00:26	VALID	Y	N	N	1	-	METADATA LINK	-	Y	N	USING_NLS_COMP	N	N	-	-	-	-
SYS	STANDARD	-	1750	-	PACKAGE	16-FEB-18	16-JAN-19	2018-07-16:00:00:00	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	USING_NLS_COMP	N	N	-	-	-	-
SYS	DBMS_STANDARD	-	1752	-	PACKAGE	16-FEB-18	16-JAN-19	2018-02-16:05:01:31	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	USING_NLS_COMP	N	N	-	-	-	-
PUBLIC	DBMS_STANDARD	-	1753	-	SYNONYM	16-FEB-18	16-JAN-19	2018-02-16:05:01:31	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
SYS	UTL_RAW	-	1763	-	PACKAGE	16-FEB-18	14-DEC-22	2018-02-16:05:01:31	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	USING_NLS_COMP	N	N	-	-	-	-
PUBLIC	V$MAP_LIBRARY	-	1765	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:31	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$MAP_FILE	-	1767	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:31	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$MAP_FILE_EXTENT	-	1769	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:31	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$MAP_ELEMENT	-	1771	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:31	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$MAP_EXT_ELEMENT	-	1773	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:31	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$MAP_COMP_LIST	-	1775	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:31	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$MAP_SUBELEMENT	-	1777	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:31	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$MAP_FILE_IO_STACK	-	1779	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:31	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$SQL_REDIRECTION	-	1781	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:31	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$SQL_PLAN	-	1783	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:31	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$SQL_PLAN_STATISTICS	-	1785	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$SQL_PLAN_STATISTICS_ALL	-	1787	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$ADVISOR_CURRENT_SQLPLAN	-	1789	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$SQL_WORKAREA	-	1791	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$SQL_WORKAREA_ACTIVE	-	1793	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$SQL_WORKAREA_HISTOGRAM	-	1795	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$PGA_TARGET_ADVICE	-	1797	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$PGA_TARGET_ADVICE_HISTOGRAM	-	1799	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$PGASTAT	-	1801	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$SYS_OPTIMIZER_ENV	-	1803	-	SYNONYM	16-FEB-18	16-JAN-19	2019-01-16:03:54:01	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$SES_OPTIMIZER_ENV	-	1805	-	SYNONYM	16-FEB-18	16-JAN-19	2019-01-16:03:54:01	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$SQL_OPTIMIZER_ENV	-	1807	-	SYNONYM	16-FEB-18	16-JAN-19	2019-01-16:03:54:01	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$DLM_MISC	-	1809	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$DLM_LATCH	-	1811	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$DLM_CONVERT_LOCAL	-	1813	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$DLM_CONVERT_REMOTE	-	1815	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$DLM_ALL_LOCKS	-	1817	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$DLM_LOCKS	-	1819	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$DLM_RESS	-	1821	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$HVMASTER_INFO	-	1823	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$GCSHVMASTER_INFO	-	1825	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$GCSPFMASTER_INFO	-	1827	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	GV$DLM_TRAFFIC_CONTROLLER	-	1829	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	V$DLM_TRAFFIC_CONTROLLER	-	1831	-	SYNONYM	16-FEB-18	16-FEB-18	2018-02-16:05:01:32	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-
PUBLIC	GV$DYNAMIC_REMASTER_STATS	-	1833	-	SYNONYM	16-FEB-18	16-JAN-19	2019-01-16:03:54:01	VALID	N	N	N	1	-	METADATA LINK	N	Y	N	-	N	N	-	-	-	-