Oracle maintenance program specific resource

ora_default_tablespace / ORA_DEFAULT_TABLESPACE
Ora_maint resource ora_default_tablespace
Environment variable ORA_DEFAULT_TABLESPACE
Type String
Default Not set

Description

If LN adds a new user to the Oracle database, the default tablespace is set to SYSTEM.

When this resource is set, an ALTER USER DEFAULT TABLESPACE <string> command will be issued after the user is created.

ora_temporary_tablespace / ORA_TEMPORARY_TABLESPACE
Ora_maint resource ora_temporary_tablespace
Environment variable ORA_TEMPORARY_TABLESPACE
Type String
Default Not set

Description

If a new user is added to the Oracle database, the default temporary tablespace is set to SYSTEM.

If this resource is set, an ALTER USER TEMPORARY TABLESPACE <string> command will be issued after the user is created.