Database Administration (MOSC)

MOSC Banner

Datafiles that start with +DATA vs path and end in .dbf

I'm trying to learn how to "reclaim unused space in datafiles" using this page: https://oracle-base.com/articles/misc/reclaiming-unused-space

When I query the "name" in v$datafile or any other view that has the name of my datafile, my name starts with "+DATA" and does NOT end in ".dbf". The article's name has a valid path and DOES end in ".dbf". When I "ALTER DATABASE DATAFILE" using the name of my datafile, I get an ORA-02236: invalid file name error.

It appears this is ASM, which I know nothing about. I've searched the Interweb all day and am not getting an understanding of this. Any advice for this newbee would be appreciated. I can't ask my DBA, because that would be me.

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