PDB CDB 的相关操作 SQLPLUS

参考文档：

https://docs.oracle.com/database/122/ADMIN/viewing-information-about-cdbs-and-pdbs-with-sql-plus.htm#ADMIN13978

Table 45-2 Views for a CDB
container data objects ,including :v$ views ,GV$views ,CDB_views,DBA_HIST* views

cdb_pdbs;CDB_PROPERTIES;{CDB|DBA}_PDB_HISTORY;{CDB|DBA}_CONTAINER_DATA;{CDB|DBA}_HIST_PDB_INSTANCE;{CDB|DBA}_PDB_SAVED_STATES{CDB|DBA}_APPLICATIONS;{CDB|DBA}_APP_STATEMENTS;{CDB|DBA}_APP_PATCHES;{CDB|DBA}_APP_ERRORS;{CDB|DBA}_CDB_RSRC_PLANS;{CDB|DBA}_CDB_RSRC_PLAN_DIRECTIVES;PDB_ALERTS;PDB_PLUG_IN_VIOLATIONS;{USER|ALL|DBA|CDB}_OBJECTS;{ALL|DBA|CDB}_SERVICES;{USER|ALL|DBA|CDB}_VIEWS{USER|ALL|DBA|CDB}_TABLES{USER|ALL|DBA|CDB}_USERS{USER|ALL|DBA|CDB}_ROLES{USER|ALL|DBA|CDB}_COL_PRIVS{USER|ALL}_COL_PRIVS_MADE{USER|ALL}_COL_PRIVS_RECD{USER|ALL}_TAB_PRIVS_MADE{USER|ALL}_TAB_PRIVS_RECD{USER|DBA|CDB}_SYS_PRIVS{USER|DBA|CDB}_ROLE_PRIVSROLE_TAB_PRIVSROLE_SYS_PRIVS{USER|ALL|DBA|CDB}_ARGUMENTS{USER|ALL|DBA|CDB}_CLUSTERS{USER|ALL|DBA|CDB}_CONSTRAINTS{ALL|DBA|CDB}_DIRECTORIES{USER|ALL|DBA|CDB}_IDENTIFIERS{USER|ALL|DBA|CDB}_LIBRARIES{USER|ALL|DBA|CDB}_PROCEDURES{USER|ALL|DBA|CDB}_SOURCE{USER|ALL|DBA|CDB}_SYNONYMS{USER|ALL|DBA|CDB}_VIEWS[G]V$DATABASE[G]V$CONTAINERS[G]V$PDBS[G]V$PDB_INCARNATION[G]V$SYSTEM_PARAMETER[G]V$PARAMETERV$DIAG_ALERT_EXT[G]V$DIAG_APP_TRACE_FILE[G]V$DIAG_OPT_TRACE_RECORDSV$DIAG_SESS_OPT_TRACE_RECORDSV$DIAG_SESS_SQL_TRACE_RECORDS[G]V$DIAG_SQL_TRACE_RECORDS[G]V$DIAG_TRACE_FILE[G]V$DIAG_TRACE_FILE_CONTENTSV$DIAG_INCIDENTV$DIAG_PROBLEM

45.5 Determining Whether a Database Is a CDB

SYS@orcl12c>SELECT CDB FROM V$DATABASE;CDB---YESSYS@orcl12c>show con_nameCON_NAME------------------------------CDB$ROOTSYS@orcl12c>alter session set container=PDB1;Session altered.SYS@orcl12c>SELECT CDB FROM V$DATABASE;CDB---YESSYS@orcl12c>

 Example 45-2 Viewing Identifying Information About Each Container in a CDB

SYS@orcl12c>SYS@orcl12c>COLUMN NAME FORMAT A8SYS@orcl12c>SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;NAME     CON_ID  DBID  CON_UID GUID-------- ---------- ---------- ---------- --------------------------------PDB1  3 2998541882 2998541882 5DFCA38B55353589E0536402A8C06BC4SYS@orcl12c>conn / as sysdbaConnected.SYS@orcl12c>SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;NAME     CON_ID  DBID  CON_UID GUID-------- ---------- ---------- ---------- --------------------------------CDB$ROOT  1  7894382191 4700A987085A3DFAE05387E5E50A8C7BPDB$SEED  2 1979779187 1979779187 5CED94E6BCC92D72E0536402A8C02C42PDB1  3 2998541882 2998541882 5DFCA38B55353589E0536402A8C06BC4PDB2  4  496017452496017452 5DFCCCC54B0937B2E0536402A8C00BCAPDB3  5 1679368429 1679368429 5DFCDB2D006B3900E0536402A8C09081SYS@orcl12c>

