Managing XML DB Storage
In Oracle XML DB, you need to manage the registered XML schemas, XMLType tables, and XMLType views. All of them are listed in the database directories.
| Directory | Description |
| DBA_XML_TABLES | Lists all XMLType tables in the database |
| USER_XML_TABLES | Lists all XMLType tables owned by the current user |
| ALL_XML_TABLES | Lists all XMLType tables usable by the current user. |
| DBA_XML_TAB_COLS | Lists all XMLType table columns in the database. |
| USER_XML_TAB_COLS | Lists all XMLType table columns in tables owned by the current user. |
| ALL_XML_TAB_COLS | Lists all XMLType table columns in tables usable by the current user. |
TABLE 12-2. XMLType Tables and Columns
XMLType Tables and Columns
Table 12-2 lists the directories summarizing ...
Get Oracle Database 11g Building Oracle XML DB Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
