Skip to Main Content
  • Questions

  • Datafile name seems to have numbers and decimals - how does Oracle assign them?

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Ebrahim.

Asked: May 21, 2024 - 10:24 pm UTC

Last updated: May 23, 2024 - 2:50 am UTC

Version: 19c

Viewed 1000+ times

You Asked

Dear Tom,

I am temporarily supporting a RAC, ASM database on 19c.
I have to create a new tablespace.
For the existing tablespaces I see that datafile names look like +IPAG_DATA/t5cnp1db/datafile/avos_dat.362.1067066741

I understand that +IPAG_DATA is the asm diskgroup name.
t5cnp1db is database sid and avos_dat stands for the AVOS application whose data resides on this tablespace/datafile.
What are the numbers 362 and 1067066741 ?

for the new tablespace, I want to follow the same pattern, I can use my datafile name as
+IPAG_DATA/t5cnp1db/datafile/odi_dat
but how to get those numbers on my new datafile?

Thank you for your help!

and Connor said...

There are Oracle managed files hence the name is generated.

Thus you would simply do:

create tablespace my_new_tablespace;

and the file name is taken care of for you.

Details here:

https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/using-oracle-managed-files.html#GUID-B0F00D0C-6C82-44B6-9484-61E2564E43FC
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.