Pattern Matching Metacharacters For asm

it2022-05-05  55

 

This document will list the possible meta characters for asm_diskstring parameter

 

Solution

* and [] are the two valid meta characters for asm_diskstring parameter.SQL> alter system set asm_diskstring='/dev/raw/raw*' scope=both;System altered.SQL> select path from v$asm_disk;PATH--------------------------------------------------------------------------------/dev/raw/raw1/dev/raw/raw2/dev/raw/raw3/dev/raw/raw4/dev/raw/raw5/dev/raw/raw11/dev/raw/raw12/dev/raw/raw7/dev/raw/raw8/dev/raw/raw9/dev/raw/raw10/dev/raw/raw612 rows selected.SQL> alter system set asm_diskstring='/dev/raw/raw[1-5]' scope=both;System altered.SQL> select path from v$asm_disk order by 1;PATH--------------------------------------------------------------------------------/dev/raw/raw1/dev/raw/raw2/dev/raw/raw3/dev/raw/raw4/dev/raw/raw5Characters like $ [0-9*] ^ _ etc would either give error, or will be ignored.SQL> alter system set asm_diskstring='/dev/raw/raw$' scope=both;alter system set asm_diskstring='/dev/raw/raw$' scope=both*ERROR at line 1:ORA-02097: parameter cannot be modified because specified value is invalidORA-15031: disk specification '/dev/raw/raw$' matches no disksORA-15056: additional error message

 

 

 

 

From Oracle

-------------------------------------------------------------------------------------------------------

Blog http://blog.csdn.net/tianlesoftware

Email: dvd.dba@gmail.com

DBA1 群:62697716();   DBA2 群:62697977()   DBA3 群:62697850()  

DBA 超级群:63306533();  DBA4 群: 83829929  DBA5群: 142216823   

聊天 群:40132017   聊天2群:69087192

--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请

转载于:https://www.cnblogs.com/hibernate315/archive/2011/04/25/2399054.html

相关资源:数据结构—成绩单生成器

最新回复(0)