oracle raw device create tablespace
[root@vmfs sysconfig]# lvdisplay |grep db_d
LV Name /dev/db_v4/db_d_22
LV Name /dev/db_v4/db_d_23
LV Name /dev/db_v4/db_d_24
LV Name /dev/db_v4/db_d_25
LV Name /dev/db_v4/db_d_26
LV Name /dev/db_v3/db_d_13_ct1
LV Name /dev/db_v3/db_d_14_ct2
LV Name /dev/db_v3/db_d_15_ct3
LV Name /dev/db_v3/db_d_16_redo1
LV Name /dev/db_v3/db_d_17_redo2
LV Name /dev/db_v3/db_d_18_redo3
LV Name /dev/db_v3/db_d_19
LV Name /dev/db_v3/db_d_20
LV Name /dev/db_v3/db_d_21
LV Name /dev/db_v1/db_d_1
LV Name &nbs
相关文档:
1、查询两个日期之间的数据。
假设有表Table1,其创建表的sql语句为:
create table Table1(
StationID NUMBER(10) Primary key,
Year NUMBER(4) not null,
Month NUMBER(2) n ......
--如何用grade表的资料去更新usertable表的资料(有关联的字段userid)
update usertable u set u.grade =
(select g.grade from grade g where g.userid = u.userid);
--如何使查询结果字段生成序号
select rownum, t.* from sm_t_pad_new t
--如何快速做一个和原表一样的备份表
create ......
The DB File Sequential Read wait event generally indicates a single block read (an index read,
for example). A large number could indicate poor joining orders of tables or unselective indexing.
This number will certainly be large (normally) for a high-transaction, well-tuned system. You ......
1.LVM:
[root@vmfs ~]# pvdisplay
--- Physical volume ---
PV Name /dev/sdg
VG Name db_v4
PV Size  ......
SQL*LOADER是ORACLE的数据加载工具,通常用来将操作系统文件迁移到ORACLE数据库中。SQL*LOADER是大型数据
仓库选择使用的加载方法。
在NT下,SQL*LOADER的命令为SQLLDR,在UNIX下一般为sqlldr/sqlload。
如执行:d:\oracle>sqlldr
SQL*Loader: Release 8.1.6.0.0 - Production on 星期二 1月 8 11:06:42 2 ......