签到成功

知道了

CNDBA社区CNDBA社区

Can External Tables Be Placed inside ASM diskgroups [ID 470989.1]

2016-11-25 15:50 1578 0 原创 Oracle 11g
作者: dave

 

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

Backuphttp://www.cndba.cn/Dave/article/847

--

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#

http://www.cndba.cn/Dave/article/847

--

TEMPFILE

Tempfiles

tsname

Tablespace into which the file is added

BACKUPSEThttp://www.cndba.cn/Dave/article/847

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.

PARAMETERFILEhttp://www.cndba.cn/Dave/article/847

Persistent parameter files

spfile

http://www.cndba.cn/Dave/article/847

 http://www.cndba.cn/Dave/article/847

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.http://www.cndba.cn/Dave/article/847

FLASHBACK

Flashback logshttp://www.cndba.cn/Dave/article/847

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

http://www.cndba.cn/Dave/article/847

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 http://www.cndba.cn/Dave/article/847

Email: dvd.dba@gmail.com

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

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

聊天 群:40132017   聊天2群:69087192

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

 

版权声明:本文为博主原创文章,未经博主允许不得转载。

oracle 11g

用户评论
* 以下用户言论只代表其个人观点,不代表CNDBA社区的观点或立场
dave

dave

关注

人的一生应该是这样度过的:当他回首往事的时候,他不会因为虚度年华而悔恨,也不会因为碌碌无为而羞耻;这样,在临死的时候,他就能够说:“我的整个生命和全部精力,都已经献给世界上最壮丽的事业....."

  • 2261
    原创
  • 3
    翻译
  • 578
    转载
  • 191
    评论
  • 访问:7983322次
  • 积分:4346
  • 等级:核心会员
  • 排名:第1名
精华文章
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