如何修改XS$NULL的默认表空间

kiss0622 2013-12-06 09:05:06

现状：
oracle 版本 11G
现需要变更XS$NULL的默认表空间
管理员登陆后执行以下语句：
ALTER USER XS$NULL DEFAULT TABLESPACE TRNDATA;
执行后提示ORA-01031的错误。无权限修改。

请教这个该怎么变更啊

...全文

387 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

orientlight 2014-03-21

打赏
举报

USERNAME                          USER_ID CREATED
------------------------------ ---------- ------------------------------
ORDPLUGINS                             55 13-8-24 11:49:40
ORDDATA                                54 13-8-24 11:49:40
ORDSYS                                 53 13-8-24 11:49:40
ANONYMOUS                              46 13-8-24 11:47:55
XDB                                    45 13-8-24 11:47:55
CTXSYS                                 43 13-8-24 11:47:37
EXFSYS                                 42 13-8-24 11:47:27
XS$NULL                        2147483638 13-8-24 11:49:29
WMSYS                                  32 13-8-24 11:43:26
APPQOSSYS                              31 13-8-24 11:43:00
DBSNMP                                 30 13-8-24 11:42:59
ORACLE_OCM                             21 13-8-24 11:39:34
DIP                                    14 13-8-24 11:38:58
OUTLN                                   9 13-8-24 11:37:43
SYSTEM                                  5 13-8-24 11:37:40
SYS                                     0 13-8-24 11:37:40

那么XS$NULL的USER_ID是随机的吗?这个大小是哪个参数设置的?

kiss0622 2013-12-06

打赏
举报

很有用，谢谢!

CT_LXL 2013-12-06

打赏
举报

引用 2 楼 kiss0622 的回复:

因为所有的用户默认表空间都要统一调整，所以就列出了所有用户，唯独这个无法修改。我在网上查这个用户，信息不是太多。如果有知道的麻烦告诉下。谢谢

国外网站上看到的，如下： The oracle documentation for that user states An internal account that represents the absence of a user in a session. Because XS$NULL is not a user, this account can only be accessed by the Oracle Database instance. XS$NULL has no privileges and no one can authenticate as XS$NULL, nor can authentication credentials ever be assigned to XS$NULL In 11.2 development explicitly added a check in the code to make sure that nobody (not even user SYS) can alter user XS$NULL. This is the expected behaviour. Solution You cannot alter user XS$NULL. This is the expected behaviour. User XS$NULL is internal and it may not be altered in any way. To guarantee the stability of the system, this was explicitly forbidden. Even if this may work in earlier releases it is strongly recommended to not alter user XS$NULL. If you try to do this because of some security auditing requirements (which for example demand that all users should be in a certain profile) explain to the auditors that this is impossible. Another reason why you may want this is to change the default tablespace of the user, while you cannnot alter this user specifically you can change the default tablespace at the database level and when you do this it will change the XS$NULL user temp tablespace as well.

kiss0622 2013-12-06