- https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:8806017524595
- www.aaoug.org/pres/Index%20Compression.ppt
- https://richardfoote.wordpress.com/2008/02/17/index-compression-part-i-low/
- https://richardfoote.files.wordpress.com/2008/02/index-compression-part-i.pdf
Sunday, April 3, 2016
Does index compression affect performance in oracle ?
Monday, October 19, 2015
Using the dbms_shared_pool.markhot procedure to minimize contention on most pinned objects in the library
Sometimes when you have too much contention on the library, you should check the objects that are most pinned in the library cache and mark it as hot using dbms_shared_pool.markhot() procedure that creates multiple copies of the same object in the shared in order to minimize contention on theses objects.
the following query will help get these objects :
SELECT *
FROM ( SELECT CASE
WHEN (kglhdadr = kglhdpar) THEN 'Parent'
ELSE 'Child ' || kglobt09
END
cursor,
kglhdadr ADDRESS,
SUBSTR (kglnaobj, 1, 20) NAME,
kglnahsh HASH_VALUE,
kglobtyd TYPE,
kglobt23 LOCKED_TOTAL,
kglobt24 PINNED_TOTAL,
kglhdexc EXECUTIONS,
kglhdnsp NAMESPACE
FROM x$kglob -- where kglobtyd != 'CURSOR'
ORDER BY kglobt24 DESC)
WHERE ROWNUM <= 30;
Source :
https://andreynikolaev.wordpress.com/2011/05/01/divide-and-conquer-the-true-mutex-contention/
the following query will help get these objects :
SELECT *
FROM ( SELECT CASE
WHEN (kglhdadr = kglhdpar) THEN 'Parent'
ELSE 'Child ' || kglobt09
END
cursor,
kglhdadr ADDRESS,
SUBSTR (kglnaobj, 1, 20) NAME,
kglnahsh HASH_VALUE,
kglobtyd TYPE,
kglobt23 LOCKED_TOTAL,
kglobt24 PINNED_TOTAL,
kglhdexc EXECUTIONS,
kglhdnsp NAMESPACE
FROM x$kglob -- where kglobtyd != 'CURSOR'
ORDER BY kglobt24 DESC)
WHERE ROWNUM <= 30;
Source :
https://andreynikolaev.wordpress.com/2011/05/01/divide-and-conquer-the-true-mutex-contention/
Friday, October 16, 2015
combine flashback logs and archived logs to flashback a database
Sometimes i want to flashback our standby database to replay some applications that are performing not well in production, but sometimes i don't have enough flashback database log data to do FLASHBACK and oracle raises an "RMAN-06796". In this case i just have to determine my oldest flashback log and if have archived log older than the oldest flashback log i can register these archives using rman and flashback the database until the sequence corresponding to my criterias.
You can use this command to register older archived log in the catalog and this command to flashback the database.
You can use this command to register older archived log in the catalog and this command to flashback the database.
Wednesday, October 14, 2015
Don't worry about UnOptimized reads in an oracle 11g AWR report
Every time you read an 11g AWR report you see a section called
SQL ordered by Physical Reads (UnOptimized) , an UnOptimized read in Oracle 11g is a read that is not found in the Database Smart Flash Cache. On Exadata an UnOptimized read is not found in the Database Smart Flash Cache or in the Exadata Cell Smart Flash Cache.
So don't worry if you see too much UnOptimized Read Reqs
Sources :
http://www.perftuning.com/unoptimized-reads-oracle-database-11gr2/
SQL ordered by Physical Reads (UnOptimized) , an UnOptimized read in Oracle 11g is a read that is not found in the Database Smart Flash Cache. On Exadata an UnOptimized read is not found in the Database Smart Flash Cache or in the Exadata Cell Smart Flash Cache.
So don't worry if you see too much UnOptimized Read Reqs
Sources :
http://www.perftuning.com/unoptimized-reads-oracle-database-11gr2/
Should i enable automatic SGA tuning ?
Automatic SGA tuning let oracle decide when to move memory between db cache and other pools, but it's possible that sometimes when oracle tries to resize a pool and don't find enough free chunks in other pools the database appears to hang.
This query help me to determine which component oracle could not shrink or grow.
If you get too many ORA-04031 errors with ASMM enabled, i recommend you to turn it off first by setting sga_target = 0.
You should set a lower limit for each pool, so that oracle will not try to shrink it below the limit.
Sources :
The following query help me to monitor the resize operations :
select component,oper_type,status,count(*) from (select
component,
oper_type,
oper_mode,
parameter,
initial_size,
target_size,
final_size,
status,
to_char(start_time,'dd-mon hh24:mi:ss') start_time,
to_char(end_time,'dd-mon hh24:mi:ss') end_time
from
v$sga_resize_ops) group by component,oper_type,status;
This query help me to determine which component oracle could not shrink or grow.
If you get too many ORA-04031 errors with ASMM enabled, i recommend you to turn it off first by setting sga_target = 0.
You should set a lower limit for each pool, so that oracle will not try to shrink it below the limit.
Sources :
- https://jonathanlewis.wordpress.com/2006/12/04/resizing-the-sga/
- https://jonathanlewis.wordpress.com/2007/04/16/sga-resizing/
- http://www.oraclemagician.com/white_papers/SGA_resizing.pdf
Thursday, October 1, 2015
Oracle Goldengate discard file reader and formatter
I use this wonderful PL SQL package by Luke Davies to read goldengate discard files and better diagnose replicat problems.
Monday, September 14, 2015
execute to parse ratio explained by TOM KYTE
If the number of parse calls is near the number of execute calls, then this ratio drifts towards zero (as yours is). As the number of execute calls increases (while holding parse calls constant), this number drifts towards 100%. That means you have parsed a statement ONCE and executed it MANY TIMES (that is good, that is best) .
Source : https://asktom.oracle.com/pls/asktom/fp=100:11:0::::P11_QUESTION_ID:1594740500346667363
Source : https://asktom.oracle.com/pls/asktom/fp=100:11:0::::P11_QUESTION_ID:1594740500346667363
Parse CPU to Parse Elapsd % : which value is good ?
Low Value for this ratio is an indicator of latching problem. Investigate the Latch Sections in AWR and Statspack report for contention on library cache and shared pool latches.
Ideally Parse Elapsed must be equal to Parse CPU, i.e., only CPU time is used for parsing. In that case the ratio is 100%. If wait time is more then the ratio will be less.
Source : https://blogs.oracle.com/myoraclediary/entry/what_is_parse_cpu_to
Saturday, April 11, 2015
pl sql procedure to reclaim space in a datafile
This procedure can quickly help to reclaim space above the HWM in a datafile
CREATE OR REPLACE PROCEDURE reclaim_datafile_space (fileid NUMBER)
IS
taille NUMBER;
block_size INTEGER;
BEGIN
SELECT VALUE
INTO block_size
FROM V$PARAMETER
WHERE NAME = 'db_block_size';
SELECT CEIL ( (highblock * block_size + block_size) / 1024)
INTO taille
FROM ( SELECT file_id, MAX (block_id + blocks) highblock
FROM dba_extents
WHERE file_id = fileid
GROUP BY file_id);
EXECUTE IMMEDIATE
'alter database datafile ' || fileid || ' resize ' || taille || 'K';
END;
/
It is based on Tanel Poder script trim_database
CREATE OR REPLACE PROCEDURE reclaim_datafile_space (fileid NUMBER)
IS
taille NUMBER;
block_size INTEGER;
BEGIN
SELECT VALUE
INTO block_size
FROM V$PARAMETER
WHERE NAME = 'db_block_size';
SELECT CEIL ( (highblock * block_size + block_size) / 1024)
INTO taille
FROM ( SELECT file_id, MAX (block_id + blocks) highblock
FROM dba_extents
WHERE file_id = fileid
GROUP BY file_id);
EXECUTE IMMEDIATE
'alter database datafile ' || fileid || ' resize ' || taille || 'K';
END;
/
It is based on Tanel Poder script trim_database
Wednesday, April 8, 2015
Index Clustering Factor explained by TOM KYTE
http://www.oracle.com/technetwork/issue-archive/2012/12-sep/o52asktom-1735913.html
Monday, April 6, 2015
Which segments are above the HWM in a tablespace ?
https://jonathanlewis.wordpress.com/tablespace-hwm/
Sunday, March 29, 2015
Friday, March 27, 2015
oracle wait events explained by experts : asynch descriptor resize
| Tanel Poder |
| The “direct path loader” (KCBL) module is used for performing direct path IO in Oracle, such as direct path segment scans and reading/writing spilled over workareas in temporary tablespace. Direct path IO is used whenever you see “direct path read/write*” wait events reported in your session. This means that IOs aren’t done from/to buffer cache, but from/to PGA directly, bypassing the buffer cache. This KCBL module tries to dynamically scale up the number of asynch IO descriptors (AIO descriptors are the OS kernel structures, which keep track of asynch IO requests) to match the number of direct path IO slots a process uses. In other words, if the PGA workarea and/or spilled-over hash area in temp tablespace gets larger, Oracle also scales up the number of direct IO slots. Direct IO slots are PGA memory structures helping to do direct IO between files and PGA. In order to be able to perform this direct IO asynchronously, Oracle also dynamically scales up the number of OS asynch IO descriptors, one for each slot (up to 4096 descriptors per process). When Oracle doesn’t need the direct IO slots anymore (when the direct path table scan has ended or a workarea/tempseg gets cancelled) then it scales down the number of direct IO slots and asynch IO descriptors. Scaling asynch IO descriptors up/down requires issuing syscalls to OS (as the AIO descriptors are OS kernel structures). I guess this is supposed to be an optimization, to avoid running out of OS AIO descriptors, by releasing them when not they’re not needed, but as that Metalink note mentioned, the resize apparently sucks on Linux. Perhaps that’s why other ports also suffer and have seen the same wait event. The “asynch descriptor resize” event itself is really an IO wait event (recorded in the wait class Other though), waiting for reaping outstanding IOs. Once this wait is over, then the OS call to change the amount of asynch IO descriptors (allocated to that process) is made. There’s no wait event recorded for the actual “resize” OS call as it shouldn’t block. So, the more direct IO you do, especially when sorting/hashing to temp with frequent workarea closing/opening, the more of this event you’ll see (and it’s probably the same for regular tablespace direct path IO too). This problem wouldn’t be noticeable if Oracle kept async io descriptors cached and wouldn’t constantly allocated/free them. Of course then you may end up running out of aio descriptors in the whole server easier. Also I don’t know whether there would be some OS issues with reusing cached aio descriptors, perhaps there is a good reason why such caching isn’t done. Nevertheless, what’s causing this wait event is too frequent aio descriptor resize due to changes in direct IO slot count (due to changes in PGA workarea/temp segment and perhaps when doing frequent direct path scans through lots of tables/partitions too). So, the obvious question here is what to do about this wait event? Well, first you should check how big part of your total response time this event takes at all?
|
| Source : http://blog.tanelpoder.com/2010/11/23/asynch-descriptor-resize-wait-event-in-oracle/ |
Friday, February 13, 2015
Which objects are pinned most of the time in the library cache
If you want to reduce the "library cache : mutex X" concurrency event you have to find which objects are pinned most of the time in the library cache with this query
SELECT *
FROM ( SELECT CASE
WHEN (kglhdadr = kglhdpar) THEN 'Parent'
ELSE 'Child ' || kglobt09
END
cursor,
kglhdadr ADDRESS,
SUBSTR (kglnaobj, 1, 20) NAME,
kglnahsh HASH_VALUE,
kglobtyd TYPE,
kglobt23 LOCKED_TOTAL,
kglobt24 PINNED_TOTAL,
kglhdexc EXECUTIONS,
kglhdnsp NAMESPACE
FROM x$kglob -- where kglobtyd != 'CURSOR'
ORDER BY kglobt24 DESC)
WHERE ROWNUM <= 20;
Then you can use the dbms_shared_pool.markhot() to mark them as hot.
References
SELECT *
FROM ( SELECT CASE
WHEN (kglhdadr = kglhdpar) THEN 'Parent'
ELSE 'Child ' || kglobt09
END
cursor,
kglhdadr ADDRESS,
SUBSTR (kglnaobj, 1, 20) NAME,
kglnahsh HASH_VALUE,
kglobtyd TYPE,
kglobt23 LOCKED_TOTAL,
kglobt24 PINNED_TOTAL,
kglhdexc EXECUTIONS,
kglhdnsp NAMESPACE
FROM x$kglob -- where kglobtyd != 'CURSOR'
ORDER BY kglobt24 DESC)
WHERE ROWNUM <= 20;
Then you can use the dbms_shared_pool.markhot() to mark them as hot.
References
- https://juliandontcheff.wordpress.com/2013/02/12/reducing-library-cache-mutex-x-concurrency-with-dbms_shared_pool-markhot/
- https://andreynikolaev.wordpress.com/2011/05/01/divide-and-conquer-the-true-mutex-contention/
- http://omarfaruq.blogspot.fi/2012/07/concurrency-waits-library-cache-mutex-x.html
- https://jagjeet.wordpress.com/2011/12/12/library-cache-mutex-x/
Monday, January 19, 2015
PL SQL procedure to save a file from a Filesystem to BLOB column
DECLARE
v_src_loc BFILE := BFILENAME ('ORACLE_DIR', 'FILE_NAME');
v_amount INTEGER;
v_b BLOB;
BEGIN
DBMS_LOB.OPEN (v_src_loc, DBMS_LOB.LOB_READONLY);
v_amount := DBMS_LOB.GETLENGTH (v_src_loc);
UPDATE BLOB_TABLE
SET BLOB_COLUMN = EMPTY_BLOB ()
RETURNING BLOB_COLUMN
INTO v_b;
DBMS_LOB.LOADFROMFILE (v_b, v_src_loc, v_amount);
DBMS_LOB.CLOSE (v_src_loc);
commit;
END;
/
v_src_loc BFILE := BFILENAME ('ORACLE_DIR', 'FILE_NAME');
v_amount INTEGER;
v_b BLOB;
BEGIN
DBMS_LOB.OPEN (v_src_loc, DBMS_LOB.LOB_READONLY);
v_amount := DBMS_LOB.GETLENGTH (v_src_loc);
UPDATE BLOB_TABLE
SET BLOB_COLUMN = EMPTY_BLOB ()
RETURNING BLOB_COLUMN
INTO v_b;
DBMS_LOB.LOADFROMFILE (v_b, v_src_loc, v_amount);
DBMS_LOB.CLOSE (v_src_loc);
commit;
END;
/
PL SQL procedure to extract a BLOB to a Filesystem
This PL SQL procedure allows you to extract a BLOB column to FS
DECLARE
l_file UTL_FILE.FILE_TYPE;
l_buffer RAW (32767);
l_amount BINARY_INTEGER := 32767;
l_pos NUMBER := 1;
l_blob BLOB;
l_blob_len NUMBER;
BEGIN
SELECT YOUR_BLOB_COLUMN
INTO l_blob
FROM YOU_BLOB_TABLE;
l_blob_len := DBMS_LOB.getlength (l_blob);
-- Open the destination file.
l_file :=
UTL_FILE.fopen ('ORACLE_DIR',
'FILE_NAME',
'wb',
32767);
WHILE l_pos < l_blob_len
LOOP
DBMS_LOB.read (l_blob,
l_amount,
l_pos,
l_buffer);
UTL_FILE.put_raw (l_file, l_buffer, TRUE);
l_pos := l_pos + l_amount;
END LOOP;
-- Close the file.
UTL_FILE.fclose (l_file);
END;
DECLARE
l_file UTL_FILE.FILE_TYPE;
l_buffer RAW (32767);
l_amount BINARY_INTEGER := 32767;
l_pos NUMBER := 1;
l_blob BLOB;
l_blob_len NUMBER;
BEGIN
SELECT YOUR_BLOB_COLUMN
INTO l_blob
FROM YOU_BLOB_TABLE;
l_blob_len := DBMS_LOB.getlength (l_blob);
-- Open the destination file.
l_file :=
UTL_FILE.fopen ('ORACLE_DIR',
'FILE_NAME',
'wb',
32767);
WHILE l_pos < l_blob_len
LOOP
DBMS_LOB.read (l_blob,
l_amount,
l_pos,
l_buffer);
UTL_FILE.put_raw (l_file, l_buffer, TRUE);
l_pos := l_pos + l_amount;
END LOOP;
-- Close the file.
UTL_FILE.fclose (l_file);
END;
Sunday, November 9, 2014
Oracle instance properties script (ORACLE_HOME, STATE, VERSION ...)
This script will give some important properties of your instance
SELECT status,
startup_time,
instance_name,
version,
host_name,
(SELECT SUBSTR (file_spec, 1, INSTR (file_spec, 'lib') - 2)
FROM dba_libraries
WHERE library_name = 'DBMS_SUMADV_LIB')
ORACLE_HOME
FROM v$instance;
SELECT status,
startup_time,
instance_name,
version,
host_name,
(SELECT SUBSTR (file_spec, 1, INSTR (file_spec, 'lib') - 2)
FROM dba_libraries
WHERE library_name = 'DBMS_SUMADV_LIB')
ORACLE_HOME
FROM v$instance;
Monday, September 15, 2014
PL SQL function to get the ADR HOME PATH
CREATE OR REPLACE FUNCTION getAdrHome
RETURN VARCHAR
IS
base VARCHAR (10);
home VARCHAR (255);
BEGIN
SELECT VALUE
INTO base
FROM v$diag_info
WHERE name = 'ADR Base';
SELECT SUBSTR (VALUE, LENGTH (base) + 2)
INTO home
FROM v$diag_info
WHERE name = 'ADR Home';
RETURN home;
END;
/
To use this function
select getAdrHome from dual;
RETURN VARCHAR
IS
base VARCHAR (10);
home VARCHAR (255);
BEGIN
SELECT VALUE
INTO base
FROM v$diag_info
WHERE name = 'ADR Base';
SELECT SUBSTR (VALUE, LENGTH (base) + 2)
INTO home
FROM v$diag_info
WHERE name = 'ADR Home';
RETURN home;
END;
/
To use this function
select getAdrHome from dual;
Friday, August 8, 2014
oracle streams for auditing/logging using custom apply handler
Let say you have a table in your database and you want to log any dml on this table (source_table).
We have already created our streams administrator stradmin, now we connect with the owner of the source_table to grant him necessary privileges.
conn owner/pass
grant all on owner.source_table to stradmin;
we create a second table (source_table_audit) the same as the source table to insert all changes made in the source table, we create this table with 3 extra columns
We grant all necessary privileges to the streams administrator on this table
grant all on owner.source_table_audit to stradmin;
We create a queue for this purpose
BEGIN
DBMS_STREAMS_ADM.SET_UP_QUEUE (
queue_table => 'strmadmin.streams_queue_table',
queue_name => 'strmadmin.streams_queue');
END;
/
We create a capture rule to include only dml on our source_table
BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES (
table_name => 'hr.employees',
streams_type => 'capture',
streams_name => 'capture_emp',
queue_name => 'strmadmin.streams_queue',
include_dml => TRUE,
include_ddl => FALSE,
inclusion_rule => TRUE);
END;
/
We add an extra attribute to capture the user who made the change
BEGIN
DBMS_CAPTURE_ADM.INCLUDE_EXTRA_ATTRIBUTE (
capture_name => 'capture_emp',
attribute_name => 'username',
include => TRUE);
END;
/
CREATE OR REPLACE PROCEDURE dml_handler (in_any IN ANYDATA)
IS
lcr SYS.LCR$_ROW_RECORD;
rc PLS_INTEGER;
command VARCHAR2 (30);
old_values SYS.LCR$_ROW_LIST;
BEGIN
-- Access the LCR
rc := in_any.GETOBJECT (lcr);
-- Get the object command
typecommand := lcr.GET_COMMAND_TYPE ();
-- Set the command_type in the row LCR to INSERT
lcr.SET_COMMAND_TYPE ('INSERT');
-- Set the object_name in the row LCR
lcr.SET_OBJECT_NAME ('SOURCE_TABLE_AUDIT');
-- Set the new values to the old values for update and delete
IF command IN ('DELETE', 'UPDATE')
THEN
-- Get the old values in the row LCR
old_values := lcr.GET_VALUES ('old');
-- Set the old values in the row LCR to the new values in the row LCR
lcr.SET_VALUES ('new', old_values);
-- Set the old values in the row LCR to NULL
lcr.SET_VALUES ('old', NULL);
END IF;
-- Add a SYSDATE for update_date
lcr.ADD_COLUMN ('new', 'UPDATE_DATE', ANYDATA.ConvertDate (SYSDATE));
-- Add a user column
lcr.ADD_COLUMN ('new', 'USERNAME', lcr.GET_EXTRA_ATTRIBUTE ('USERNAME'));
-- Add an action column
lcr.ADD_COLUMN ('new', 'ACTION', ANYDATA.ConvertVarChar2 (command));
-- Make the changes
lcr.EXECUTE (TRUE);
COMMIT;
END;
/
Now we can set the apply dml handler for this table
BEGIN
DBMS_APPLY_ADM.SET_DML_HANDLER (
object_name => 'owner.source_table',
object_type => 'TABLE',
operation_name => 'INSERT',
error_handler => FALSE,
user_procedure => 'strmadmin.dml_handler',
apply_database_link => NULL,
apply_name => NULL);
END;
/
BEGIN
DBMS_APPLY_ADM.SET_DML_HANDLER (
object_name => 'owner.source_table',
object_type => 'TABLE',
operation_name => 'UPDATE',
error_handler => FALSE,
user_procedure => 'strmadmin.dml_handler',
apply_database_link => NULL,
apply_name => NULL);
END;
/
BEGIN
DBMS_APPLY_ADM.SET_DML_HANDLER (
object_name => 'owner.source_table',
object_type => 'TABLE',
operation_name => 'DELETE',
error_handler => FALSE,
user_procedure => 'strmadmin.dml_handler',
apply_database_link => NULL,
apply_name => NULL);
END;
/
We have already created our streams administrator stradmin, now we connect with the owner of the source_table to grant him necessary privileges.
conn owner/pass
grant all on owner.source_table to stradmin;
we create a second table (source_table_audit) the same as the source table to insert all changes made in the source table, we create this table with 3 extra columns
- update_date =====> date of the dml
- username =====> the user who made the modification
- action =====> dml (delete, update or insert)
We grant all necessary privileges to the streams administrator on this table
grant all on owner.source_table_audit to stradmin;
We create a queue for this purpose
BEGIN
DBMS_STREAMS_ADM.SET_UP_QUEUE (
queue_table => 'strmadmin.streams_queue_table',
queue_name => 'strmadmin.streams_queue');
END;
/
We create a capture rule to include only dml on our source_table
BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES (
table_name => 'hr.employees',
streams_type => 'capture',
streams_name => 'capture_emp',
queue_name => 'strmadmin.streams_queue',
include_dml => TRUE,
include_ddl => FALSE,
inclusion_rule => TRUE);
END;
/
We add an extra attribute to capture the user who made the change
BEGIN
DBMS_CAPTURE_ADM.INCLUDE_EXTRA_ATTRIBUTE (
capture_name => 'capture_emp',
attribute_name => 'username',
include => TRUE);
END;
/
CREATE OR REPLACE PROCEDURE dml_handler (in_any IN ANYDATA)
IS
lcr SYS.LCR$_ROW_RECORD;
rc PLS_INTEGER;
command VARCHAR2 (30);
old_values SYS.LCR$_ROW_LIST;
BEGIN
-- Access the LCR
rc := in_any.GETOBJECT (lcr);
-- Get the object command
typecommand := lcr.GET_COMMAND_TYPE ();
-- Set the command_type in the row LCR to INSERT
lcr.SET_COMMAND_TYPE ('INSERT');
-- Set the object_name in the row LCR
lcr.SET_OBJECT_NAME ('SOURCE_TABLE_AUDIT');
-- Set the new values to the old values for update and delete
IF command IN ('DELETE', 'UPDATE')
THEN
-- Get the old values in the row LCR
old_values := lcr.GET_VALUES ('old');
-- Set the old values in the row LCR to the new values in the row LCR
lcr.SET_VALUES ('new', old_values);
-- Set the old values in the row LCR to NULL
lcr.SET_VALUES ('old', NULL);
END IF;
-- Add a SYSDATE for update_date
lcr.ADD_COLUMN ('new', 'UPDATE_DATE', ANYDATA.ConvertDate (SYSDATE));
-- Add a user column
lcr.ADD_COLUMN ('new', 'USERNAME', lcr.GET_EXTRA_ATTRIBUTE ('USERNAME'));
-- Add an action column
lcr.ADD_COLUMN ('new', 'ACTION', ANYDATA.ConvertVarChar2 (command));
-- Make the changes
lcr.EXECUTE (TRUE);
COMMIT;
END;
/
Now we can set the apply dml handler for this table
BEGIN
DBMS_APPLY_ADM.SET_DML_HANDLER (
object_name => 'owner.source_table',
object_type => 'TABLE',
operation_name => 'INSERT',
error_handler => FALSE,
user_procedure => 'strmadmin.dml_handler',
apply_database_link => NULL,
apply_name => NULL);
END;
/
BEGIN
DBMS_APPLY_ADM.SET_DML_HANDLER (
object_name => 'owner.source_table',
object_type => 'TABLE',
operation_name => 'UPDATE',
error_handler => FALSE,
user_procedure => 'strmadmin.dml_handler',
apply_database_link => NULL,
apply_name => NULL);
END;
/
BEGIN
DBMS_APPLY_ADM.SET_DML_HANDLER (
object_name => 'owner.source_table',
object_type => 'TABLE',
operation_name => 'DELETE',
error_handler => FALSE,
user_procedure => 'strmadmin.dml_handler',
apply_database_link => NULL,
apply_name => NULL);
END;
/
Datapump import filters
| Type | Comment |
| ALTER_FUNCTION | Recompile functions |
| ALTER_PACKAGE_SPEC | Recompile package specifications |
| ALTER_PROCEDURE | Recompile procedures |
| ASSOCIATION | Statistics type associations |
| AUDIT | Audits of SQL statements |
| AUDIT_DEFAULT | Procedural system privilege audits |
| AUDIT_OBJ | Object audits on the selected tables |
| AUDIT_OBJ | |
| BITMAP_INDEX | |
| BITMAP_INDEX/INDEX | |
| BITMAP_INDEX/INDEX_STATISTICS | |
| CLUSTER | |
| CLUSTER | Clusters and their indexes |
| CLUSTER/CLUSTER | |
| CLUSTER/INDEX | |
| COMMENT | Table and column comments on the selected tables |
| COMMENT | |
| COMPILE_PACKAGE | |
| COMPILE_PACKAGE/PACKAGE_SPEC | |
| COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC | Recompile package specifications |
| CONSTRAINT | |
| CONSTRAINT | Constraints (including referential constraints) |
| CONSTRAINT/CONSTRAINT | |
| CONSTRAINT/REF_CONSTRAINT | Referential constraints |
| CONTEXT | Application contexts |
| CROSS_SCHEMA | |
| CROSS_SCHEMA/OBJECT_GRANT | |
| DATABASE_EXPORT/AUDIT | Audits of SQL statements |
| DATABASE_EXPORT/AUDIT_DEFAULT | Procedural system privilege audits |
| DATABASE_EXPORT/CONTEXT | Application contexts |
| DATABASE_EXPORT/DIRECTORY | |
| DATABASE_EXPORT/DIRECTORY/AUDIT_OBJ | |
| DATABASE_EXPORT/DIRECTORY/DIRECTORY | Directories and their dependent grants and audits |
| DATABASE_EXPORT/DIRECTORY/GRANT | |
| DATABASE_EXPORT/DIRECTORY/GRANT/CROSS_SCHEMA | |
| DATABASE_EXPORT/DIRECTORY/GRANT/CROSS_SCHEMA/OBJEC | |
| DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT | |
| DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT | |
| DATABASE_EXPORT/DIRECTORY/GRANT/WITH_GRANT_OPTION | |
| DATABASE_EXPORT/DIRECTORY/GRANT/WITH_GRANT_OPTION/ | |
| DATABASE_EXPORT/DVPS_IMPORT_STAGING_REALM | Database Vault Import Staging Realm definitions |
| DATABASE_EXPORT/DVPS_POLICY | Database Vault security policies |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROU | Database Vault Command Rule-based security policy definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROU | Database Vault Command Rule definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROU | Database Vault Role definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROU | Database Vault Rule definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROU | Database Vault Rule Set definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_COMMAND_RULE_GROU | Database Vault Rules in a Rule Set definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_DROP_IMPORT_STAGI | Delete the Database Vault Import Staging Realm definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP | Database Vault Factor definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS | Database Vault Factor definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS | Database Vault Factor Link definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS | Database Vault Factor Type definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS | Database Vault Identity definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS | Database Vault Identity Map definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_REALM_GROUP | Database Vault Realm-based security policy definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_REALM_GROUP/DVPS_ | Database Vault Realm definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_REALM_GROUP/DVPS_ | Database Vault Realm Authorization definitions |
| DATABASE_EXPORT/DVPS_POLICY/DVPS_REALM_GROUP/DVPS_ | Database Vault Realm Membership definitions |
| DATABASE_EXPORT/EARLY_OPTIONS | |
| DATABASE_EXPORT/EARLY_OPTIONS/OPTION_OBJNUM | |
| DATABASE_EXPORT/EARLY_OPTIONS/OPTION_PACKAGE | |
| DATABASE_EXPORT/EARLY_OPTIONS/OPTION_PACKAGE/OPTIO | |
| DATABASE_EXPORT/EARLY_OPTIONS/OPTION_PACKAGE/PACKA | |
| DATABASE_EXPORT/EARLY_OPTIONS/OPTION_PACKAGE/PACKA | |
| DATABASE_EXPORT/EARLY_OPTIONS/OPTION_TYPE | |
| DATABASE_EXPORT/EARLY_OPTIONS/OPTION_TYPE/OPTION_O | |
| DATABASE_EXPORT/EARLY_OPTIONS/OPTION_TYPE/SORT_TYP | |
| DATABASE_EXPORT/EARLY_OPTIONS/OPTION_TYPE/TABTYPE_ | |
| DATABASE_EXPORT/EARLY_OPTIONS/OPTION_TYPE/TYPE_BOD | Type bodies |
| DATABASE_EXPORT/EARLY_OPTIONS/OPTION_TYPE/TYPE_SPE | |
| DATABASE_EXPORT/EARLY_OPTIONS/POST_DATA_TABLE | |
| DATABASE_EXPORT/EARLY_OPTIONS/PROCEDURE | |
| DATABASE_EXPORT/EARLY_OPTIONS/TABLE | |
| DATABASE_EXPORT/EARLY_OPTIONS/TABLE_DATA | |
| DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES | |
| DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABL | |
| DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABL | |
| DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/VAT_ | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/AUDIT_OBJ | Object audits on the selected tables |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/COMMENT | Table and column comments on the selected tables |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/CONSTRAINT | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/FGA_POLICY | Fine-grained auditing policies |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/FUNCTIONAL_ | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/FUNCTIONAL_ | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/FUNCTIONAL_ | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/GRANT | Object grants on the selected tables |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/GRANT/CROSS | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/GRANT/CROSS | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/GRANT/OWNER | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/GRANT/OWNER | Object grants on the selected tables |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/GRANT/WITH_ | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/GRANT/WITH_ | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/INDEX | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/INDEX_STATI | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/OPTION_OBJN | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/POST_DATA_T | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/REF_CONSTRA | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/RLS_CONTEXT | Fine-grained access control contexts |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/RLS_GROUP | Fine-grained access control policy groups |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/RLS_POLICY | Fine-grained access control policies |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/RLS_POLICY_ | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/TABLE | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/TABLE_DATA | |
| DATABASE_EXPORT/EARLY_OPTIONS_WITH_DEP/TRIGGER | |
| DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT | |
| DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MAR | |
| DATABASE_EXPORT/END_PLUGTS_BLK | Post-import plugts anonymous block |
| DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT | |
| DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MAR | |
| DATABASE_EXPORT/GRANT | |
| DATABASE_EXPORT/GRANT/SYSTEM_GRANT | |
| DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRA | Procedural system privilege grants |
| DATABASE_EXPORT/NORMAL_OPTIONS | |
| DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_OBJNUM | |
| DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_PACKAGE | |
| DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_PACKAGE/OPTI | |
| DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_PACKAGE/PACK | |
| DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_PACKAGE/PACK | |
| DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_TYPE | |
| DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_TYPE/OPTION_ | |
| DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_TYPE/SORT_TY | |
| DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_TYPE/TABTYPE | |
| DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_TYPE/TYPE_BO | Type bodies |
| DATABASE_EXPORT/NORMAL_OPTIONS/OPTION_TYPE/TYPE_SP | |
| DATABASE_EXPORT/NORMAL_OPTIONS/POST_DATA_TABLE | |
| DATABASE_EXPORT/NORMAL_OPTIONS/PROCEDURE | |
| DATABASE_EXPORT/NORMAL_OPTIONS/TABLE | |
| DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA | |
| DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES | |
| DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TAB | |
| DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TAB | |
| DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/VAT | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/AUDIT_OBJ | Object audits on the selected tables |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/COMMENT | Table and column comments on the selected tables |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/CONSTRAINT | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/FGA_POLICY | Fine-grained auditing policies |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/FUNCTIONAL | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/FUNCTIONAL | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/FUNCTIONAL | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/GRANT | Object grants on the selected tables |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/GRANT/CROS | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/GRANT/CROS | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/GRANT/OWNE | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/GRANT/OWNE | Object grants on the selected tables |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/GRANT/WITH | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/GRANT/WITH | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/INDEX | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/INDEX_STAT | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/OPTION_OBJ | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/POST_DATA_ | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/REF_CONSTR | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/RLS_CONTEX | Fine-grained access control contexts |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/RLS_GROUP | Fine-grained access control policy groups |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/RLS_POLICY | Fine-grained access control policies |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/RLS_POLICY | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/TABLE | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/TABLE_DATA | |
| DATABASE_EXPORT/NORMAL_OPTIONS_WITH_DEP/TRIGGER | |
| DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU | |
| DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOU/MAR | |
| DATABASE_EXPORT/PASSWORD_VERIFY_FUNCTION | The password complexity verification function |
| DATABASE_EXPORT/PLUGTS_FULL | |
| DATABASE_EXPORT/PLUGTS_FULL/EARLY | |
| DATABASE_EXPORT/PLUGTS_FULL/EARLY/PLUGTS_TABLESPAC | |
| DATABASE_EXPORT/PLUGTS_FULL/FULL | |
| DATABASE_EXPORT/PLUGTS_FULL/FULL/PLUGTS_TABLESPACE | |
| DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BEGIN | Call dbms_plugts.beginExport |
| DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK | Pre-import anonymous block |
| DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_CHECKPL | Call dbms_plugts.checkPluggable |
| DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_EARLY_TABLESPAC | |
| DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_TSNAME_FULL | |
| DATABASE_EXPORT/PLUGTS_FULL/TABLESPACE | |
| DATABASE_EXPORT/POST_SYSTEM | Post-system callouts |
| DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT | |
| DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER | |
| DATABASE_EXPORT/POST_SYSTEM/SYSTEM_CALLOUT | |
| DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT | |
| DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER | |
| DATABASE_EXPORT/PRE_SYSTEM | Pre-system callouts |
| DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT | |
| DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER | |
| DATABASE_EXPORT/PRE_SYSTEM/SYSTEM_CALLOUT | System callouts |
| DATABASE_EXPORT/PROCOBJ_OBJNUM | |
| DATABASE_EXPORT/PROFILE | Profiles |
| DATABASE_EXPORT/PROXY | Proxy authentications |
| DATABASE_EXPORT/RESOURCE_COST | Resource cost information |
| DATABASE_EXPORT/ROLE | Roles |
| DATABASE_EXPORT/ROLLBACK_SEGMENT | Rollback segments |
| DATABASE_EXPORT/SCHEMA | |
| DATABASE_EXPORT/SCHEMA | Pre-schema procedural actions and objects and their dependent grants and audits |
| DATABASE_EXPORT/SCHEMA | Database schemas including related and dependent objects |
| DATABASE_EXPORT/SCHEMA/ASSOCIATION | Statistics type associations |
| DATABASE_EXPORT/SCHEMA/CLUSTER | Clusters and their indexes |
| DATABASE_EXPORT/SCHEMA/CLUSTER/CLUSTER | |
| DATABASE_EXPORT/SCHEMA/CLUSTER/INDEX | |
| DATABASE_EXPORT/SCHEMA/DB_LINK | Private and public database links |
| DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE | Default roles granted to users in the database |
| DATABASE_EXPORT/SCHEMA/DIMENSION | Dimensions |
| DATABASE_EXPORT/SCHEMA/DVPS_STAGING_REALM_MEMBERSH | Database Vault Import Staging Realm Membership |
| DATABASE_EXPORT/SCHEMA/EVENT | |
| DATABASE_EXPORT/SCHEMA/EVENT/TRIGGER | |
| DATABASE_EXPORT/SCHEMA/FUNCTION | Functions and their dependent grants and audits |
| DATABASE_EXPORT/SCHEMA/FUNCTION | |
| DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION | Recompile functions |
| DATABASE_EXPORT/SCHEMA/FUNCTION/AUDIT_OBJ | |
| DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION | |
| DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT | |
| DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/CROSS_SCHEMA | |
| DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/CROSS_SCHEMA | |
| DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT | |
| DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT/ | |
| DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/WITH_GRANT_O | |
| DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/WITH_GRANT_O | |
| DATABASE_EXPORT/SCHEMA/GRANT | |
| DATABASE_EXPORT/SCHEMA/GRANT/PROCOBJ_GRANT | Schema procedural object grants in the selected schemas |
| DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT | |
| DATABASE_EXPORT/SCHEMA/INDEXTYPE | Indextypes and their dependent grants and audits |
| DATABASE_EXPORT/SCHEMA/INDEXTYPE/AUDIT_OBJ | |
| DATABASE_EXPORT/SCHEMA/INDEXTYPE/COMMENT | |
| DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT | |
| DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT/CROSS_SCHEM | |
| DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT/CROSS_SCHEM | |
| DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT/OWNER_GRANT | |
| DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT/OWNER_GRANT | |
| DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT/WITH_GRANT_ | |
| DATABASE_EXPORT/SCHEMA/INDEXTYPE/GRANT/WITH_GRANT_ | |
| DATABASE_EXPORT/SCHEMA/INDEXTYPE/INDEXTYPE | |
| DATABASE_EXPORT/SCHEMA/JAVA_CLASS | Java classes and their dependent grants and audits |
| DATABASE_EXPORT/SCHEMA/JAVA_CLASS/AUDIT_OBJ | |
| DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT | |
| DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT/CROSS_SCHE | |
| DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT/CROSS_SCHE | |
| DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT/OWNER_GRAN | |
| DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT/OWNER_GRAN | |
| DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT/WITH_GRANT | |
| DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT/WITH_GRANT | |
| DATABASE_EXPORT/SCHEMA/JAVA_CLASS/JAVA_CLASS | |
| DATABASE_EXPORT/SCHEMA/JAVA_OBJNUM | |
| DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE | Java resources and their dependent grants and audits |
| DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/AUDIT_OBJ | |
| DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/GRANT | |
| DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/GRANT/CROSS_S | |
| DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/GRANT/CROSS_S | |
| DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/GRANT/OWNER_G | |
| DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/GRANT/OWNER_G | |
| DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/GRANT/WITH_GR | |
| DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/GRANT/WITH_GR | |
| DATABASE_EXPORT/SCHEMA/JAVA_RESOURCE/JAVA_RESOURCE | |
| DATABASE_EXPORT/SCHEMA/JAVA_SOURCE | Java sources and their dependent grants and audits |
| DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/AUDIT_OBJ | |
| DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/GRANT | |
| DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/GRANT/CROSS_SCH | |
| DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/GRANT/CROSS_SCH | |
| DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/GRANT/OWNER_GRA | |
| DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/GRANT/OWNER_GRA | |
| DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/GRANT/WITH_GRAN | |
| DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/GRANT/WITH_GRAN | |
| DATABASE_EXPORT/SCHEMA/JAVA_SOURCE/JAVA_SOURCE | |
| DATABASE_EXPORT/SCHEMA/JOB | Jobs |
| DATABASE_EXPORT/SCHEMA/LIBRARY | External procedure libraries and their dependent grants and audits |
| DATABASE_EXPORT/SCHEMA/LIBRARY/AUDIT_OBJ | |
| DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT | |
| DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT/CROSS_SCHEMA | |
| DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT/CROSS_SCHEMA/ | |
| DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT/OWNER_GRANT | |
| DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT/OWNER_GRANT/O | |
| DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT/WITH_GRANT_OP | |
| DATABASE_EXPORT/SCHEMA/LIBRARY/GRANT/WITH_GRANT_OP | |
| DATABASE_EXPORT/SCHEMA/LIBRARY/LIBRARY | |
| DATABASE_EXPORT/SCHEMA/MATERIALIZED_VIEW | Materialized views |
| DATABASE_EXPORT/SCHEMA/OPERATOR | Operators and their dependent grants and audits |
| DATABASE_EXPORT/SCHEMA/OPERATOR/AUDIT_OBJ | |
| DATABASE_EXPORT/SCHEMA/OPERATOR/COMMENT | |
| DATABASE_EXPORT/SCHEMA/OPERATOR/GRANT | |
| DATABASE_EXPORT/SCHEMA/OPERATOR/GRANT/CROSS_SCHEMA | |
| DATABASE_EXPORT/SCHEMA/OPERATOR/GRANT/CROSS_SCHEMA | |
| DATABASE_EXPORT/SCHEMA/OPERATOR/GRANT/OWNER_GRANT | |
| DATABASE_EXPORT/SCHEMA/OPERATOR/GRANT/OWNER_GRANT/ | |
| DATABASE_EXPORT/SCHEMA/OPERATOR/GRANT/WITH_GRANT_O | |
| DATABASE_EXPORT/SCHEMA/OPERATOR/GRANT/WITH_GRANT_O | |
| DATABASE_EXPORT/SCHEMA/OPERATOR/OPERATOR | |
| DATABASE_EXPORT/SCHEMA/PACKAGE | |
| DATABASE_EXPORT/SCHEMA/PACKAGE | Packages (both specification and body) and their dependent grants and audits |
| DATABASE_EXPORT/SCHEMA/PACKAGE/AUDIT_OBJ | |
| DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES | |
| DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE | |
| DATABASE_EXPORT/SCHEMA/PACKAGE_BODIES/PACKAGE/PACK | Package bodies |
| DATABASE_EXPORT/SCHEMA/PACKAGE/COMPILE_PACKAGE | |
| DATABASE_EXPORT/SCHEMA/PACKAGE/COMPILE_PACKAGE/PAC | |
| DATABASE_EXPORT/SCHEMA/PACKAGE/COMPILE_PACKAGE/PAC | Recompile package specifications |
| DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT | |
| DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/CROSS_SCHEMA | |
| DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/CROSS_SCHEMA/ | |
| DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/OWNER_GRANT | |
| DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/OWNER_GRANT/O | |
| DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/WITH_GRANT_OP | |
| DATABASE_EXPORT/SCHEMA/PACKAGE/GRANT/WITH_GRANT_OP | |
| DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_OBJNUM | |
| DATABASE_EXPORT/SCHEMA/PACKAGE/PACKAGE_SPEC | Package specifications |
| DATABASE_EXPORT/SCHEMA/PASSWORD_HISTORY | Password histories for database users |
| DATABASE_EXPORT/SCHEMA/POST_SCHEMA | Post-schema procedural actions and objects and their dependent grants and audits |
| DATABASE_EXPORT/SCHEMA/POST_SCHEMA/GRANT | |
| DATABASE_EXPORT/SCHEMA/POST_SCHEMA/GRANT/PROCOBJ_G | |
| DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA | |
| DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ | |
| DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ_AUDIT | |
| DATABASE_EXPORT/SCHEMA/POST_SCHEMA/SCHEMA_CALLOUT | |
| DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA | Schema procedural actions in the selected schemas |
| DATABASE_EXPORT/SCHEMA/PROCEDURE | |
| DATABASE_EXPORT/SCHEMA/PROCEDURE | Procedures and their dependent grants and audits |
| DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE | Recompile procedures |
| DATABASE_EXPORT/SCHEMA/PROCEDURE/AUDIT_OBJ | |
| DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT | |
| DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/CROSS_SCHEM | |
| DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/CROSS_SCHEM | |
| DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/OWNER_GRANT | |
| DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/OWNER_GRANT | |
| DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/WITH_GRANT_ | |
| DATABASE_EXPORT/SCHEMA/PROCEDURE/GRANT/WITH_GRANT_ | |
| DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE | |
| DATABASE_EXPORT/SCHEMA/PROCOBJ | Procedural objects in the selected schemas |
| DATABASE_EXPORT/SCHEMA/PROCOBJ_AUDIT | Schema procedural object audits in the selected schemas |
| DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM | |
| DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/FGA_POLICY | |
| DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/RLS_CONTEXT | |
| DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/RLS_GROUP | |
| DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/RLS_POLICY | |
| DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/RLS_POLICY/R | |
| DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/RLS_POLICY/R | |
| DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM | Public and private synonyms |
| DATABASE_EXPORT/SCHEMA/REFRESH_GROUP | Refresh groups |
| DATABASE_EXPORT/SCHEMA/ROLE_GRANT | Role grants to users in the database |
| DATABASE_EXPORT/SCHEMA/SCHEMA_CALLOUT | Schema callouts in the selected schemas |
| DATABASE_EXPORT/SCHEMA/SEQUENCE | Sequences and their dependent grants and audits |
| DATABASE_EXPORT/SCHEMA/SEQUENCE/AUDIT_OBJ | |
| DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT | |
| DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/CROSS_SCHEMA | |
| DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/CROSS_SCHEMA | |
| DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT | |
| DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/ | |
| DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/WITH_GRANT_O | |
| DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/WITH_GRANT_O | |
| DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE | |
| DATABASE_EXPORT/SCHEMA/SYNONYM | |
| DATABASE_EXPORT/SCHEMA/SYNONYM/FGA_POLICY | |
| DATABASE_EXPORT/SCHEMA/SYNONYM/RLS_CONTEXT | |
| DATABASE_EXPORT/SCHEMA/SYNONYM/RLS_GROUP | |
| DATABASE_EXPORT/SCHEMA/SYNONYM/RLS_POLICY | |
| DATABASE_EXPORT/SCHEMA/SYNONYM/RLS_POLICY/RLS_POLI | |
| DATABASE_EXPORT/SCHEMA/SYNONYM/RLS_POLICY/RLS_POLI | |
| DATABASE_EXPORT/SCHEMA/TABLE | Tables and their dependent objects |
| DATABASE_EXPORT/SCHEMA/TABLE | |
| DATABASE_EXPORT/SCHEMA/TABLE/AUDIT_OBJ | Object audits on the selected tables |
| DATABASE_EXPORT/SCHEMA/TABLE/COMMENT | Table and column comments on the selected tables |
| DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT | |
| DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT | Constraints (including referential constraints) |
| DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT | |
| DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTR | Referential constraints |
| DATABASE_EXPORT/SCHEMA/TABLE/DEPTABLE_OBJNUM | |
| DATABASE_EXPORT/SCHEMA/TABLE/FGA_POLICY | Fine-grained auditing policies |
| DATABASE_EXPORT/SCHEMA/TABLE/GRANT | Object grants on the selected tables |
| DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA | |
| DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OB | |
| DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT | |
| DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJ | Object grants on the selected tables |
| DATABASE_EXPORT/SCHEMA/TABLE/GRANT/WITH_GRANT_OPTI | |
| DATABASE_EXPORT/SCHEMA/TABLE/GRANT/WITH_GRANT_OPTI | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX | Indexes |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/BITMAP_INDEX | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/BITMAP_INDEX/IN | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/IN | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMIDX_OBJNUM | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDE | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDE | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS | Precomputed statistics |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/BITM | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/BITM | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNC | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNC | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDE | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/TABLE | |
| DATABASE_EXPORT/SCHEMA/TABLE/INDEX/TABLE_DATA | |
| DATABASE_EXPORT/SCHEMA/TABLE/INSTANCE_CALLOUT | Instance callouts |
| DATABASE_EXPORT/SCHEMA/TABLE/MATERIALIZED_VIEW_LOG | Materialized view logs |
| DATABASE_EXPORT/SCHEMA/TABLE/NTABLE_OBJNUM | |
| DATABASE_EXPORT/SCHEMA/TABLE/POST_DATA_TABLE | |
| DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE | |
| DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/GRANT | |
| DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/GRANT/P | Grants on instance procedural objects |
| DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/INSTANC | |
| DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCACT | |
| DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEP | Instance procedural objects |
| DATABASE_EXPORT/SCHEMA/TABLE/POST_INSTANCE/PROCDEP | Audits on instance procedural objects |
| DATABASE_EXPORT/SCHEMA/TABLE/POST_TABLE_ACTION | Post-table actions |
| DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION | Pre-table actions |
| DATABASE_EXPORT/SCHEMA/TABLE/PROCACT_INSTANCE | Instance procedural actions |
| DATABASE_EXPORT/SCHEMA/TABLE/RLS_CONTEXT | Fine-grained access control contexts |
| DATABASE_EXPORT/SCHEMA/TABLE/RLS_GROUP | Fine-grained access control policy groups |
| DATABASE_EXPORT/SCHEMA/TABLE/RLS_POLICY | |
| DATABASE_EXPORT/SCHEMA/TABLE/RLS_POLICY/RLS_POLICY | Fine-grained access control policies |
| DATABASE_EXPORT/SCHEMA/TABLE/RLS_POLICY/RLS_POLICY | |
| DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA | Tablespace quota granted to users in the database |
| DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS | |
| DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STAT | |
| DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/USER_PREF_ | |
| DATABASE_EXPORT/SCHEMA/TABLE/TABLE | |
| DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA | |
| DATABASE_EXPORT/SCHEMA/TABLE/TABLE_OBJNUM | |
| DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER | Triggers |
| DATABASE_EXPORT/SCHEMA/TYPE | Types (both specification and body) and their dependent grants and audits |
| DATABASE_EXPORT/SCHEMA/TYPE | |
| DATABASE_EXPORT/SCHEMA/TYPE/AUDIT_OBJ | |
| DATABASE_EXPORT/SCHEMA/TYPE/GRANT | |
| DATABASE_EXPORT/SCHEMA/TYPE/GRANT/CROSS_SCHEMA | |
| DATABASE_EXPORT/SCHEMA/TYPE/GRANT/CROSS_SCHEMA/OBJ | |
| DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT | |
| DATABASE_EXPORT/SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJE | |
| DATABASE_EXPORT/SCHEMA/TYPE/GRANT/WITH_GRANT_OPTIO | |
| DATABASE_EXPORT/SCHEMA/TYPE/GRANT/WITH_GRANT_OPTIO | |
| DATABASE_EXPORT/SCHEMA/TYPE/INC_TYPE | |
| DATABASE_EXPORT/SCHEMA/TYPE/SORT_TYPES | |
| DATABASE_EXPORT/SCHEMA/TYPE/TYPE_BODY | Type bodies |
| DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC | Type specifications |
| DATABASE_EXPORT/SCHEMA/USER | User definitions |
| DATABASE_EXPORT/SCHEMA/VIEW | Views and their dependent objects |
| DATABASE_EXPORT/SCHEMA/VIEW | |
| DATABASE_EXPORT/SCHEMA/VIEW/AUDIT_OBJ | |
| DATABASE_EXPORT/SCHEMA/VIEW/COMMENT | |
| DATABASE_EXPORT/SCHEMA/VIEW/CONSTRAINT | |
| DATABASE_EXPORT/SCHEMA/VIEW/FGA_POLICY | |
| DATABASE_EXPORT/SCHEMA/VIEW/GRANT | |
| DATABASE_EXPORT/SCHEMA/VIEW/GRANT/CROSS_SCHEMA | |
| DATABASE_EXPORT/SCHEMA/VIEW/GRANT/CROSS_SCHEMA/OBJ | |
| DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT | |
| DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJE | |
| DATABASE_EXPORT/SCHEMA/VIEW/GRANT/WITH_GRANT_OPTIO | |
| DATABASE_EXPORT/SCHEMA/VIEW/GRANT/WITH_GRANT_OPTIO | |
| DATABASE_EXPORT/SCHEMA/VIEW/RLS_CONTEXT | |
| DATABASE_EXPORT/SCHEMA/VIEW/RLS_GROUP | |
| DATABASE_EXPORT/SCHEMA/VIEW/RLS_POLICY | |
| DATABASE_EXPORT/SCHEMA/VIEW/RLS_POLICY/RLS_POLICY | Fine-grained access control policies |
| DATABASE_EXPORT/SCHEMA/VIEW/RLS_POLICY/RLS_POLICY_ | |
| DATABASE_EXPORT/SCHEMA/VIEW/TRIGGER | |
| DATABASE_EXPORT/SCHEMA/VIEW/VIEW | |
| DATABASE_EXPORT/SCHEMA/VIEW/VIEW_OBJNUM | |
| DATABASE_EXPORT/SCHEMA/XMLSCHEMA | Xmlschemas |
| DATABASE_EXPORT/SCHEMA/XMLSCHEMA/EXP_XMLSCHEMA | |
| DATABASE_EXPORT/SYSTEM_PROCOBJACT | System procedural actions and objects and their dependent grants and audits |
| DATABASE_EXPORT/SYSTEM_PROCOBJACT/GRANT | |
| DATABASE_EXPORT/SYSTEM_PROCOBJACT/GRANT/PROCOBJ_GR | |
| DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTI | Post-system procedural actions |
| DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTI | |
| DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIO | Pre-system procedural actions |
| DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIO | |
| DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ | |
| DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ_AUDIT | |
| DATABASE_EXPORT/SYS_USER | |
| DATABASE_EXPORT/SYS_USER/USER | |
| DATABASE_EXPORT/TABLESPACE | Tablespace definitions |
| DATABASE_EXPORT/TRUSTED_DB_LINK | |
| DB_LINK | Private and public database links |
| DEFAULT_ROLE | Default roles granted to users in the database |
| DEPTABLE_OBJNUM | |
| DIMENSION | Dimensions |
| DIRECTORY | |
| DIRECTORY | Directories and their dependent grants and audits |
| DIRECTORY/AUDIT_OBJ | |
| DIRECTORY/DIRECTORY | Directories and their dependent grants and audits |
| DIRECTORY/GRANT | |
| DIRECTORY/GRANT/CROSS_SCHEMA | |
| DIRECTORY/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| DIRECTORY/GRANT/OWNER_GRANT | |
| DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| DIRECTORY/GRANT/WITH_GRANT_OPTION | |
| DIRECTORY/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| DOMAIN_INDEX | |
| DOMAIN_INDEX/INDEX | |
| DOMIDX_OBJNUM | |
| DVPS_COMMAND_RULE | Database Vault Command Rule definitions |
| DVPS_COMMAND_RULE_GROUP | Database Vault Command Rule-based security policy definitions |
| DVPS_COMMAND_RULE_GROUP/DVPS_COMMAND_RULE | Database Vault Command Rule definitions |
| DVPS_COMMAND_RULE_GROUP/DVPS_ROLE | Database Vault Role definitions |
| DVPS_COMMAND_RULE_GROUP/DVPS_RULE | Database Vault Rule definitions |
| DVPS_COMMAND_RULE_GROUP/DVPS_RULE_SET | Database Vault Rule Set definitions |
| DVPS_COMMAND_RULE_GROUP/DVPS_RULE_SET_MEMBERSHIP | Database Vault Rules in a Rule Set definitions |
| DVPS_DROP_IMPORT_STAGING_REALM | Delete the Database Vault Import Staging Realm definitions |
| DVPS_FACTOR | Database Vault Factor definitions |
| DVPS_FACTOR_GROUP | Database Vault Factor definitions |
| DVPS_FACTOR_GROUP/DVPS_FACTOR | Database Vault Factor definitions |
| DVPS_FACTOR_GROUP/DVPS_FACTOR_LINK | Database Vault Factor Link definitions |
| DVPS_FACTOR_GROUP/DVPS_FACTOR_TYPE | Database Vault Factor Type definitions |
| DVPS_FACTOR_GROUP/DVPS_IDENTITY | Database Vault Identity definitions |
| DVPS_FACTOR_GROUP/DVPS_IDENTITY_MAP | Database Vault Identity Map definitions |
| DVPS_FACTOR_LINK | Database Vault Factor Link definitions |
| DVPS_FACTOR_TYPE | Database Vault Factor Type definitions |
| DVPS_IDENTITY | Database Vault Identity definitions |
| DVPS_IDENTITY_MAP | Database Vault Identity Map definitions |
| DVPS_IMPORT_STAGING_REALM | Database Vault Import Staging Realm definitions |
| DVPS_POLICY | Database Vault security policies |
| DVPS_POLICY/DVPS_COMMAND_RULE_GROUP | Database Vault Command Rule-based security policy definitions |
| DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_COMMAND_R | Database Vault Command Rule definitions |
| DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_ROLE | Database Vault Role definitions |
| DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_RULE | Database Vault Rule definitions |
| DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_RULE_SET | Database Vault Rule Set definitions |
| DVPS_POLICY/DVPS_COMMAND_RULE_GROUP/DVPS_RULE_SET_ | Database Vault Rules in a Rule Set definitions |
| DVPS_POLICY/DVPS_DROP_IMPORT_STAGING_REALM | Delete the Database Vault Import Staging Realm definitions |
| DVPS_POLICY/DVPS_FACTOR_GROUP | Database Vault Factor definitions |
| DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_FACTOR | Database Vault Factor definitions |
| DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_FACTOR_LINK | Database Vault Factor Link definitions |
| DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_FACTOR_TYPE | Database Vault Factor Type definitions |
| DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_IDENTITY | Database Vault Identity definitions |
| DVPS_POLICY/DVPS_FACTOR_GROUP/DVPS_IDENTITY_MAP | Database Vault Identity Map definitions |
| DVPS_POLICY/DVPS_REALM_GROUP | Database Vault Realm-based security policy definitions |
| DVPS_POLICY/DVPS_REALM_GROUP/DVPS_REALM | Database Vault Realm definitions |
| DVPS_POLICY/DVPS_REALM_GROUP/DVPS_REALM_AUTHORIZAT | Database Vault Realm Authorization definitions |
| DVPS_POLICY/DVPS_REALM_GROUP/DVPS_REALM_MEMBERSHIP | Database Vault Realm Membership definitions |
| DVPS_REALM | Database Vault Realm definitions |
| DVPS_REALM_AUTHORIZATION | Database Vault Realm Authorization definitions |
| DVPS_REALM_GROUP | Database Vault Realm-based security policy definitions |
| DVPS_REALM_GROUP/DVPS_REALM | Database Vault Realm definitions |
| DVPS_REALM_GROUP/DVPS_REALM_AUTHORIZATION | Database Vault Realm Authorization definitions |
| DVPS_REALM_GROUP/DVPS_REALM_MEMBERSHIP | Database Vault Realm Membership definitions |
| DVPS_REALM_MEMBERSHIP | Database Vault Realm Membership definitions |
| DVPS_ROLE | Database Vault Role definitions |
| DVPS_RULE | Database Vault Rule definitions |
| DVPS_RULE_SET | Database Vault Rule Set definitions |
| DVPS_RULE_SET_MEMBERSHIP | Database Vault Rules in a Rule Set definitions |
| DVPS_STAGING_REALM_MEMBERSHIP | Database Vault Import Staging Realm Membership |
| EARLY | |
| EARLY_OPTIONS | |
| EARLY_OPTIONS/OPTION_OBJNUM | |
| EARLY_OPTIONS/OPTION_PACKAGE | |
| EARLY_OPTIONS/OPTION_PACKAGE/OPTION_OBJNUM | |
| EARLY_OPTIONS/OPTION_PACKAGE/PACKAGE_BODY | |
| EARLY_OPTIONS/OPTION_PACKAGE/PACKAGE_SPEC | |
| EARLY_OPTIONS/OPTION_TYPE | |
| EARLY_OPTIONS/OPTION_TYPE/OPTION_OBJNUM | |
| EARLY_OPTIONS/OPTION_TYPE/SORT_TYPES | |
| EARLY_OPTIONS/OPTION_TYPE/TABTYPE_OBJNUM | |
| EARLY_OPTIONS/OPTION_TYPE/TYPE_BODY | Type bodies |
| EARLY_OPTIONS/OPTION_TYPE/TYPE_SPEC | |
| EARLY_OPTIONS/POST_DATA_TABLE | |
| EARLY_OPTIONS/PROCEDURE | |
| EARLY_OPTIONS/TABLE | |
| EARLY_OPTIONS/TABLE_DATA | |
| EARLY_OPTIONS/VIEWS_AS_TABLES | |
| EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE | |
| EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA | |
| EARLY_OPTIONS/VIEWS_AS_TABLES/VAT_OBJNUM | |
| EARLY_OPTIONS_WITH_DEP | |
| EARLY_OPTIONS_WITH_DEP/AUDIT_OBJ | Object audits on the selected tables |
| EARLY_OPTIONS_WITH_DEP/COMMENT | Table and column comments on the selected tables |
| EARLY_OPTIONS_WITH_DEP/CONSTRAINT | |
| EARLY_OPTIONS_WITH_DEP/FGA_POLICY | Fine-grained auditing policies |
| EARLY_OPTIONS_WITH_DEP/FUNCTIONAL_INDEX | |
| EARLY_OPTIONS_WITH_DEP/FUNCTIONAL_INDEX/INDEX | |
| EARLY_OPTIONS_WITH_DEP/FUNCTIONAL_INDEX/INDEX_STAT | |
| EARLY_OPTIONS_WITH_DEP/GRANT | Object grants on the selected tables |
| EARLY_OPTIONS_WITH_DEP/GRANT/CROSS_SCHEMA | |
| EARLY_OPTIONS_WITH_DEP/GRANT/CROSS_SCHEMA/OBJECT_G | |
| EARLY_OPTIONS_WITH_DEP/GRANT/OWNER_GRANT | |
| EARLY_OPTIONS_WITH_DEP/GRANT/OWNER_GRANT/OBJECT_GR | Object grants on the selected tables |
| EARLY_OPTIONS_WITH_DEP/GRANT/WITH_GRANT_OPTION | |
| EARLY_OPTIONS_WITH_DEP/GRANT/WITH_GRANT_OPTION/OBJ | |
| EARLY_OPTIONS_WITH_DEP/INDEX | |
| EARLY_OPTIONS_WITH_DEP/INDEX_STATISTICS | |
| EARLY_OPTIONS_WITH_DEP/OPTION_OBJNUM | |
| EARLY_OPTIONS_WITH_DEP/POST_DATA_TABLE | |
| EARLY_OPTIONS_WITH_DEP/REF_CONSTRAINT | |
| EARLY_OPTIONS_WITH_DEP/RLS_CONTEXT | Fine-grained access control contexts |
| EARLY_OPTIONS_WITH_DEP/RLS_GROUP | Fine-grained access control policy groups |
| EARLY_OPTIONS_WITH_DEP/RLS_POLICY | Fine-grained access control policies |
| EARLY_OPTIONS_WITH_DEP/RLS_POLICY_OBJNUM | |
| EARLY_OPTIONS_WITH_DEP/TABLE | |
| EARLY_OPTIONS_WITH_DEP/TABLE_DATA | |
| EARLY_OPTIONS_WITH_DEP/TRIGGER | |
| EARLY/PLUGTS_TABLESPACE | |
| EARLY_POST_INSTANCE_IMPCALLOUT | |
| EARLY_POST_INSTANCE_IMPCALLOUT/MARKER | |
| END_PLUGTS_BLK | Post-import plugts anonymous block |
| EVENT | |
| EVENT/TRIGGER | |
| EXP_XMLSCHEMA | |
| FGA_POLICY | Fine-grained auditing policies |
| FGA_POLICY | |
| FINAL_POST_INSTANCE_IMPCALLOUT | |
| FINAL_POST_INSTANCE_IMPCALLOUT/MARKER | |
| FULL | |
| FULL/PLUGTS_TABLESPACE | |
| FUNCTION | |
| FUNCTION | Functions and their dependent grants and audits |
| FUNCTIONAL_INDEX | |
| FUNCTIONAL_INDEX/INDEX | |
| FUNCTIONAL_INDEX/INDEX_STATISTICS | |
| FUNCTION/ALTER_FUNCTION | Recompile functions |
| FUNCTION/AUDIT_OBJ | |
| FUNCTION/FUNCTION | |
| FUNCTION/GRANT | |
| FUNCTION/GRANT/CROSS_SCHEMA | |
| FUNCTION/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| FUNCTION/GRANT/OWNER_GRANT | |
| FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| FUNCTION/GRANT/WITH_GRANT_OPTION | |
| FUNCTION/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| GRANT | |
| GRANT | Object grants on the selected tables |
| GRANT/CROSS_SCHEMA | |
| GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| GRANT/OWNER_GRANT | |
| GRANT/OWNER_GRANT/OBJECT_GRANT | |
| GRANT/OWNER_GRANT/OBJECT_GRANT | Object grants on the selected tables |
| GRANT/PROCDEPOBJ_GRANT | Grants on instance procedural objects |
| GRANT/PROCOBJ_GRANT | |
| GRANT/PROCOBJ_GRANT | Schema procedural object grants in the selected schemas |
| GRANT/SYSTEM_GRANT | |
| GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT | Procedural system privilege grants |
| GRANT/WITH_GRANT_OPTION | |
| GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| INC_TYPE | |
| INDEX | |
| INDEX | Indexes |
| INDEX/BITMAP_INDEX | |
| INDEX/BITMAP_INDEX/INDEX | |
| INDEX/DOMAIN_INDEX | |
| INDEX/DOMAIN_INDEX/INDEX | |
| INDEX/DOMIDX_OBJNUM | |
| INDEX/FUNCTIONAL_INDEX | |
| INDEX/FUNCTIONAL_INDEX/INDEX | |
| INDEX/INDEX | |
| INDEX/STATISTICS | Precomputed statistics |
| INDEX/STATISTICS | |
| INDEX_STATISTICS | |
| INDEX/STATISTICS/BITMAP_INDEX | |
| INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTICS | |
| INDEX/STATISTICS/FUNCTIONAL_INDEX | |
| INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS | |
| INDEX/STATISTICS/INDEX_STATISTICS | |
| INDEX/TABLE | |
| INDEX/TABLE_DATA | |
| INDEXTYPE | |
| INDEXTYPE | Indextypes and their dependent grants and audits |
| INDEXTYPE/AUDIT_OBJ | |
| INDEXTYPE/COMMENT | |
| INDEXTYPE/GRANT | |
| INDEXTYPE/GRANT/CROSS_SCHEMA | |
| INDEXTYPE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| INDEXTYPE/GRANT/OWNER_GRANT | |
| INDEXTYPE/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| INDEXTYPE/GRANT/WITH_GRANT_OPTION | |
| INDEXTYPE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| INDEXTYPE/INDEXTYPE | |
| INSTANCE_CALLOUT | Instance callouts |
| INSTANCE_CALLOUT | |
| JAVA_CLASS | Java classes and their dependent grants and audits |
| JAVA_CLASS | |
| JAVA_CLASS/AUDIT_OBJ | |
| JAVA_CLASS/GRANT | |
| JAVA_CLASS/GRANT/CROSS_SCHEMA | |
| JAVA_CLASS/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| JAVA_CLASS/GRANT/OWNER_GRANT | |
| JAVA_CLASS/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| JAVA_CLASS/GRANT/WITH_GRANT_OPTION | |
| JAVA_CLASS/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| JAVA_CLASS/JAVA_CLASS | |
| JAVA_OBJNUM | |
| JAVA_RESOURCE | |
| JAVA_RESOURCE | Java resources and their dependent grants and audits |
| JAVA_RESOURCE/AUDIT_OBJ | |
| JAVA_RESOURCE/GRANT | |
| JAVA_RESOURCE/GRANT/CROSS_SCHEMA | |
| JAVA_RESOURCE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| JAVA_RESOURCE/GRANT/OWNER_GRANT | |
| JAVA_RESOURCE/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| JAVA_RESOURCE/GRANT/WITH_GRANT_OPTION | |
| JAVA_RESOURCE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| JAVA_RESOURCE/JAVA_RESOURCE | |
| JAVA_SOURCE | |
| JAVA_SOURCE | Java sources and their dependent grants and audits |
| JAVA_SOURCE/AUDIT_OBJ | |
| JAVA_SOURCE/GRANT | |
| JAVA_SOURCE/GRANT/CROSS_SCHEMA | |
| JAVA_SOURCE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| JAVA_SOURCE/GRANT/OWNER_GRANT | |
| JAVA_SOURCE/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| JAVA_SOURCE/GRANT/WITH_GRANT_OPTION | |
| JAVA_SOURCE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| JAVA_SOURCE/JAVA_SOURCE | |
| JOB | Jobs |
| LIBRARY | External procedure libraries and their dependent grants and audits |
| LIBRARY | |
| LIBRARY/AUDIT_OBJ | |
| LIBRARY/GRANT | |
| LIBRARY/GRANT/CROSS_SCHEMA | |
| LIBRARY/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| LIBRARY/GRANT/OWNER_GRANT | |
| LIBRARY/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| LIBRARY/GRANT/WITH_GRANT_OPTION | |
| LIBRARY/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| LIBRARY/LIBRARY | |
| MARKER | |
| MATERIALIZED_VIEW | Materialized views |
| MATERIALIZED_VIEW_LOG | Materialized view logs |
| NORMAL_OPTIONS | |
| NORMAL_OPTIONS/OPTION_OBJNUM | |
| NORMAL_OPTIONS/OPTION_PACKAGE | |
| NORMAL_OPTIONS/OPTION_PACKAGE/OPTION_OBJNUM | |
| NORMAL_OPTIONS/OPTION_PACKAGE/PACKAGE_BODY | |
| NORMAL_OPTIONS/OPTION_PACKAGE/PACKAGE_SPEC | |
| NORMAL_OPTIONS/OPTION_TYPE | |
| NORMAL_OPTIONS/OPTION_TYPE/OPTION_OBJNUM | |
| NORMAL_OPTIONS/OPTION_TYPE/SORT_TYPES | |
| NORMAL_OPTIONS/OPTION_TYPE/TABTYPE_OBJNUM | |
| NORMAL_OPTIONS/OPTION_TYPE/TYPE_BODY | Type bodies |
| NORMAL_OPTIONS/OPTION_TYPE/TYPE_SPEC | |
| NORMAL_OPTIONS/POST_DATA_TABLE | |
| NORMAL_OPTIONS/PROCEDURE | |
| NORMAL_OPTIONS/TABLE | |
| NORMAL_OPTIONS/TABLE_DATA | |
| NORMAL_OPTIONS/VIEWS_AS_TABLES | |
| NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE | |
| NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA | |
| NORMAL_OPTIONS/VIEWS_AS_TABLES/VAT_OBJNUM | |
| NORMAL_OPTIONS_WITH_DEP | |
| NORMAL_OPTIONS_WITH_DEP/AUDIT_OBJ | Object audits on the selected tables |
| NORMAL_OPTIONS_WITH_DEP/COMMENT | Table and column comments on the selected tables |
| NORMAL_OPTIONS_WITH_DEP/CONSTRAINT | |
| NORMAL_OPTIONS_WITH_DEP/FGA_POLICY | Fine-grained auditing policies |
| NORMAL_OPTIONS_WITH_DEP/FUNCTIONAL_INDEX | |
| NORMAL_OPTIONS_WITH_DEP/FUNCTIONAL_INDEX/INDEX | |
| NORMAL_OPTIONS_WITH_DEP/FUNCTIONAL_INDEX/INDEX_STA | |
| NORMAL_OPTIONS_WITH_DEP/GRANT | Object grants on the selected tables |
| NORMAL_OPTIONS_WITH_DEP/GRANT/CROSS_SCHEMA | |
| NORMAL_OPTIONS_WITH_DEP/GRANT/CROSS_SCHEMA/OBJECT_ | |
| NORMAL_OPTIONS_WITH_DEP/GRANT/OWNER_GRANT | |
| NORMAL_OPTIONS_WITH_DEP/GRANT/OWNER_GRANT/OBJECT_G | Object grants on the selected tables |
| NORMAL_OPTIONS_WITH_DEP/GRANT/WITH_GRANT_OPTION | |
| NORMAL_OPTIONS_WITH_DEP/GRANT/WITH_GRANT_OPTION/OB | |
| NORMAL_OPTIONS_WITH_DEP/INDEX | |
| NORMAL_OPTIONS_WITH_DEP/INDEX_STATISTICS | |
| NORMAL_OPTIONS_WITH_DEP/OPTION_OBJNUM | |
| NORMAL_OPTIONS_WITH_DEP/POST_DATA_TABLE | |
| NORMAL_OPTIONS_WITH_DEP/REF_CONSTRAINT | |
| NORMAL_OPTIONS_WITH_DEP/RLS_CONTEXT | Fine-grained access control contexts |
| NORMAL_OPTIONS_WITH_DEP/RLS_GROUP | Fine-grained access control policy groups |
| NORMAL_OPTIONS_WITH_DEP/RLS_POLICY | Fine-grained access control policies |
| NORMAL_OPTIONS_WITH_DEP/RLS_POLICY_OBJNUM | |
| NORMAL_OPTIONS_WITH_DEP/TABLE | |
| NORMAL_OPTIONS_WITH_DEP/TABLE_DATA | |
| NORMAL_OPTIONS_WITH_DEP/TRIGGER | |
| NORMAL_POST_INSTANCE_IMPCALLOU | |
| NORMAL_POST_INSTANCE_IMPCALLOU/MARKER | |
| NTABLE_OBJNUM | |
| OBJECT_GRANT | |
| OBJECT_GRANT | Object grants on the selected tables |
| OPERATOR | Operators and their dependent grants and audits |
| OPERATOR | |
| OPERATOR/AUDIT_OBJ | |
| OPERATOR/COMMENT | |
| OPERATOR/GRANT | |
| OPERATOR/GRANT/CROSS_SCHEMA | |
| OPERATOR/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| OPERATOR/GRANT/OWNER_GRANT | |
| OPERATOR/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| OPERATOR/GRANT/WITH_GRANT_OPTION | |
| OPERATOR/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| OPERATOR/OPERATOR | |
| OPTION_OBJNUM | |
| OPTION_PACKAGE | |
| OPTION_PACKAGE/OPTION_OBJNUM | |
| OPTION_PACKAGE/PACKAGE_BODY | |
| OPTION_PACKAGE/PACKAGE_SPEC | |
| OPTION_TYPE | |
| OPTION_TYPE/OPTION_OBJNUM | |
| OPTION_TYPE/SORT_TYPES | |
| OPTION_TYPE/TABTYPE_OBJNUM | |
| OPTION_TYPE/TYPE_BODY | Type bodies |
| OPTION_TYPE/TYPE_SPEC | |
| OWNER_GRANT | |
| OWNER_GRANT/OBJECT_GRANT | |
| OWNER_GRANT/OBJECT_GRANT | Object grants on the selected tables |
| PACKAGE | Packages (both specification and body) and their dependent grants and audits |
| PACKAGE | |
| PACKAGE/AUDIT_OBJ | |
| PACKAGE_BODIES | |
| PACKAGE_BODIES/PACKAGE | |
| PACKAGE_BODIES/PACKAGE/PACKAGE_BODY | Package bodies |
| PACKAGE_BODY | Package bodies |
| PACKAGE_BODY | |
| PACKAGE/COMPILE_PACKAGE | |
| PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC | |
| PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE | Recompile package specifications |
| PACKAGE/GRANT | |
| PACKAGE/GRANT/CROSS_SCHEMA | |
| PACKAGE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| PACKAGE/GRANT/OWNER_GRANT | |
| PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| PACKAGE/GRANT/WITH_GRANT_OPTION | |
| PACKAGE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| PACKAGE_OBJNUM | |
| PACKAGE/PACKAGE_BODY | Package bodies |
| PACKAGE/PACKAGE_OBJNUM | |
| PACKAGE/PACKAGE_SPEC | Package specifications |
| PACKAGE_SPEC | |
| PACKAGE_SPEC | Package specifications |
| PACKAGE_SPEC/ALTER_PACKAGE_SPEC | Recompile package specifications |
| PASSWORD_HISTORY | Password histories for database users |
| PASSWORD_VERIFY_FUNCTION | The password complexity verification function |
| PLUGTS_BEGIN | Call dbms_plugts.beginExport |
| PLUGTS_BLK | Pre-import anonymous block |
| PLUGTS_CHECKPL | Call dbms_plugts.checkPluggable |
| PLUGTS_EARLY_TABLESPACE | |
| PLUGTS_FULL | |
| PLUGTS_FULL/EARLY | |
| PLUGTS_FULL/EARLY/PLUGTS_TABLESPACE | |
| PLUGTS_FULL/FULL | |
| PLUGTS_FULL/FULL/PLUGTS_TABLESPACE | |
| PLUGTS_FULL/PLUGTS_BEGIN | Call dbms_plugts.beginExport |
| PLUGTS_FULL/PLUGTS_BLK | Pre-import anonymous block |
| PLUGTS_FULL/PLUGTS_CHECKPL | Call dbms_plugts.checkPluggable |
| PLUGTS_FULL/PLUGTS_EARLY_TABLESPACE | |
| PLUGTS_FULL/PLUGTS_TSNAME_FULL | |
| PLUGTS_FULL/TABLESPACE | |
| PLUGTS_TABLESPACE | |
| PLUGTS_TSNAME_FULL | |
| POST_DATA_TABLE | |
| POST_INSTANCE | |
| POST_INSTANCE/GRANT | |
| POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT | Grants on instance procedural objects |
| POST_INSTANCE/INSTANCE_CALLOUT | |
| POST_INSTANCE/PROCACT_INSTANCE | |
| POST_INSTANCE/PROCDEPOBJ | Instance procedural objects |
| POST_INSTANCE/PROCDEPOBJ_AUDIT | Audits on instance procedural objects |
| POST_SCHEMA | Post-schema procedural actions and objects and their dependent grants and audits |
| POST_SCHEMA/GRANT | |
| POST_SCHEMA/GRANT/PROCOBJ_GRANT | |
| POST_SCHEMA/PROCACT_SCHEMA | |
| POST_SCHEMA/PROCOBJ | |
| POST_SCHEMA/PROCOBJ_AUDIT | |
| POST_SCHEMA/SCHEMA_CALLOUT | |
| POST_SYSTEM | Post-system callouts |
| POST_SYSTEM_ACTIONS | Post-system procedural actions |
| POST_SYSTEM_ACTIONS/PROCACT_SYSTEM | |
| POST_SYSTEM_IMPCALLOUT | |
| POST_SYSTEM_IMPCALLOUT/MARKER | |
| POST_SYSTEM/SYSTEM_CALLOUT | |
| POST_TABLE_ACTION | Post-table actions |
| PRE_INSTANCE_IMPCALLOUT | |
| PRE_INSTANCE_IMPCALLOUT/MARKER | |
| PRE_SYSTEM | Pre-system callouts |
| PRE_SYSTEM_ACTIONS | Pre-system procedural actions |
| PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM | |
| PRE_SYSTEM_IMPCALLOUT | |
| PRE_SYSTEM_IMPCALLOUT/MARKER | |
| PRE_SYSTEM/SYSTEM_CALLOUT | System callouts |
| PRE_TABLE_ACTION | Pre-table actions |
| PROCACT_INSTANCE | Instance procedural actions |
| PROCACT_INSTANCE | |
| PROCACT_SCHEMA | |
| PROCACT_SCHEMA | Schema procedural actions in the selected schemas |
| PROCACT_SYSTEM | |
| PROCDEPOBJ | Instance procedural objects |
| PROCDEPOBJ_AUDIT | Audits on instance procedural objects |
| PROCDEPOBJ_GRANT | Grants on instance procedural objects |
| PROCEDURE | Procedures and their dependent grants and audits |
| PROCEDURE | |
| PROCEDURE/ALTER_PROCEDURE | Recompile procedures |
| PROCEDURE/AUDIT_OBJ | |
| PROCEDURE/GRANT | |
| PROCEDURE/GRANT/CROSS_SCHEMA | |
| PROCEDURE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| PROCEDURE/GRANT/OWNER_GRANT | |
| PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| PROCEDURE/GRANT/WITH_GRANT_OPTION | |
| PROCEDURE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| PROCEDURE/PROCEDURE | |
| PROCOBJ | |
| PROCOBJ | Procedural objects in the selected schemas |
| PROCOBJ_AUDIT | |
| PROCOBJ_AUDIT | Schema procedural object audits in the selected schemas |
| PROCOBJ_GRANT | Schema procedural object grants in the selected schemas |
| PROCOBJ_GRANT | |
| PROCOBJ_OBJNUM | |
| PROC_SYSTEM_GRANT | Procedural system privilege grants |
| PROFILE | Profiles |
| PROXY | Proxy authentications |
| PUBLIC_SYNONYM | |
| PUBLIC_SYNONYM/FGA_POLICY | |
| PUBLIC_SYNONYM/RLS_CONTEXT | |
| PUBLIC_SYNONYM/RLS_GROUP | |
| PUBLIC_SYNONYM/RLS_POLICY | |
| PUBLIC_SYNONYM/RLS_POLICY/RLS_POLICY | |
| PUBLIC_SYNONYM/RLS_POLICY/RLS_POLICY_OBJNUM | |
| PUBLIC_SYNONYM/SYNONYM | Public and private synonyms |
| REF_CONSTRAINT | |
| REF_CONSTRAINT | Referential constraints |
| REFRESH_GROUP | Refresh groups |
| RESOURCE_COST | Resource cost information |
| RLS_CONTEXT | Fine-grained access control contexts |
| RLS_CONTEXT | |
| RLS_GROUP | Fine-grained access control policy groups |
| RLS_GROUP | |
| RLS_POLICY | |
| RLS_POLICY | Fine-grained access control policies |
| RLS_POLICY_OBJNUM | |
| RLS_POLICY/RLS_POLICY | Fine-grained access control policies |
| RLS_POLICY/RLS_POLICY | |
| RLS_POLICY/RLS_POLICY_OBJNUM | |
| ROLE | Roles |
| ROLE_GRANT | Role grants to users in the database |
| ROLLBACK_SEGMENT | Rollback segments |
| SCHEMA | |
| SCHEMA | Pre-schema procedural actions and objects and their dependent grants and audits |
| SCHEMA | Database schemas including related and dependent objects |
| SCHEMA/ASSOCIATION | Statistics type associations |
| SCHEMA_CALLOUT | Schema callouts in the selected schemas |
| SCHEMA_CALLOUT | |
| SCHEMA/CLUSTER | Clusters and their indexes |
| SCHEMA/CLUSTER/CLUSTER | |
| SCHEMA/CLUSTER/INDEX | |
| SCHEMA/DB_LINK | Private and public database links |
| SCHEMA/DEFAULT_ROLE | Default roles granted to users in the database |
| SCHEMA/DIMENSION | Dimensions |
| SCHEMA/DVPS_STAGING_REALM_MEMBERSHIP | Database Vault Import Staging Realm Membership |
| SCHEMA/EVENT | |
| SCHEMA/EVENT/TRIGGER | |
| SCHEMA/FUNCTION | Functions and their dependent grants and audits |
| SCHEMA/FUNCTION | |
| SCHEMA/FUNCTION/ALTER_FUNCTION | Recompile functions |
| SCHEMA/FUNCTION/AUDIT_OBJ | |
| SCHEMA/FUNCTION/FUNCTION | |
| SCHEMA/FUNCTION/GRANT | |
| SCHEMA/FUNCTION/GRANT/CROSS_SCHEMA | |
| SCHEMA/FUNCTION/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| SCHEMA/FUNCTION/GRANT/OWNER_GRANT | |
| SCHEMA/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| SCHEMA/FUNCTION/GRANT/WITH_GRANT_OPTION | |
| SCHEMA/FUNCTION/GRANT/WITH_GRANT_OPTION/OBJECT_GRA | |
| SCHEMA/GRANT | |
| SCHEMA/GRANT/PROCOBJ_GRANT | Schema procedural object grants in the selected schemas |
| SCHEMA/GRANT/SYSTEM_GRANT | |
| SCHEMA/INDEXTYPE | Indextypes and their dependent grants and audits |
| SCHEMA/INDEXTYPE/AUDIT_OBJ | |
| SCHEMA/INDEXTYPE/COMMENT | |
| SCHEMA/INDEXTYPE/GRANT | |
| SCHEMA/INDEXTYPE/GRANT/CROSS_SCHEMA | |
| SCHEMA/INDEXTYPE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| SCHEMA/INDEXTYPE/GRANT/OWNER_GRANT | |
| SCHEMA/INDEXTYPE/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| SCHEMA/INDEXTYPE/GRANT/WITH_GRANT_OPTION | |
| SCHEMA/INDEXTYPE/GRANT/WITH_GRANT_OPTION/OBJECT_GR | |
| SCHEMA/INDEXTYPE/INDEXTYPE | |
| SCHEMA/JAVA_CLASS | Java classes and their dependent grants and audits |
| SCHEMA/JAVA_CLASS/AUDIT_OBJ | |
| SCHEMA/JAVA_CLASS/GRANT | |
| SCHEMA/JAVA_CLASS/GRANT/CROSS_SCHEMA | |
| SCHEMA/JAVA_CLASS/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| SCHEMA/JAVA_CLASS/GRANT/OWNER_GRANT | |
| SCHEMA/JAVA_CLASS/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| SCHEMA/JAVA_CLASS/GRANT/WITH_GRANT_OPTION | |
| SCHEMA/JAVA_CLASS/GRANT/WITH_GRANT_OPTION/OBJECT_G | |
| SCHEMA/JAVA_CLASS/JAVA_CLASS | |
| SCHEMA/JAVA_OBJNUM | |
| SCHEMA/JAVA_RESOURCE | Java resources and their dependent grants and audits |
| SCHEMA/JAVA_RESOURCE/AUDIT_OBJ | |
| SCHEMA/JAVA_RESOURCE/GRANT | |
| SCHEMA/JAVA_RESOURCE/GRANT/CROSS_SCHEMA | |
| SCHEMA/JAVA_RESOURCE/GRANT/CROSS_SCHEMA/OBJECT_GRA | |
| SCHEMA/JAVA_RESOURCE/GRANT/OWNER_GRANT | |
| SCHEMA/JAVA_RESOURCE/GRANT/OWNER_GRANT/OBJECT_GRAN | |
| SCHEMA/JAVA_RESOURCE/GRANT/WITH_GRANT_OPTION | |
| SCHEMA/JAVA_RESOURCE/GRANT/WITH_GRANT_OPTION/OBJEC | |
| SCHEMA/JAVA_RESOURCE/JAVA_RESOURCE | |
| SCHEMA/JAVA_SOURCE | Java sources and their dependent grants and audits |
| SCHEMA/JAVA_SOURCE/AUDIT_OBJ | |
| SCHEMA/JAVA_SOURCE/GRANT | |
| SCHEMA/JAVA_SOURCE/GRANT/CROSS_SCHEMA | |
| SCHEMA/JAVA_SOURCE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| SCHEMA/JAVA_SOURCE/GRANT/OWNER_GRANT | |
| SCHEMA/JAVA_SOURCE/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| SCHEMA/JAVA_SOURCE/GRANT/WITH_GRANT_OPTION | |
| SCHEMA/JAVA_SOURCE/GRANT/WITH_GRANT_OPTION/OBJECT_ | |
| SCHEMA/JAVA_SOURCE/JAVA_SOURCE | |
| SCHEMA/JOB | Jobs |
| SCHEMA/LIBRARY | External procedure libraries and their dependent grants and audits |
| SCHEMA/LIBRARY/AUDIT_OBJ | |
| SCHEMA/LIBRARY/GRANT | |
| SCHEMA/LIBRARY/GRANT/CROSS_SCHEMA | |
| SCHEMA/LIBRARY/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| SCHEMA/LIBRARY/GRANT/OWNER_GRANT | |
| SCHEMA/LIBRARY/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| SCHEMA/LIBRARY/GRANT/WITH_GRANT_OPTION | |
| SCHEMA/LIBRARY/GRANT/WITH_GRANT_OPTION/OBJECT_GRAN | |
| SCHEMA/LIBRARY/LIBRARY | |
| SCHEMA/MATERIALIZED_VIEW | Materialized views |
| SCHEMA/OPERATOR | Operators and their dependent grants and audits |
| SCHEMA/OPERATOR/AUDIT_OBJ | |
| SCHEMA/OPERATOR/COMMENT | |
| SCHEMA/OPERATOR/GRANT | |
| SCHEMA/OPERATOR/GRANT/CROSS_SCHEMA | |
| SCHEMA/OPERATOR/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| SCHEMA/OPERATOR/GRANT/OWNER_GRANT | |
| SCHEMA/OPERATOR/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| SCHEMA/OPERATOR/GRANT/WITH_GRANT_OPTION | |
| SCHEMA/OPERATOR/GRANT/WITH_GRANT_OPTION/OBJECT_GRA | |
| SCHEMA/OPERATOR/OPERATOR | |
| SCHEMA/PACKAGE | Packages (both specification and body) and their dependent grants and audits |
| SCHEMA/PACKAGE | |
| SCHEMA/PACKAGE/AUDIT_OBJ | |
| SCHEMA/PACKAGE_BODIES | |
| SCHEMA/PACKAGE_BODIES/PACKAGE | |
| SCHEMA/PACKAGE_BODIES/PACKAGE/PACKAGE_BODY | Package bodies |
| SCHEMA/PACKAGE/COMPILE_PACKAGE | |
| SCHEMA/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC | |
| SCHEMA/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_ | Recompile package specifications |
| SCHEMA/PACKAGE/GRANT | |
| SCHEMA/PACKAGE/GRANT/CROSS_SCHEMA | |
| SCHEMA/PACKAGE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| SCHEMA/PACKAGE/GRANT/OWNER_GRANT | |
| SCHEMA/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| SCHEMA/PACKAGE/GRANT/WITH_GRANT_OPTION | |
| SCHEMA/PACKAGE/GRANT/WITH_GRANT_OPTION/OBJECT_GRAN | |
| SCHEMA/PACKAGE/PACKAGE_OBJNUM | |
| SCHEMA/PACKAGE/PACKAGE_SPEC | Package specifications |
| SCHEMA/PASSWORD_HISTORY | Password histories for database users |
| SCHEMA/POST_SCHEMA | Post-schema procedural actions and objects and their dependent grants and audits |
| SCHEMA/POST_SCHEMA/GRANT | |
| SCHEMA/POST_SCHEMA/GRANT/PROCOBJ_GRANT | |
| SCHEMA/POST_SCHEMA/PROCACT_SCHEMA | |
| SCHEMA/POST_SCHEMA/PROCOBJ | |
| SCHEMA/POST_SCHEMA/PROCOBJ_AUDIT | |
| SCHEMA/POST_SCHEMA/SCHEMA_CALLOUT | |
| SCHEMA/PROCACT_SCHEMA | Schema procedural actions in the selected schemas |
| SCHEMA/PROCEDURE | |
| SCHEMA/PROCEDURE | Procedures and their dependent grants and audits |
| SCHEMA/PROCEDURE/ALTER_PROCEDURE | Recompile procedures |
| SCHEMA/PROCEDURE/AUDIT_OBJ | |
| SCHEMA/PROCEDURE/GRANT | |
| SCHEMA/PROCEDURE/GRANT/CROSS_SCHEMA | |
| SCHEMA/PROCEDURE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| SCHEMA/PROCEDURE/GRANT/OWNER_GRANT | |
| SCHEMA/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| SCHEMA/PROCEDURE/GRANT/WITH_GRANT_OPTION | |
| SCHEMA/PROCEDURE/GRANT/WITH_GRANT_OPTION/OBJECT_GR | |
| SCHEMA/PROCEDURE/PROCEDURE | |
| SCHEMA/PROCOBJ | Procedural objects in the selected schemas |
| SCHEMA/PROCOBJ_AUDIT | Schema procedural object audits in the selected schemas |
| SCHEMA/PUBLIC_SYNONYM | |
| SCHEMA/PUBLIC_SYNONYM/FGA_POLICY | |
| SCHEMA/PUBLIC_SYNONYM/RLS_CONTEXT | |
| SCHEMA/PUBLIC_SYNONYM/RLS_GROUP | |
| SCHEMA/PUBLIC_SYNONYM/RLS_POLICY | |
| SCHEMA/PUBLIC_SYNONYM/RLS_POLICY/RLS_POLICY | |
| SCHEMA/PUBLIC_SYNONYM/RLS_POLICY/RLS_POLICY_OBJNUM | |
| SCHEMA/PUBLIC_SYNONYM/SYNONYM | Public and private synonyms |
| SCHEMA/REFRESH_GROUP | Refresh groups |
| SCHEMA/ROLE_GRANT | Role grants to users in the database |
| SCHEMA/SCHEMA_CALLOUT | Schema callouts in the selected schemas |
| SCHEMA/SEQUENCE | Sequences and their dependent grants and audits |
| SCHEMA/SEQUENCE/AUDIT_OBJ | |
| SCHEMA/SEQUENCE/GRANT | |
| SCHEMA/SEQUENCE/GRANT/CROSS_SCHEMA | |
| SCHEMA/SEQUENCE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| SCHEMA/SEQUENCE/GRANT/OWNER_GRANT | |
| SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| SCHEMA/SEQUENCE/GRANT/WITH_GRANT_OPTION | |
| SCHEMA/SEQUENCE/GRANT/WITH_GRANT_OPTION/OBJECT_GRA | |
| SCHEMA/SEQUENCE/SEQUENCE | |
| SCHEMA/SYNONYM | |
| SCHEMA/SYNONYM/FGA_POLICY | |
| SCHEMA/SYNONYM/RLS_CONTEXT | |
| SCHEMA/SYNONYM/RLS_GROUP | |
| SCHEMA/SYNONYM/RLS_POLICY | |
| SCHEMA/SYNONYM/RLS_POLICY/RLS_POLICY | |
| SCHEMA/SYNONYM/RLS_POLICY/RLS_POLICY_OBJNUM | |
| SCHEMA/TABLE | Tables and their dependent objects |
| SCHEMA/TABLE | |
| SCHEMA/TABLE/AUDIT_OBJ | Object audits on the selected tables |
| SCHEMA/TABLE/COMMENT | Table and column comments on the selected tables |
| SCHEMA/TABLE/CONSTRAINT | |
| SCHEMA/TABLE/CONSTRAINT | Constraints (including referential constraints) |
| SCHEMA/TABLE/CONSTRAINT/CONSTRAINT | |
| SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT | Referential constraints |
| SCHEMA/TABLE/DEPTABLE_OBJNUM | |
| SCHEMA/TABLE/FGA_POLICY | Fine-grained auditing policies |
| SCHEMA/TABLE/GRANT | Object grants on the selected tables |
| SCHEMA/TABLE/GRANT/CROSS_SCHEMA | |
| SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| SCHEMA/TABLE/GRANT/OWNER_GRANT | |
| SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT | Object grants on the selected tables |
| SCHEMA/TABLE/GRANT/WITH_GRANT_OPTION | |
| SCHEMA/TABLE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| SCHEMA/TABLE/INDEX | |
| SCHEMA/TABLE/INDEX | Indexes |
| SCHEMA/TABLE/INDEX/BITMAP_INDEX | |
| SCHEMA/TABLE/INDEX/BITMAP_INDEX/INDEX | |
| SCHEMA/TABLE/INDEX/DOMAIN_INDEX | |
| SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX | |
| SCHEMA/TABLE/INDEX/DOMIDX_OBJNUM | |
| SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX | |
| SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX | |
| SCHEMA/TABLE/INDEX/INDEX | |
| SCHEMA/TABLE/INDEX/STATISTICS | |
| SCHEMA/TABLE/INDEX/STATISTICS | Precomputed statistics |
| SCHEMA/TABLE/INDEX/STATISTICS/BITMAP_INDEX | |
| SCHEMA/TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_S | |
| SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX | |
| SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/IND | |
| SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS | |
| SCHEMA/TABLE/INDEX/TABLE | |
| SCHEMA/TABLE/INDEX/TABLE_DATA | |
| SCHEMA/TABLE/INSTANCE_CALLOUT | Instance callouts |
| SCHEMA/TABLE/MATERIALIZED_VIEW_LOG | Materialized view logs |
| SCHEMA/TABLE/NTABLE_OBJNUM | |
| SCHEMA/TABLE/POST_DATA_TABLE | |
| SCHEMA/TABLE/POST_INSTANCE | |
| SCHEMA/TABLE/POST_INSTANCE/GRANT | |
| SCHEMA/TABLE/POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT | Grants on instance procedural objects |
| SCHEMA/TABLE/POST_INSTANCE/INSTANCE_CALLOUT | |
| SCHEMA/TABLE/POST_INSTANCE/PROCACT_INSTANCE | |
| SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ | Instance procedural objects |
| SCHEMA/TABLE/POST_INSTANCE/PROCDEPOBJ_AUDIT | Audits on instance procedural objects |
| SCHEMA/TABLE/POST_TABLE_ACTION | Post-table actions |
| SCHEMA/TABLE/PRE_TABLE_ACTION | Pre-table actions |
| SCHEMA/TABLE/PROCACT_INSTANCE | Instance procedural actions |
| SCHEMA/TABLE/RLS_CONTEXT | Fine-grained access control contexts |
| SCHEMA/TABLE/RLS_GROUP | Fine-grained access control policy groups |
| SCHEMA/TABLE/RLS_POLICY | |
| SCHEMA/TABLE/RLS_POLICY/RLS_POLICY | Fine-grained access control policies |
| SCHEMA/TABLE/RLS_POLICY/RLS_POLICY_OBJNUM | |
| SCHEMA/TABLESPACE_QUOTA | Tablespace quota granted to users in the database |
| SCHEMA/TABLE/STATISTICS | |
| SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS | |
| SCHEMA/TABLE/STATISTICS/USER_PREF_STATISTICS | |
| SCHEMA/TABLE/TABLE | |
| SCHEMA/TABLE/TABLE_DATA | |
| SCHEMA/TABLE/TABLE_OBJNUM | |
| SCHEMA/TABLE/TRIGGER | Triggers |
| SCHEMA/TYPE | Types (both specification and body) and their dependent grants and audits |
| SCHEMA/TYPE | |
| SCHEMA/TYPE/AUDIT_OBJ | |
| SCHEMA/TYPE/GRANT | |
| SCHEMA/TYPE/GRANT/CROSS_SCHEMA | |
| SCHEMA/TYPE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| SCHEMA/TYPE/GRANT/OWNER_GRANT | |
| SCHEMA/TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| SCHEMA/TYPE/GRANT/WITH_GRANT_OPTION | |
| SCHEMA/TYPE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| SCHEMA/TYPE/INC_TYPE | |
| SCHEMA/TYPE/SORT_TYPES | |
| SCHEMA/TYPE/TYPE_BODY | Type bodies |
| SCHEMA/TYPE/TYPE_SPEC | Type specifications |
| SCHEMA/USER | User definitions |
| SCHEMA/VIEW | Views and their dependent objects |
| SCHEMA/VIEW | |
| SCHEMA/VIEW/AUDIT_OBJ | |
| SCHEMA/VIEW/COMMENT | |
| SCHEMA/VIEW/CONSTRAINT | |
| SCHEMA/VIEW/FGA_POLICY | |
| SCHEMA/VIEW/GRANT | |
| SCHEMA/VIEW/GRANT/CROSS_SCHEMA | |
| SCHEMA/VIEW/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| SCHEMA/VIEW/GRANT/OWNER_GRANT | |
| SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| SCHEMA/VIEW/GRANT/WITH_GRANT_OPTION | |
| SCHEMA/VIEW/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| SCHEMA/VIEW/RLS_CONTEXT | |
| SCHEMA/VIEW/RLS_GROUP | |
| SCHEMA/VIEW/RLS_POLICY | |
| SCHEMA/VIEW/RLS_POLICY/RLS_POLICY | Fine-grained access control policies |
| SCHEMA/VIEW/RLS_POLICY/RLS_POLICY_OBJNUM | |
| SCHEMA/VIEW/TRIGGER | |
| SCHEMA/VIEW/VIEW | |
| SCHEMA/VIEW/VIEW_OBJNUM | |
| SCHEMA/XMLSCHEMA | Xmlschemas |
| SCHEMA/XMLSCHEMA/EXP_XMLSCHEMA | |
| SEQUENCE | Sequences and their dependent grants and audits |
| SEQUENCE | |
| SEQUENCE/AUDIT_OBJ | |
| SEQUENCE/GRANT | |
| SEQUENCE/GRANT/CROSS_SCHEMA | |
| SEQUENCE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| SEQUENCE/GRANT/OWNER_GRANT | |
| SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| SEQUENCE/GRANT/WITH_GRANT_OPTION | |
| SEQUENCE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| SEQUENCE/SEQUENCE | |
| SORT_TYPES | |
| STATISTICS | |
| STATISTICS | Precomputed statistics |
| STATISTICS/BITMAP_INDEX | |
| STATISTICS/BITMAP_INDEX/INDEX_STATISTICS | |
| STATISTICS/FUNCTIONAL_INDEX | |
| STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS | |
| STATISTICS/INDEX_STATISTICS | |
| STATISTICS/TABLE_STATISTICS | |
| STATISTICS/USER_PREF_STATISTICS | |
| SYNONYM | Public and private synonyms |
| SYNONYM | |
| SYNONYM/FGA_POLICY | |
| SYNONYM/RLS_CONTEXT | |
| SYNONYM/RLS_GROUP | |
| SYNONYM/RLS_POLICY | |
| SYNONYM/RLS_POLICY/RLS_POLICY | |
| SYNONYM/RLS_POLICY/RLS_POLICY_OBJNUM | |
| SYSTEM_CALLOUT | System callouts |
| SYSTEM_CALLOUT | |
| SYSTEM_GRANT | |
| SYSTEM_GRANT/PROC_SYSTEM_GRANT | Procedural system privilege grants |
| SYSTEM_PROCOBJACT | System procedural actions and objects and their dependent grants and audits |
| SYSTEM_PROCOBJACT/GRANT | |
| SYSTEM_PROCOBJACT/GRANT/PROCOBJ_GRANT | |
| SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS | Post-system procedural actions |
| SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYST | |
| SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS | Pre-system procedural actions |
| SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTE | |
| SYSTEM_PROCOBJACT/PROCOBJ | |
| SYSTEM_PROCOBJACT/PROCOBJ_AUDIT | |
| SYS_USER | |
| SYS_USER/USER | |
| TABLE | |
| TABLE | Tables and their dependent objects |
| TABLE/AUDIT_OBJ | Object audits on the selected tables |
| TABLE/COMMENT | Table and column comments on the selected tables |
| TABLE/CONSTRAINT | |
| TABLE/CONSTRAINT | Constraints (including referential constraints) |
| TABLE/CONSTRAINT/CONSTRAINT | |
| TABLE/CONSTRAINT/REF_CONSTRAINT | Referential constraints |
| TABLE_DATA | |
| TABLE/DEPTABLE_OBJNUM | |
| TABLE/FGA_POLICY | Fine-grained auditing policies |
| TABLE/GRANT | Object grants on the selected tables |
| TABLE/GRANT/CROSS_SCHEMA | |
| TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| TABLE/GRANT/OWNER_GRANT | |
| TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT | Object grants on the selected tables |
| TABLE/GRANT/WITH_GRANT_OPTION | |
| TABLE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| TABLE/INDEX | Indexes |
| TABLE/INDEX | |
| TABLE/INDEX/BITMAP_INDEX | |
| TABLE/INDEX/BITMAP_INDEX/INDEX | |
| TABLE/INDEX/DOMAIN_INDEX | |
| TABLE/INDEX/DOMAIN_INDEX/INDEX | |
| TABLE/INDEX/DOMIDX_OBJNUM | |
| TABLE/INDEX/FUNCTIONAL_INDEX | |
| TABLE/INDEX/FUNCTIONAL_INDEX/INDEX | |
| TABLE/INDEX/INDEX | |
| TABLE/INDEX/STATISTICS | |
| TABLE/INDEX/STATISTICS | Precomputed statistics |
| TABLE/INDEX/STATISTICS/BITMAP_INDEX | |
| TABLE/INDEX/STATISTICS/BITMAP_INDEX/INDEX_STATISTI | |
| TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX | |
| TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STAT | |
| TABLE/INDEX/STATISTICS/INDEX_STATISTICS | |
| TABLE/INDEX/TABLE | |
| TABLE/INDEX/TABLE_DATA | |
| TABLE/INSTANCE_CALLOUT | Instance callouts |
| TABLE/MATERIALIZED_VIEW_LOG | Materialized view logs |
| TABLE/NTABLE_OBJNUM | |
| TABLE_OBJNUM | |
| TABLE/POST_DATA_TABLE | |
| TABLE/POST_INSTANCE | |
| TABLE/POST_INSTANCE/GRANT | |
| TABLE/POST_INSTANCE/GRANT/PROCDEPOBJ_GRANT | Grants on instance procedural objects |
| TABLE/POST_INSTANCE/INSTANCE_CALLOUT | |
| TABLE/POST_INSTANCE/PROCACT_INSTANCE | |
| TABLE/POST_INSTANCE/PROCDEPOBJ | Instance procedural objects |
| TABLE/POST_INSTANCE/PROCDEPOBJ_AUDIT | Audits on instance procedural objects |
| TABLE/POST_TABLE_ACTION | Post-table actions |
| TABLE/PRE_TABLE_ACTION | Pre-table actions |
| TABLE/PROCACT_INSTANCE | Instance procedural actions |
| TABLE/RLS_CONTEXT | Fine-grained access control contexts |
| TABLE/RLS_GROUP | Fine-grained access control policy groups |
| TABLE/RLS_POLICY | |
| TABLE/RLS_POLICY/RLS_POLICY | Fine-grained access control policies |
| TABLE/RLS_POLICY/RLS_POLICY_OBJNUM | |
| TABLESPACE | |
| TABLESPACE | Tablespace definitions |
| TABLESPACE_QUOTA | Tablespace quota granted to users in the database |
| TABLE/STATISTICS | |
| TABLE_STATISTICS | |
| TABLE/STATISTICS/TABLE_STATISTICS | |
| TABLE/STATISTICS/USER_PREF_STATISTICS | |
| TABLE/TABLE | |
| TABLE/TABLE_DATA | |
| TABLE/TABLE_OBJNUM | |
| TABLE/TRIGGER | Triggers |
| TABTYPE_OBJNUM | |
| TRIGGER | |
| TRIGGER | Triggers |
| TRUSTED_DB_LINK | |
| TYPE | Types (both specification and body) and their dependent grants and audits |
| TYPE | |
| TYPE/AUDIT_OBJ | |
| TYPE_BODY | Type bodies |
| TYPE/GRANT | |
| TYPE/GRANT/CROSS_SCHEMA | |
| TYPE/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| TYPE/GRANT/OWNER_GRANT | |
| TYPE/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| TYPE/GRANT/WITH_GRANT_OPTION | |
| TYPE/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| TYPE/INC_TYPE | |
| TYPE/SORT_TYPES | |
| TYPE_SPEC | |
| TYPE_SPEC | Type specifications |
| TYPE/TYPE_BODY | Type bodies |
| TYPE/TYPE_SPEC | Type specifications |
| USER | |
| USER | User definitions |
| USER_PREF_STATISTICS | |
| VAT_OBJNUM | |
| VIEW | Views and their dependent objects |
| VIEW | |
| VIEW/AUDIT_OBJ | |
| VIEW/COMMENT | |
| VIEW/CONSTRAINT | |
| VIEW/FGA_POLICY | |
| VIEW/GRANT | |
| VIEW/GRANT/CROSS_SCHEMA | |
| VIEW/GRANT/CROSS_SCHEMA/OBJECT_GRANT | |
| VIEW/GRANT/OWNER_GRANT | |
| VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT | |
| VIEW/GRANT/WITH_GRANT_OPTION | |
| VIEW/GRANT/WITH_GRANT_OPTION/OBJECT_GRANT | |
| VIEW_OBJNUM | |
| VIEW/RLS_CONTEXT | |
| VIEW/RLS_GROUP | |
| VIEW/RLS_POLICY | |
| VIEW/RLS_POLICY/RLS_POLICY | Fine-grained access control policies |
| VIEW/RLS_POLICY/RLS_POLICY_OBJNUM | |
| VIEWS_AS_TABLES | |
| VIEWS_AS_TABLES/TABLE | |
| VIEWS_AS_TABLES/TABLE_DATA | |
| VIEWS_AS_TABLES/VAT_OBJNUM | |
| VIEW/TRIGGER | |
| VIEW/VIEW | |
| VIEW/VIEW_OBJNUM | |
| WITH_GRANT_OPTION | |
| WITH_GRANT_OPTION/OBJECT_GRANT | |
| XMLSCHEMA | Xmlschemas |
| XMLSCHEMA/EXP_XMLSCHEMA |
Subscribe to:
Posts (Atom)