当前位置: 首页 > 图文教程 > 数据库 > Oracle > Raw Partitions and Windows NT

Oracle
Oracle 中文字段进行排序的sql语句
oracle SQL解析步骤小结
ORACLE实例的后台进程
Oracle 游标使用总结
oracle 优化的一点体会
在oracle 数据库中查看一个sql语句的执行时间和SP2-0027错误
Oracle 添加用户并赋权,修改密码,解锁,删除用户的方法
Oracle 创建监控账户 提高工作效率
Oracle 子程序参数模式,IN,OUT,NOCOPY
Oracle 存储过程加密方法
oracle 多个字符替换实现
Oracle 存储过程教程
oracle 更改数据库名的方法
Oracle 分析函数RANK(),ROW_NUMBER(),LAG()等的使用方法
Oracle字符集修改查看方法
一些实用的sql语句
Oracle中sys和system的区别小结
oracle 存储过程和触发器复制数据
Oracle 多行记录合并/连接/聚合字符串的几种方法
ORACLE常用数值函数、转换函数、字符串函数

Oracle 中的 Raw Partitions and Windows NT


出处:互联网   整理: 软晨网(RuanChen.com)   发布: 2009-10-31   浏览: 29 ::
收藏到网摘: n/a

1.0  What is a Raw Partition?

2.0  When to use Raw Partitions  

         2.1 I/O Bound Application  

         2.2 Oracle Parallel Server  

         2.3 Asynchronous I/O (Overlapped I/O)

3.0  Advantages and drawbacks of Raw Partitions compared to File Systems

         3.1 Advantages

         3.2 Drawbacks 

4.0  Setting Up   

         4.1 Calculating The Size of the Partition  

         4.2 Creating the partitions  

         4.3 Specifying in a create tablespace command  

         4.4 Symbolic Links       

                 A) Creating Symbolic Links

                 B) Removing Symbolic Links

5.0  Backup Strategies   

         5.1 OCOPY80.EXE

         5.2 RMAN

6.0  Raw Devices and Export/Import

7.0  How to switch files from a File System to Raw Device or from a Raw

     Device to a File System.

8.0  Remarks

1.0  What is a Raw Partition?

-----------------------------  

Raw partitions or devices are disk partitions that are not mounted and written 

to as a file system, but are accessed via a character device driver.  It is the 

responsibility of the application to organize how the data is written to the 

disk partition.  So a Raw Partition is a segment of disk space pointed by the 

partition table.  There is no file system out there, no directories (no DIR or 

NT Explorer).

Disk Naming

-----------

At startup, Windows NT names each found disk drives following this naming

convention:

     \Device\Harddisk\Partition

     where:  :  the number of the physical drive - starts with 0

             :  the number of the logical number as show in the NT Disk 

                   Adminstrator - starts with 1

     \Device\Harddisk0\Partition1 would typically be the C drive

Raw Partition Definition

------------------------

There are two different types (definition methods) of Raw Partitions

      a) physical disk 

      b) logical disk 

TIP:

Although you actualy could you the physical disk approach, its 

strongly recommended to use the logical disk approach.

a)  Physical disk:

    A physical disk or Partition0 actualy refers to the whole disk

       \Device\Harddisk\Partition0

    When using the Setlinks command on a Dos prompt you will notice that Windows