Example 45-3 Viewing Container ID, Name, and Status of Each PDB

SYS@orcl12c>COLUMN PDB_NAME FORMAT A15SYS@orcl12c>SELECT PDB_ID, PDB_NAME, STATUS FROM DBA_PDBS ORDER BY PDB_ID;    PDB_ID PDB_NAME   STATUS---------- --------------- ---------- 2 PDB$SEED   NORMAL 3 PDB1    NORMAL 4 PDB2    NORMAL 5 PDB3    NORMALSYS@orcl12c>

45.8 Viewing the Open Mode of Each PDB

SYS@orcl12c>SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM V$PDBS;NAMEOPEN_MODE  RESTRICTED OPEN_TIME--------------- ---------- ---------- ----------------------------------------PDB$SEEDREAD ONLY  NO      17-NOV-17 08.57.42.989 AM +08:00PDB1MOUNTEDPDB2READ WRITE NO      17-NOV-17 10.43.04.089 AM +08:00PDB3MOUNTEDSYS@orcl12c>

Example 45-5 Showing the Tables Owned by Specific Schemas in Multiple PDBs

Example 45-6 Showing the Users in Multiple PDBs

SELECT p.PDB_ID, p.PDB_NAME, t.OWNER, t.TABLE_NAME   FROM DBA_PDBS p, CDB_TABLES t   WHERE p.PDB_ID > 2 AND        t.OWNER IN('HR','OE') AND        p.PDB_ID = t.CON_ID  6    ORDER BY p.PDB_ID;no rows selectedSYS@orcl12c>show con_nameCON_NAME------------------------------CDB$ROOTSYS@orcl12c>SYS@orcl12c>COLUMN PDB_NAME FORMAT A15SYS@orcl12c>COLUMN USERNAME FORMAT A30SYS@orcl12c>SYS@orcl12c>SYS@orcl12c>SYS@orcl12c>SELECT p.PDB_ID, p.PDB_NAME, u.USERNAME   FROM DBA_PDBS p, CDB_USERS u  WHERE p.PDB_ID > 2 AND        p.PDB_ID = u.CON_ID  5    ORDER BY p.PDB_ID;    PDB_ID PDB_NAME   USERNAME---------- --------------- ------------------------------ 4 PDB2    SYS 4 PDB2    OJVMSYS 4 PDB2    OUTLN 4 PDB2    LBACSYS 4 PDB2    XS$NULL 4 PDB2    SI_INFORMTN_SCHEMA 4 PDB2    GGSYS 4 PDB2    ORDDATA 4 PDB2    OLAPSYS 4 PDB2    ANONYMOUS 4 PDB2    ORDSYS    PDB_ID PDB_NAME   USERNAME---------- --------------- ------------------------------ 4 PDB2    DVF 4 PDB2    DBSNMP 4 PDB2    GSMADMIN_INTERNAL 4 PDB2    MDSYS 4 PDB2    XDB 4 PDB2    WMSYS 4 PDB2    CTXSYS 4 PDB2    DBSFWUSER 4 PDB2    ORDPLUGINS 4 PDB2    DVSYS 4 PDB2    APPQOSSYS    PDB_ID PDB_NAME   USERNAME---------- --------------- ------------------------------ 4 PDB2    GSMUSER 4 PDB2    MDDATA 4 PDB2    PDB2 4 PDB2    SYSDG 4 PDB2    SYSKM 4 PDB2    ORACLE_OCM 4 PDB2    GSMCATUSER 4 PDB2    SPATIAL_CSW_ADMIN_USR 4 PDB2    REMOTE_SCHEDULER_AGENT 4 PDB2    SYS$UMF 4 PDB2    SYSBACKUP    PDB_ID PDB_NAME   USERNAME---------- --------------- ------------------------------ 4 PDB2    C##R_USER 4 PDB2    SYSRAC 4 PDB2    DIP 4 PDB2    AUDSYS 4 PDB2    SYSTEM38 rows selected.SYS@orcl12c>show con_nameCON_NAME------------------------------CDB$ROOTSYS@orcl12c>show pdbs    CON_ID CON_NAME  OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED  READ ONLY  NO 3 PDB1   MOUNTED 4 PDB2   READ WRITE NO 5 PDB3   MOUNTEDSYS@orcl12c>alter pluggable database pdb3 open;Pluggable database altered.SELECT p.PDB_ID, p.PDB_NAME, u.USERNAME   FROM DBA_PDBS p, CDB_USERS u  WHERE p.PDB_ID > 2 AND        p.PDB_ID = u.CON_ID  5    ORDER BY p.PDB_ID;    PDB_ID PDB_NAME   USERNAME---------- --------------- ------------------------------ 4 PDB2    SYS 4 PDB2    OJVMSYS 4 PDB2    OUTLN 4 PDB2    LBACSYS 4 PDB2    XS$NULL 4 PDB2    SI_INFORMTN_SCHEMA 4 PDB2    GGSYS 4 PDB2    ORDDATA 4 PDB2    OLAPSYS 4 PDB2    ANONYMOUS 4 PDB2    ORDSYS    PDB_ID PDB_NAME   USERNAME---------- --------------- ------------------------------ 4 PDB2    DVF 4 PDB2    DBSNMP 4 PDB2    GSMADMIN_INTERNAL 4 PDB2    MDSYS 4 PDB2    XDB 4 PDB2    WMSYS 4 PDB2    CTXSYS 4 PDB2    DBSFWUSER 4 PDB2    ORDPLUGINS 4 PDB2    DVSYS 4 PDB2    APPQOSSYS    PDB_ID PDB_NAME   USERNAME---------- --------------- ------------------------------ 4 PDB2    GSMUSER 4 PDB2    MDDATA 4 PDB2    PDB2 4 PDB2    SYSDG 4 PDB2    SYSKM 4 PDB2    ORACLE_OCM 4 PDB2    GSMCATUSER 4 PDB2    SPATIAL_CSW_ADMIN_USR 4 PDB2    REMOTE_SCHEDULER_AGENT 4 PDB2    SYS$UMF 4 PDB2    SYSBACKUP    PDB_ID PDB_NAME   USERNAME---------- --------------- ------------------------------ 4 PDB2    C##R_USER 4 PDB2    SYSRAC 4 PDB2    DIP 4 PDB2    AUDSYS 4 PDB2    SYSTEM 5 PDB3    SYS 5 PDB3    OJVMSYS 5 PDB3    OUTLN 5 PDB3    LBACSYS 5 PDB3    XS$NULL 5 PDB3    SI_INFORMTN_SCHEMA    PDB_ID PDB_NAME   USERNAME---------- --------------- ------------------------------ 5 PDB3    GGSYS 5 PDB3    ORDDATA 5 PDB3    OLAPSYS 5 PDB3    ANONYMOUS 5 PDB3    ORDSYS 5 PDB3    DVF 5 PDB3    DBSNMP 5 PDB3    GSMADMIN_INTERNAL 5 PDB3    MDSYS 5 PDB3    XDB 5 PDB3    WMSYS    PDB_ID PDB_NAME   USERNAME---------- --------------- ------------------------------ 5 PDB3    CTXSYS 5 PDB3    DBSFWUSER 5 PDB3    ORDPLUGINS 5 PDB3    DVSYS 5 PDB3    APPQOSSYS 5 PDB3    GSMUSER 5 PDB3    MDDATA 5 PDB3    SYSDG 5 PDB3    SYSKM 5 PDB3    ORACLE_OCM 5 PDB3    GSMCATUSER    PDB_ID PDB_NAME   USERNAME---------- --------------- ------------------------------ 5 PDB3    SPATIAL_CSW_ADMIN_USR 5 PDB3    PDB3 5 PDB3    REMOTE_SCHEDULER_AGENT 5 PDB3    SYS$UMF 5 PDB3    SYSBACKUP 5 PDB3    C##R_USER 5 PDB3    SYSRAC 5 PDB3    DIP 5 PDB3    AUDSYS 5 PDB3    SYSTEM76 rows selected.

