oracle安装时候默认安装xml,怎样安装和卸载 Oracle XML database (XMLDB/XDB)?

怎样安装和卸载 Oracle XML database (XMLDB/XDB)?

http://www.dbatools.net/experience/oracle_xmldb_install.html

http://space.itpub.net/11893231/viewspace-341823

http://blog.csdn.net/fidelhl/archive/2008/08/01/2753384.aspx

查看是否安装了XDB

表示没有安装：

1.

SQL> select count(*) from dba_objects where owner='XDB';

COUNT(*)

----------

0

2.

SQL> select comp_name, status, version from DBA_REGISTRY where comp_name= 'Oracle XML Database';

no rows selected

表示成功安装

1

SQL> select count(*) from dba_objects where owner='XDB';

COUNT(*)

----------

66

2

SQL> select comp_name, status, version from DBA_REGISTRY where comp_name= 'Oracle XML Database';

COMP_NAME

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

STATUS                                       VERSION

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

Oracle XML Database

VALID

192.168.7.12

192.168.100.200

192.168.9.156

标题: 什么命令可以查看tablespace!

以dba权限用户登陆:

SQL> select * from dba_tablespaces;

SQL> select * from user_tablespaces;

SQL> select * from v$tablespace;

TS# NAME

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

0 SYSTEM

3 TEMP

1 RBS

5 INDX

4 TOOLS

6 DRSYS

2 USERS

7 WFCTB

8 WFCTB2

9 WFCIDX

10 WFCIDX2

TS# NAME

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

13 OEM_REPOSITORY

已选择12行。

oracle 查看 tablespace

标题: 什么命令可以 查看所有用户     select   *   from   user_users;   //当前用户     select   *   from   all_users;    //所有用户     select   *   from   dba_users;    //包括系统用户