Home » Other » General » Automatic Storage Management (ASM) auto create datafile (Oracle Database 12c Enterprise Edition Release - 64bit Production)
Automatic Storage Management (ASM) auto create datafile [message #672664] Mon, 22 October 2018 10:06 Go to next message
Messages: 345
Registered: March 2005
Senior Member
just want to get a quick understanding of the ASM. i am aware that the Automatic Storage Management (ASM) is somewhat the volume manager and a file system for oracle database files.

there was an error about
ORA-01653: unable to extend table ODI.C$_CMS_EXPEND by 4096 in tablespace ODIDEV

then somehow this was fixed by adding a new datafile for the tablespace ODIDEV. i checked that the datafile has this naming convention in number format.


i was wondering if the ASM automatically created the datafile. just want to know if the ASM can and has the functionality to automatically create the datafile.

thank you,

[Updated on: Mon, 22 October 2018 10:14]

Report message to a moderator

Re: Automatic Storage Management (ASM) auto create datafile [message #672667 is a reply to message #672664] Mon, 22 October 2018 10:23 Go to previous message
John Watson
Messages: 8580
Registered: January 2010
Location: Global Village
Senior Member
No, ASM will never create a file automatically. Either someone added the file, or perhaps you have some maintenance jpb configured to detect and fix tablespace full issues.
Previous Topic: Problem with timezone date (merged)
Next Topic: Redo Log Buffer Quick Question
Goto Forum:

Current Time: Fri Jul 30 05:20:55 CDT 2021