Example 45-7 Showing the Data Files for Each PDB in a CDB

SELECT p.PDB_ID, p.PDB_NAME, d.FILE_ID, d.TABLESPACE_NAME, d.FILE_NAME  FROM DBA_PDBS p, CDB_DATA_FILES d  WHERE p.PDB_ID = d.CON_ID  4    ORDER BY p.PDB_ID;PDB_ID PDB_NAME FILE_ID TABLESPACE FILE_NAME------ -------- ------- ---------- ---------------------------------------------     4 PDB2     40 SYSTEM   /u01/app/oracle12/oradata12/orcl12c/PDB2/system01.dbf     4 PDB2     41 SYSAUX   /u01/app/oracle12/oradata12/orcl12c/PDB2/sysaux01.dbf     4 PDB2     50 PDB2_TEST  /u01/app/oracle12/oradata12/orcl12c/PDB2/test   01.dbf     4 PDB2     43 USERS   /u01/app/oracle12/oradata12/orcl12c/PDB2/user   s01.dbf     4 PDB2     42 UNDOTBS1   /u01/app/oracle12/oradata12/orcl12c/PDB2/undo   tbs01.dbf     5 PDB3     44 SYSTEM   /u01/app/oracle12/oradata12/orcl12c/PDB3/syst   em01.dbf     5 PDB3     45 SYSAUX   /u01/app/oracle12/oradata12/orcl12c/PDB3/sysa   ux01.dbf     5 PDB3     51 PDB3_TEST  /u01/app/oracle12/oradata12/orcl12c/PDB3/test   01.dbf     5 PDB3     47 USERS   /u01/app/oracle12/oradata12/orcl12c/PDB3/user   s01.dbf     5 PDB3     46 UNDOTBS1   /u01/app/oracle12/oradata12/orcl12c/PDB3/undo   tbs01.dbf10 rows selected.

