Database Administration (MOSC)

MOSC Banner

How to rename/move a OMF filename to non-OMF in ASM?

edited May 19, 2017 4:48PM in Database Administration (MOSC) 15 commentsAnswered

I am trying to rename a OMF datafile in ASM to a non-OMF filename in 12.1.0.1 RDBMS

I have done the below but it doesn't seem to be working.  I do not an ASM alias.

col name format a25
col value format a10
select x.ksppinm name, y.kspftctxvl value, y.kspftctxdf isdefault, decode(bitand(y.kspftctxvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE') ismod,
decode(bitand(y.kspftctxvf,2),2,'TRUE','FALSE') isadj from sys.x$ksppi x, sys.x$ksppcv2 y where x.inst_id = userenv('Instance')
and y.inst_id = userenv('Instance') and x.indx+1 = y.kspftctxpn
and x.ksppinm like '%omf%' ;

Tagged:

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