PRIVATE_TEMP_TABLE_PREFIX

PRIVATE_TEMP_TABLE_PREFIX specifies the prefix that the database uses for private temporary tables.

Property Description
Parameter type String
Syntax

PRIVATE_TEMP_TABLE_PREFIX = string
Default value ORA$PTT_
Modifiable ALTER SYSTEM ... DEFERRED
Modifiable in a PDB Yes
Basic No
Oracle RAC The same value must be specified on each instance.

The default value used for the PRIVATE_TEMP_TABLE_PREFIX parameter is ORA$PTT_.

If you choose to specify a different prefix value, it must begin with the string ORA$ and must be unique across the database. Use the following SQL query to determine if the prefix value is unique (in the query, replace prefix-value with your actual prefix value):

select count(*) from obj$ where name like '<prefix-value>%';

If the above query returns 0, then the prefix you specified is an appropriate value to set.

Note: After setting the prefix, regular table, view, and object names cannot use the same prefix.

See Also: