Purpose
Connects to a database and disables an XML-enabled collection. The collection name can no longer be used in the composition (dxxRetrieveXML) and decomposition (dxxInsertXML) stored procedures. When an XML collection is disabled, the associated collection entry is deleted from the XML_USAGE table. Note that disabling the collection does not drop the collection tables that are created during the enable_collection step.
Format
disable_collection |
---|
>>-dxxadm--disable_collection---db_name---collection_name-------> >-----+------------+---+---------------+----------------------->< '--l--login--' '--p--password--' |
Parameters
Table 19. disable_collection parameters
Parameter | Description |
---|---|
db_name | The name of the database in which the data resides. |
collection_name | The name of the XML collection. |
-l login | The user ID, which is optional, used to connect to the database, when specified. If not specified, the current user ID is used. |
-p password | The password, which is optional, used to connect to the database, when specified. If not specified, the current password is used. |
Examples
The following example disables an XML collection.
dxxadm disable_collection SALES_DB sales_ord