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

Syntax

proutil db-name -C setdefaultobjectarea area-name [ object-type | all ]

Parameters

db-name
Specifies the database you are updating.
area-name
Specifies the default area for storing tables, indexes, and LOBs. Use a valid Type II area name.

After you provide the default area name, you cannot change the name from the PROUTIL command line. To change the default area name, open the Database Properties page in the Data Dictionary tool, and make the changes from the respective drop-down lists.

object-type
Specifies that all new objects of this type will be stored in the area by default. Valid values are table, index, and LOB.
all
Specifies the area where all new objects are created, if no area is specified.

Notes

  • You can change the default area at any time, whether the database is online or offline.
  • You must specify a Type II area.
  • You cannot use this utility to set default areas for database objects for tenants in multi-tenant databases
  • You cannot set a default area for objects in a schema holder database.
  • You cannot set an encryption area as the default area for object.
  • If a default area is already set for a database object, OpenEdge prompts you to choose between changing or keeping the default.

Sample output

Create large objects in area mylobarea by default:
proutil mydb -C setobjectdefaultarea mylobarea lob