External Tables cannot be created inside ASM diskgroup.
1 ) ASM cannot store external tables in ASM diskgroups since external tables are flat ASCII files which are not a file type supported in ASM, therefore external tables must be allocated on regular filesystem files.
2) The supported ASM files are described in the next manual:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/storeman.htm#i1021337
==> 12 Using Automatic Storage Management
Table 12-8 Oracle File Types and Automatic Storage Management File Type Tags
Description
Automatic Storage Management file_type_tag
Comments
CONTROLFILE
Control files and backup control files
Current
Backup
--
DATAFILE
Datafiles and datafile copies
tsname
Tablespace into which the file is added
ONLINELOG
Online logs
group_group#
--
ARCHIVELOG
Archive logs
thread_thread#_seq_sequence#
--
TEMPFILE
Tempfiles
tsname
Tablespace into which the file is added
BACKUPSET
Datafile and archive log backup pieces; datafile incremental backup pieces
hasspfile_timestamp
hasspfile can take one of two values: s indicates that the backup set includes the spfile; n indicates that the backup set does not include the spfile.
PARAMETERFILE
Persistent parameter files
spfile
DAATAGUARDCONFIG
Data Guard configuration file
db_unique_name
Data Guard tries to use the service provider name if it is set. Otherwise the tag defaults to DRCname.
FLASHBACK
Flashback logs
log_log#
--
CHANGETRACKING
Block change tracking data
ctf
Used during incremental backups
DUMPSET
Data Pump dumpset
user_obj#_file#
Dump set files encode the user name, the job number that created the dump set, and the file number as part of the tag.
XTRANSPORT
Datafile convert
tsname
--
AUTOBACKUP
Automatic backup files
hasspfile_timestamp
hasspfile can take one of two values: s indicates that the backup set includes the spfile; n indicates that the backup set does not include the spfile.
-------------------------------------------------------------------------------------------------------
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表空间和数据文件的关系,否则拒绝申请