Set Default

From RapidSQL
Jump to: navigation, search

Go Up to Available object actions by DBMS

This function lets you set a tablespace as the default tablespace. Users created without a specified default tablespace will be assigned this default tablespace. If no default tablespace is set, users created without a specified tablespace will have their default tablespace set to SYSTEM.

Platform Availability

To Set a Tablespace as the Default

  1. Initiate a Set Default action against a tablespace. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the Set Default wizard:
Step Settings and tasks

Action options

Verify that the panel displays the tablespace to be set as default.


Review the referring and referred objects that will be automatically resolved when you execute this operation. For more information, see Dependencies.


Preview the DDL generated for the operation. For more information, see Preview.