Here you go… Thank you for your help!
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:26.861
Select queue_table TABLE_NAME
FROM SYS.ALL_QUEUE_TABLES Q
WHERE Q.OWNER = :own
and queue_table = :OneObjectName
:own(VARCHAR[7],IN)=‘MYDBNAME’
:OneObjectName(VARCHAR[12],IN)=‘MYTABLENAME’
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:26.951
Select name
from SYS.ALL_SNAPSHOTS
where owner = :own
:own(VARCHAR[7],IN)=‘MYDBNAME’
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:27.000
Select owner, type_name, typecode FROM SYS.ALL_TYPES where owner is not null
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:28.146
select
TABLE_TYPE_OWNER, TABLE_TYPE, OBJECT_ID_TYPE, TABLE_NAME,
TABLESPACE_NAME, BUFFER_POOL, IOT_NAME, IOT_TYPE, MIN_EXTENTS,
NEXT_EXTENT, MAX_EXTENTS, INI_TRANS, MAX_TRANS, INITIAL_EXTENT,
PCT_INCREASE, FREELISTS, FREELIST_GROUPS, PCT_FREE, PCT_USED,
INSTANCES, CLUSTER_NAME, DEGREE, NUM_ROWS, AVG_ROW_LEN,
TEMPORARY, LOGGING, PARTITIONED, NESTED, ROW_MOVEMENT,
MONITORING, DURATION, DEPENDENCIES, COMPRESSION, COMPRESS_FOR,
‘NO’ READ_ONLY, CACHE
from ALL_OBJECT_TABLES t
where owner =:own
and ((iot_type is null) or (iot_type <> ‘IOT_MAPPING’))
and (( table_name = :OneObjectName ) or
(table_name like ‘SYS_IOT_OVER%’ and iot_name = :OneObjectName ))
union all
select
null, null, null, TABLE_NAME,
TABLESPACE_NAME, BUFFER_POOL, IOT_NAME, IOT_TYPE, MIN_EXTENTS,
NEXT_EXTENT, MAX_EXTENTS, INI_TRANS, MAX_TRANS, INITIAL_EXTENT,
PCT_INCREASE, FREELISTS, FREELIST_GROUPS, PCT_FREE, PCT_USED,
INSTANCES, CLUSTER_NAME, DEGREE, NUM_ROWS, AVG_ROW_LEN,
TEMPORARY, LOGGING, PARTITIONED, NESTED, ROW_MOVEMENT,
MONITORING, DURATION, DEPENDENCIES, COMPRESSION, COMPRESS_FOR,
READ_ONLY, CACHE
from ALL_TABLES t
where owner =:own
and ((iot_type is null) or (iot_type <> ‘IOT_MAPPING’))
and (( table_name = :OneObjectName ) or
(table_name like ‘SYS_IOT_OVER%’ and iot_name = :OneObjectName ))
order by table_name
:own(VARCHAR[7],IN)=‘MYDBNAME’
:OneObjectName(VARCHAR[12],IN)=‘MYTABLENAME’
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:28.893
Select table_name, flashback_archive_name
from sys.dba_flashback_archive_tables
where owner_name =:own
and TABLE_NAME = :OneObjectName
:own(VARCHAR[7],IN)=‘MYDBNAME’
:OneObjectName(VARCHAR[12],IN)=‘MYTABLENAME’
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:28.921
Select table_name, column_name, data_type, data_type_mod, data_type_owner,
decode(data_type, ‘CHAR’, char_length,
‘VARCHAR’, char_length,
‘VARCHAR2’, char_length,
‘NCHAR’, char_length,
‘NVARCHAR’, char_length,
‘NVARCHAR2’, char_length,
data_length) data_length,
data_precision, data_scale, nullable, char_used
, virtual_column
FROM SYS.ALL_TAB_COLS c
WHERE OWNER = :own
AND HIDDEN_COLUMN = ‘NO’
and TABLE_NAME = :OneObjectName
order by table_name, column_id
:own(VARCHAR[7],IN)=‘MYDBNAME’
:OneObjectName(VARCHAR[12],IN)=‘MYTABLENAME’
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:29.027
Select TABLE_NAME, COLUMN_NAME, DEFAULT_LENGTH, DATA_DEFAULT
FROM SYS.ALL_TAB_COLUMNS C WHERE OWNER = :own
And default_length is not null
:own(VARCHAR[7],IN)=‘MYDBNAME’
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:29.501
SELECT table_name, column_name,
DECODE(encryption_alg, ‘3 Key Triple DES 168 bits key’, ‘3DES168’,
‘AES 128 bits key’, ‘AES128’,
‘AES 192 bits key’, ‘AES192’,
‘AES 256 bits key’, ‘AES256’,
‘Internal Error’) encryption_alg,
salt
from sys.ALL_ENCRYPTED_COLUMNS
where owner =:own
and TABLE_NAME = :OneObjectName
:own(VARCHAR[7],IN)=‘MYDBNAME’
:OneObjectName(VARCHAR[12],IN)=‘MYTABLENAME’
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:29.522
Select * from SYS.ALL_REFS where owner = :own
and TABLE_NAME = :OneObjectName
:own(VARCHAR[7],IN)=‘MYDBNAME’
:OneObjectName(VARCHAR[12],IN)=‘MYTABLENAME’
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:29.578
Select l.TABLE_NAME, l.LOG_GROUP_NAME, c.COLUMN_NAME, l.ALWAYS
, c.logging_property, l.log_group_type, l.generated
from SYS.ALL_LOG_GROUPS l, SYS.ALL_LOG_GROUP_COLUMNS c
where l.OWNER = c.OWNER (+)
and l.owner = :own
and l.LOG_GROUP_NAME = c.LOG_GROUP_NAME (+)
and l.TABLE_NAME = c.TABLE_NAME (+)
and l.table_name = :OneObjectName
order by l.TABLE_NAME, l.LOG_GROUP_NAME, c.POSITION
:own(VARCHAR[7],IN)=‘MYDBNAME’
:OneObjectName(VARCHAR[12],IN)=‘MYTABLENAME’
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:29.838
Select * from SYS.ALL_INDEXES i where table_owner = :own
and index_type <> ‘LOB’
and table_name = :OneObjectName
order by 2
:own(VARCHAR[7],IN)=‘MYDBNAME’
:OneObjectName(VARCHAR[12],IN)=‘MYTABLENAME’
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:29.979
SELECT ‘x’
FROM sys.obj$, sys.ind$, sys.USER$, sys.object_usage
WHERE 0=1
Error: ORA-00942: table or view does not exist
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:30.016
Select t.*
from SYS.ALL_TRIGGERS t
where t.table_owner = :own
and t.table_name = :OneObjectName
:own(VARCHAR[7],IN)=‘MYDBNAME’
:OneObjectName(VARCHAR[12],IN)=‘MYTABLENAME’
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:30.196
Select table_name, segment_name, column_name,
index_name, chunk, pctversion, cache, logging, in_row
, freepools, retention
, tablespace_name
, encrypt, compression, deduplication, securefile
from sys.ALL_LOBS
where owner = :own
and table_name = :OneObjectName
:own(VARCHAR[7],IN)=‘MYDBNAME’
:OneObjectName(VARCHAR[12],IN)=‘MYTABLENAME’
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:30.389
SELECT value
FROM v$parameter
WHERE LOWER(name) = ‘undo_management’
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:30.416
SELECT value
FROM v$parameter
WHERE LOWER(name) = ‘undo_management’
Error: ORA-00942: table or view does not exist
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:30.488
Session: MYUSERNAME@MYDBINSTANCE
Timestamp: 09:26:30.504
Error: ORA-00900: invalid SQL statement
