Skip to Main Content
  • Questions

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

Breadcrumb

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

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

We're not taking comments currently, so please try again later if you want to add a comment.
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 channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.