Show the default metaschema area for the creation of new LOBs, tables, and indexes.

Syntax

proutil db-name -C dispdefaultobjectarea [ object-type | all ]

Parameters

db-name
Specifies the database where the objects reside.
object-type
Reports on the assigned storage area for objects of this type. Valid values are table, index, and LOB.
all
Specifies that the assigned storage area for all objects will be reported.

Notes

  • You must specify a Type II area.
  • You cannot use this utility to query default areas for database objects for tenants in multi-tenant databases.

Sample output

Show the default area for tables:
proutil mydb -C dispobjectdefaultarea tables

Area Name	Area Number	Object Type
------------------------------------------------------------
Customer Data	8		Tables
Show the default area for all objects: 
proutil mydb -C dispobjectdefaultarea all

Area Name		Area Number	Object Type
------------------------------------------------------------------------
Customer Data		8		Tables
Customer Indexes	9		Indexes
Customer LOBs	       10	        LOBs