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
Automatic Storage Management file_type | 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. |
-------------------------------------------------------------------------------------------------------
QQ: 492913789
Email: ahdba@qq.com
Blog: http://www.cndba.cn/dave
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群: 83829929 DBA5群: 142216823
聊天 群:40132017 聊天2群:69087192
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请