Example 45-8 Showing the Temp Files in a CDB

SELECT CON_ID, FILE_ID, TABLESPACE_NAME, FILE_NAME  FROM CDB_TEMP_FILES  3    ORDER BY CON_ID;CON_ID FILE_ID TABLESPACE_NAME FILE_NAME------ ------- --------------- ---------------------------------------------     1     1 TEMP       /u01/app/oracle12/oradata12/orcl12c/temp01.db       f     4     4 TEMP       /u01/app/oracle12/oradata12/orcl12c/PDB2/temp       012017-11-01_22-21-03-085-PM.dbf     5     5 TEMP       /u01/app/oracle12/oradata12/orcl12c/PDB3/temp       012017-11-01_22-21-03-085-PM.dbfSYS@orcl12c>SELECT CON_ID, FILE_ID, TABLESPACE_NAME, FILE_NAME  2    FROM CDB_TEMP_FILES  3    ORDER BY CON_ID;CON_ID FILE_ID TABLESPACE_NAME FILE_NAME------ ------- --------------- ---------------------------------------------     1     1 TEMP       /u01/app/oracle12/oradata12/orcl12c/temp01.db       f     3     3 TEMP       /u01/app/oracle12/oradata12/orcl12c/PDB1/temp       012017-11-01_22-21-03-085-PM.dbf     4     4 TEMP       /u01/app/oracle12/oradata12/orcl12c/PDB2/temp       012017-11-01_22-21-03-085-PM.dbf     5     5 TEMP       /u01/app/oracle12/oradata12/orcl12c/PDB3/temp       012017-11-01_22-21-03-085-PM.dbf

Example 45-9 Showing the Services Associated with PDBs

SELECT PDB, NAME,NETWORK_NAME, CON_ID FROM CDB_SERVICES  WHERE PDB IS NOT NULL AND        CON_ID > 2  4    ORDER BY PDB;PDBNAMENETWORK_NAME       CON_ID--------------- --------------- ------------------------------ ------PDB1pdb1pdb1    3PDB2pdb2pdb2    4PDB3pdb3pdb3    5

Table 45-3 Functions That Return the Container ID of a Container

CON_NAME_TO_ID('container_name')SYS@orcl12c>select con_name_to_id('PDB1') from dual;CON_NAME_TO_ID('PDB1')----------------------     3SYS@orcl12c>select con_name_to_id('PDB2') from dual;CON_NAME_TO_ID('PDB2')----------------------     4CON_DBID_TO_ID(container_dbid)SYS@orcl12c>select dbid from v$database;      DBID---------- 789438219SYS@orcl12c>select con_dbid_to_id('789438219') from dual;CON_DBID_TO_ID('789438219')---------------------------  1CON_UID_TO_ID(container_uid)SYS@orcl12c>select dbid,con_uid,guid from v$containers;      DBID    CON_UID GUID---------- ---------- --------------------------------2998541882 2998541882 5DFCA38B55353589E0536402A8C06BC4SYS@orcl12c>select con_uid_to_id('2998541882') from dual;CON_UID_TO_ID('2998541882')---------------------------  3SYS@orcl12c>show pdbs    CON_ID CON_NAME  OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ---------- 3 PDB1   MOUNTEDSYS@orcl12c>CON_GUID_TO_ID(container_guid)SYS@orcl12c>select con_guid_to_id('5DFCA38B55353589E0536402A8C06BC4') from dual;CON_GUID_TO_ID('5DFCA38B55353589E0536402A8C06BC4')-------------------------------------------------- 3SYS@orcl12c>

