Archive for January, 2010
oracle 10g SYSAUX tablespace
The SYSAUX(System Auxiliary) tablespace is a new feature of Oracle 10g database,before 10g release,there wasn’t this tablespace.After you created your database via DBCA(Database Configuration Assistant) tool,the SYSAUX tablespace was created for you automatically.
But what’s the mainly function of that tablespace? Why Oracle present the SYSAUX tablespace? Does it bring some benefit for the database or [...]
revoke sysdba from user_name
把sysdba权限授予给user1之后，orapwSID文件中记录了user1的信息，但是将sysdba权限从user1收回之后，orapwSID文件中依然有user1用户。这是为什么呢？？？
可是联机文档上明明说：
A user’s name remains in the password file only as long as that user has at least one of these two privileges. If you revoke both of these privileges, Oracle Database removes the user from the password file.
以下是我的实验步骤：
1看到字典里面记录的只有SYS用户拥有SYSDBA和SYSOPER系统权限：
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP
—————————— —– —–
SYS [...]