The <tablespaces> database configuration element

The <ora-db-ddl> element in file database-config.xml contains a single occurrence of subelement <tablespaces>. You must provide a <ora-tablespaces> subelement if using the <ora-db-ddl> element. Use this element to map Oracle tablespaces to PolicyCenter logical tablespaces at a global, database level.

The <tablespaces> element has the following syntax. The following code sample shows required attributes in bold font.

<database>
  <upgrade>
    <ora-db-ddl>
      <tablespaces admin="string" index="string" lob="string" op="string" staging="string"
            typelist="string"/>    
    </ora-db-ddl>
  </upgrade>
</database>

The following list describes the attributes that you can configure on the <tablespaces> element.

The following attributes are all required.

admin

Name of a PolicyCenter logical tablespace.

index

Name of a PolicyCenter logical tablespace.

op

Name of a PolicyCenter logical tablespace.

staging

Name of a PolicyCenter logical tablespace.

typelist

Name of a PolicyCenter logical tablespace.

The following attribute is optional.

lob

Name of a PolicyCenter logical tablespace.

The <tablespaces> element does not contain additional subelements.

See also