-- pdb中查询可修改的参数
SELECT NAME FROM V$SYSTEM_PARAMETER
  WHERE ISPDB_MODIFIABLE = 'TRUE'
  ORDER BY NAME;
If an initialization parameter listed by this query is not set independently for a PDB, then the PDB inherits the parameter value of the root.
--
--45.13 Viewing the History of PDBs
COLUMN DB_NAME FORMAT A10
COLUMN CON_ID FORMAT 999
COLUMN PDB_NAME FORMAT A15
COLUMN OPERATION FORMAT A16
COLUMN OP_TIMESTAMP FORMAT A10
COLUMN CLONED_FROM_PDB_NAME FORMAT A15
 
SELECT DB_NAME, CON_ID, PDB_NAME, OPERATION, OP_TIMESTAMP, CLONED_FROM_PDB_NAME
  FROM CDB_PDB_HISTORY
  WHERE CON_ID > 2
  ORDER BY CON_ID;


SELECT DB_NAME, CON_ID, PDB_NAME, OPERATION, OP_TIMESTAMP, CLONED_FROM_PDB_NAME
  2    FROM CDB_PDB_HISTORY;

DB_NAME    CON_ID PDB_NAME      OPERATION       OP_TIMESTA CLONED_FROM_PDB
---------- ------ --------------- ---------------- ---------- ---------------
SEEDDATA    1 PDB$SEED      UNPLUG       26-JAN-17
SEEDDATA    1 PDB$SEED      DROP           26-JAN-17
ORCL12C     1 PDB$SEED      PLUG           01-NOV-17  PDB$SEED
ORCL12C     1 ORCL12CPDB      CREATE       01-NOV-17  PDB$SEED
ORCL12C     1 ORCL12CPDB      DROP           11-NOV-17
ORCL12C     1 PDB_PLUGGED      PLUG           11-NOV-17  PDB_PLUGGED
ORCL12C     1 APP_CON1      CREATE       12-NOV-17  PDB$SEED
ORCL12C     1 APP_CON1$SEED   CREATE       12-NOV-17  PDB$SEED
ORCL12C     1 APP_CON1$SEED   DROP           12-NOV-17
ORCL12C     1 APP_CON1$SEED   CLONE        12-NOV-17  PDB_PLUGGED
ORCL12C     1 APP_CON1$SEED   DROP           12-NOV-17

DB_NAME    CON_ID PDB_NAME      OPERATION       OP_TIMESTA CLONED_FROM_PDB
---------- ------ --------------- ---------------- ---------- ---------------
ORCL12C     1 APP_CON1$SEED   CLONE        12-NOV-17  APP_CON1
ORCL12C     1 APP_CON_PDB      CLONE        12-NOV-17  APP_CON1
ORCL12C     1 APP_CON_PDB      DROP           15-NOV-17
ORCL12C     1 PDB_PLUGGED      DROP           15-NOV-17
ORCL12C     1 APP_CON1$SEED   DROP           15-NOV-17
ORCL12C     1 APP_CON1      DROP           15-NOV-17
ORCL12C     1 PDB1          CREATE       15-NOV-17  PDB$SEED
ORCL12C     1 PDB2          CREATE       15-NOV-17  PDB$SEED
ORCL12C     1 PDB3          CREATE       15-NOV-17  PDB$SEED

20 rows selected.

--Example 45-16 Viewing Details About the Applications in an Application Container
COLUMN APP_NAME FORMAT A15
COLUMN APP_VERSOIN FORMAT A15
COLUMN APP_STATUS FORMAT A15
 
SELECT APP_NAME, APP_VERSION, APP_STATUS
  FROM DBA_APPLICATIONS
  WHERE APP_IMPLICIT='N';

SYS@orcl12c>
SELECT APP_NAME, APP_VERSION, APP_STATUS
  2    FROM DBA_APPLICATIONS
  3    WHERE APP_IMPLICIT='N';

no rows selected

