Warnings Options

From DBArtisan
Jump to: navigation, search

Go Up to Configuring Feature Options

You can have warning messages issued to users whenever improper operations are attempted in a database. Warning messages differ by platform. The Options Editor’s Warnings tab lets you select the DBMS-specific events that generate warnings.

Note: For information on opening the Options Editor, see Specifying Application Preferences and Feature Options.

The tables below describes the options of the Warnings tab:

Option Description Platform

Create an index on the same tablespace as the associated table

Issues a warning message whenever a user does not create an index on a different tablespace than the table. This makes it possible for the server to read the index and table data in parallel.

DB2

Create an index on the same tablespace as the associated table

Issues a warning message whenever a user does not create an index on a different tablespace than the table. This makes it possible for the server to read the index and table data in parallel.

Oracle

Create an object in the SYSTEM tablespace

Issues a warning message whenever a user tries to create or place an object on the SYSTEM tablespace.

Oracle

Create a user with default or temp tablespace as the SYSTEM tablespace

Issues a warning message when a user is created with a default or temp tablespace on the SYSTEM tablespace.

Oracle

Create an object in the master database

Issues a warning message when an object is created in the master database.

Microsoft SQL Server and Sybase ASE

Create a table or index on the default segment

Issues a warning message when a table or index is created on the default segment.

Microsoft SQL Server and Sybase ASE

Create a non-clustered index on same segment as the associated table

Issues a warning message when a non-clustered index is created on the same segment as the associated table.

Microsoft SQL Server and Sybase ASE