Can External Tables Be Placed inside ASM diskgroups [ID 470989.1]
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. |
-------------------------------------------------------------------------------------------------------
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表空间和数据文件的关系,否则拒绝申请
版权声明:本文为博主原创文章,未经博主允许不得转载。
oracle 11g