SELECT APP_NAME, APP_VERSION, APP_STATUS
  2    FROM DBA_APPLICATIONS;

APP_NAME    APP_VERSION               APP_STATUS
--------------- ------------------------------ ---------------
APP$CDB$SYSTEM    1.0                   NORMAL

SYS@orcl12c>


--Example 45-17 Viewing Information About Application Status
COLUMN PDB_NAME FORMAT A15
COLUMN APP_NAME FORMAT A15
COLUMN APP_VERSION FORMAT A20
COLUMN APP_STATUS FORMAT A12
 
SELECT p.PDB_NAME, s.APP_NAME, s.APP_VERSION, s.APP_STATUS
  FROM DBA_PDBS p, DBA_APP_PDB_STATUS s
  WHERE p.CON_UID = s.CON_UID;


--Example 45-18 Viewing Information About Application Statements
SET LONG  8000
SET PAGES 8000
COLUMN STATEMENT_ID FORMAT NNNNN
COLUMN CAPTURE_TIME FORMAT A12
COLUMN APP_STATEMENT FORMAT A36
COLUMN APP_NAME FORMAT A15
 
SELECT STATEMENT_ID, CAPTURE_TIME, APP_STATEMENT, APP_NAME
  FROM DBA_APP_STATEMENTS
  ORDER BY STATEMENT_ID;

/*
SELECT STATEMENT_ID, CAPTURE_TIME, APP_STATEMENT, APP_NAME
  FROM DBA_APP_STATEMENTS
  3    ORDER BY STATEMENT_ID;

STATEMENT_ID CAPTURE_TIME APP_STATEMENT                APP_NAME
------------ ------------ ------------------------------------ ---------------
       1 26-JAN-17      SYS                       APP$CDB$SYSTEM
       2 26-JAN-17      alter pluggable database application APP$CDB$SYSTEM
               APP$CDB$SYSTEM begin install '1.0'

       3 26-JAN-17      alter pluggable database application APP$CDB$SYSTEM
               APP$CDB$SYSTEM end    install '1.0'


SYS@orcl12c>

*/

--Example 45-19 Viewing Information About Application Versions
COLUMN APP_NAME FORMAT A15
COLUMN APP_VERSION FORMAT A20
COLUMN APP_VERSION_COMMENT FORMAT A25
 
SELECT APP_NAME, APP_VERSION, APP_VERSION_COMMENT
  FROM DBA_APP_VERSIONS;

/*
SYS@orcl12c>
SELECT APP_NAME, APP_VERSION, APP_VERSION_COMMENT
  2    FROM DBA_APP_VERSIONS;

APP_NAME    APP_VERSION         APP_VERSION_COMMENT
--------------- -------------------- -------------------------
APP$CDB$SYSTEM    1.0

SYS@orcl12c>

*/

--Example 45-20 Viewing Information About Application Patches
COLUMN APP_NAME FORMAT A15
COLUMN PATCH_NUMBER FORMAT NNNNNNNN
COLUMN PATCH_MIN_VERSION FORMAT A10
COLUMN PATCH_STATUS FORMAT A15
 
SELECT APP_NAME, PATCH_NUMBER, PATCH_MIN_VERSION, PATCH_STATUS
  FROM DBA_APP_PATCHES;

--Example 45-21 Viewing Details About Errors Raised During Application Synchronization

SET LONG  8000
SET PAGES 8000
COLUMN APP_NAME FORMAT A15
COLUMN APP_STATEMENT FORMAT A36
COLUMN ERRORNUM FORMAT NNNNNNNN
COLUMN ERRORMSG FORMAT A20

SELECT APP_NAME, APP_STATEMENT, ERRORNUM, ERRORMSG
  FROM DBA_APP_ERRORS;


--Example 45-22 Listing the User-Created Shared Database Objects in an Application Container
COLUMN OWNER FORMAT A15
COLUMN OBJECT_NAME FORMAT A25
COLUMN SHARING FORMAT A13

SELECT OWNER, OBJECT_NAME, SHARING
   FROM DBA_OBJECTS WHERE SHARING != 'NONE'
   AND ORACLE_MAINTAINED = 'N';


--Example 45-23 Listing the Extended Data-Linked Tables in an Application Container
COLUMN OWNER FORMAT A20
COLUMN TABLE_NAME FORMAT A30
 
SELECT OWNER, TABLE_NAME FROM DBA_TABLES WHERE EXTENDED_DATA_LINK='YES';