Database Administration (MOSC)

MOSC Banner

Temporary tablespace creation datafile has numbers appended

This is Oracle 19.22 Enterprise running on Rocky OS8.9

Creating a new or existing database, i run through a script which gives me the temporary tablespaces i need.

The weird thing is that Oracle will append a trailing digit to the temp data files i create...

Create bigfile local Temporary Tablespace FOR ALL TEMP_TEMP Tempfile '/oracle/oradata/DOCSDEV/data/temp_temp.dbf' Size 100M Autoextend On Next 100M Maxsize 18000M Extent Management Local Uniform Size 1024k;

this creates a data temp file /oracle/oradata/DOCSDEV/data/temp_temp.dbf_1

Where is the '_1' coming from??

Same with another temp file create:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center