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表空间和数据文件的关系,否则拒绝申请
分享到:
相关推荐
1. JPanel must be placed inside a container. 4. Interface methods can be static
Thus, as illustrated in Figure 6-1, the pattern that these pairs of tributaries are placed on the ring impacts the maximum load that can be placed on MS shared protection rings. The sum of the ...
Support ticket 78499: Variable assignments inside SELECT statement can now be aligned like aliases 7.3.0.748 - 28th November Loading indicator is now displayed when previewing a large script in the ...
34)..Changed: EurekaLog 7 now can be installed over EurekaLog 6 automatically, with no additional actions/tools EurekaLog 7.4 (7.4.0.0), 26-January-2016 1)....Fixed: Performance issue in DLL exports...
PopupBubble Easily Add "New Post...Positioning of this view can be done according to the need. By default it should be placed in top center. Also it should be placed below recyclerview in layout so that
It is not required to match directories and packages: source files can be placed arbitrarily in the file system. See Packages. Function having two Int parameters with Int return type: fun sum(a: Int, ...
Guideline interpretation concept placed mouth_en.zip
The accuracy of lighting dynamic objects on the scene largely depends on how correctly the light probes are placed. Magic Light Probes is an editor extension that is designed to help you arrange ...
the packed designs to the Xilinx CAD tools to be placed and routed in their software. This enables researchers to isolate the packing portion of the algorithm from the commercial flow and evaluate ...
- ADD: Add TFlexPanel.InvalidateControl virtual method which calls from TFlexControl.Invalidate and can be overriden (it is possible now to catch all object invalidation calls). - FIX: The TFlexPanel....
More detail about new features can be found in the file - About EhLib 6.2 Eng.doc To install a new version of the library in the IDE, use the installation program in .\Installer\EhLibInstaller.exe ...
Similarly, any ss.ini variable can be placed in srcsafe.ini to set a ; system "default," which individual users can still override in ss.ini. ; The two important paths used by SourceSafe. Data_Path ...
Applications including Quickreport functionality can then be deployed royalty free. QuickReport is a banded report generator written in 100% Delphi code that integrates very closely with Delphi and ...
More detail about new features can be found in the file - About EhLib 8 Eng.doc To install a new version of the library in the IDE, use the installation program in .\Installer\EhLibInstaller.exe ...
The spacing between child views can be calculated by the FlowLayout so that the views are evenly placed. Gradle compile 'com.nex3z:flow-layout:1.2.4' Usage <!--...--> Attributes ...
1. You will be notified about new versions of the library. 2. You will receive new versions of EhLib FREE till version 6.0. 3. You encourage the author do make the components even better. 7. Other ...
can be found in the file - About EhLib 9.1 Eng.doc To install a new version of the library in the IDE, use the installation program .\Installer\EhLibInstaller.exe If, at the installation have any ...
Electronic component manufacturers use the IEC 60063 standard to determine the values to be placed on the market. This function allows you to find the commercial value compared to the calculated value...
* TABLES This VB6 sample demonstrates how to use AddFlow to create database diagrams. * XMLFLOW An ActiveX DLL allowing to save/load an AddFlow diagram in a XML file. - 2 VC6 SAMPLES * NAVIG VC6 ...
Any files placed in this directory with a .pro or .sav extension will automatically be compiled / restored by ENVI at startup time. An individual user may also specify an additional /save_add ...