2、查询出用户所有表的索引
select * from user_indexes

3、查询用户表的索引(非聚集索引):
select * from user_indexes where uniqueness='NONUNIQUE'

4、查询用户表的主键(聚集索引):
select * from user_indexes where uniqueness='UNIQUE'

5、查询表的索引
select t.*,i.index_type from user_ind_columns t,user_indexes i where t.index_name=i.index_name and
t.table_name='NODE'

6、查询表的主键
select cu.* from user_cons_columns cu, user_constraints au where cu.constraint_name=au.constraint_name and
au.constraint_type='P' AND cu.table_name='NODE'

7、查找表的唯一性约束（包括名称，构成列）：
select * from user_constraints t,user_cons_columns a where a.constraint_name=t.constraint_name and t.constraint_name like '%约束的名称%';

8、查找表的外键
select * from user_constraints c where c.constraint_type='R' and c.table_name='STAFFPOSITION'
查询外键约束的列名：
select * from user_cons_columns cl where cl.constraint_name=外键名称
查询引用表的键的列名：
select * from user_cons_columns cl where cl.constraint_name=外键引用表的键名

9、查询表的所有列及其属性
select t.*,c.COMMENTS from user_tab_columns t,user_col_comments c where t.table_name='NODE'

When querying on a cube requiring an excessive currency conversion (like drill-down to lowest level), the @xref request on session browser is showing "In progress" all the time together with target cube process. When you try to kill it thru session browser, it shows "Terminating" and has to be killed from linux box kernal. The same kind of query running on V7 (linux box) can be killed immediately. On V11.1.1.2 server, it shows "Process local xref request using shared memory".
Cause
The shared memory is not handled correctly when connecting with an xref to another application. The shared memory has to be disabled with this .cfg parameter.

DisableSharedMemory appName TRUE

解决方案(Solution)：

Add the following to the essbase.cfg file. Stop and start Essbase:
DisableSharedMemory appName TRUE

测试步骤：
---------------
X:\Smartview\SmartView.exe  /v"/l*v \"c:\logfiles\installation.log\""

解决方法：
---------------
暂无

1 使用sys用户连接数据库：
    sqlplus /nolog;
    CONNECT SYS/password AS SYSDBA
2 关闭数据库：
    SQL>SHUTDOWN IMMEDIATE;
3 mount 数据库
    SQL>STARTUP MOUNT
4 改变归档模式
    SQL> Alter DATABASE ARCHIVELOG;(如要改回归档模式则是Alter DATABASE NOARCHIVELOG;)
5 打开数据库
    SQL>Alter DATABASE OPEN;

二、建立UNDO表空间
 Create UNDO TABLESPACE UNDOTBS02
 DATAFILE '/oracle/oradata/db/UNDOTBS02.dbf' SIZE 50M

 #注意：在OPEN状态下某些时刻只能用一个UNDO表空间，如果要用新建的表空间，必须切换到该表空间:

 Alter SYSTEM SET undo_tablespace=UNDOTBS02;

三、建立临时表空间

 Create TEMPORARY TABLESPACE temp_data
 TEMPFILE '/oracle/oradata/db/TEMP_DATA.dbf' SIZE 50M

四、改变表空间状态

 1.使表空间脱机
  Alter TABLESPACE game OFFLINE;

  如果是意外删除了数据文件，则必须带有RECOVER选项

  Alter TABLESPACE game OFFLINE FOR RECOVER;

 2.使表空间联机
  Alter TABLESPACE game ONLINE;

 3.使数据文件脱机
  Alter DATABASE DATAFILE 3 OFFLINE;

 4.使数据文件联机
  Alter DATABASE DATAFILE 3 ONLINE;

 5.使表空间只读
  Alter TABLESPACE game READ ONLY;

 6.使表空间可读写
  Alter TABLESPACE game READ WRITE;

五、删除表空间
 Drop TABLESPACE data01 INCLUDING CONTENTS AND DATAFILES;

六、扩展表空间

 首先查看表空间的名字和所属文件

 select tablespace_name, file_id, file_name,round(bytes/(1024*1024),0) total_space from dba_data_files order by tablespace_name;

 1.增加数据文件
  Alter TABLESPACE game
  ADD DATAFILE '/oracle/oradata/db/GAME02.dbf' SIZE 1000M;

 2.手动增加数据文件尺寸
  Alter DATABASE DATAFILE '/oracle/oradata/db/GAME.dbf'
  RESIZE 4000M;

 3.设定数据文件自动扩展
  Alter DATABASE DATAFILE '/oracle/oradata/db/GAME.dbf
  AUTOEXTEND ON NEXT 100M
  MAXSIZE 10000M;

 设定后查看表空间信息
 Select A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,(B.BYTES*100)/A.BYTES "% USED",(C.BYTES*100)/A.BYTES "% FREE" FROM SYS.SM$TS_AVAIL A,SYS.SM$TS_USED B,SYS.SM$TS_FREE C Where A.TABLESPACE_NAME=B.TABLESPACE_NAME AND A.TABLESPACE_NAME=C.TABLESPACE_NAME;

七、移动表空间
           
 1.查询数据表和表空间
  select table_name,tablespace_name from user_tables;

 2.移动表至另一表空间
  alter table move tablespace room1;

解决方法：
导出多个规则为XML文件时，XML会比较大。只能将每个规则导出为XML文件，再重新导入则一切OK。