ITPub博客

首页 > 应用开发 > IT综合 > system用户是否可以删除!

system用户是否可以删除!

原创 IT综合 作者:warehouse 时间:2010-12-23 22:12:24 0 删除 编辑

突然冒出的一个想法,尝试了一下貌似不行...

[@more@]

C:>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Do Dez 23 22:07:10 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> drop user system;
drop user system
*
ERROR at line 1:
ORA-01922: CASCADE must be specified to drop 'SYSTEM'


SQL> drop user system cascade;
drop user system cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00054: resource busy and acquire with NOWAIT specified


SQL> select username from dba_users;

USERNAME
------------------------------
TEST
TEST2
TEST1
SCOTT
DIP
TSMSYS
DBSNMP
SYSMAN
WMSYS
MGMT_VIEW
SYS

USERNAME
------------------------------
SYSTEM
OUTLN

13 rows selected.

SQL> drop user system cascade ;
drop user system cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist


SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 419430400 bytes
Fixed Size 1249368 bytes
Variable Size 142610344 bytes
Database Buffers 268435456 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.

SQL> select username from dba_users;

USERNAME
------------------------------
TEST
TEST2
TEST1
SCOTT
DIP
TSMSYS
DBSNMP
SYSMAN
WMSYS
MGMT_VIEW
SYS

USERNAME
------------------------------
SYSTEM
OUTLN

13 rows selected.

SQL> drop user system cascade;
drop user system cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist


SQL> drop user system cascade;
drop user system cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist

SQL> drop user sys cascade;
drop user sys cascade
*
ERROR at line 1:
ORA-01031: insufficient privileges

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1043545/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-07

  • 博文量
    717
  • 访问量
    5098844