Set Default
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
- ORCL 10g ^
To Set a Tablespace as the Default
- Initiate a Set Default action against a tablespace. For more information see Initiating an object operation.
- 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. | |
Dependencies |
Review the referring and referred objects that will be automatically resolved when you execute this operation. For more information, see Dependencies. | |
Preview |
Preview the DDL generated for the operation. For more information, see Preview. |