1. Query to get the current database, lock, and unlock: SELECT / * + rule * / s.username, decode (l.type, 'TM', 'TABLE LOCK', 'TX', 'ROW LOCK', NULL) LOCK_LEVEL, o.owner, o.object_name, o.object_type, s.sid, s.serial # ...
ORACLE data dictionary view is divided into three categories, with different prefixes, namely: USER, ALL, and DBA, many data dictionary views contain similar information. USER_ *: objects owned by the user information that users themselves create the ...
View the current user's default tablespace rn SQL> select username, default_tablespace from user_users; rn rn view the current user's role rn SQL> select * from user_role_privs; rn rn view the current user's system privileges, and t ...
This paper introduces the v $ session in the meaning of some fields, as well as specific use. Test environment for 10.2.0.1 1 sid, serial # By sid we can check with this session related to a variety of statistical information, processing information; ...
1, the user rn View the current user's default tablespace SQL> select username, default_tablespace from user_users; rn View the current user's role SQL> select * from user_role_privs; rn View the current user's system privileges, an ...
777. USER_UNUSED_COL_TABS Column contains all the tables are not used. 778. USER_UPDATABLE_COLUMNS In the connection the user can modify the view in the column description. 779. USER_USERS The current user information. 780. USER_USTATS Users have use ...
1. create user username identified by password or identified exeternally or identified globally as' cn = user ' [default tablespace tablespace] [temporary tablespace temptablespace] [quota [integer k [m]] [unlimited]] on tablespace [, quota [ ...
sqlplus / nolog connect / as sysdba startup sqlplus / nolog connect / as sysdba SHUTDOWN IMMEDIATE If you want to use windows default date format. English is not in the configuration variables in the environment: NLS_LANG american_america.us7ASCII - ...
ORACLE users to query the data dictionary used to use View the current user's default tablespace SQL> select username, default_tablespace from user_users; View the current user's role SQL> select * from user_role_privs; View the current ...
Source: Net sea cockle-pickers As Oracle DBA, we sometimes need to track user data from deletion or malicious operating conditions, then we need not only to identify the database to perform these operations account, also need to know is where Taiwan ...
Oracle's data dictionary is very much in order to master many of the data dictionary is a difficult task. Of course, with the increase in working hours and experience, there will be more understanding. The following data dictionary describes the ...
A change user password a) sqlplus 2 user lock and unlock ALTER USER username ACCOUNT LOCK PASSWORD EXPIRE; ALTER USER username ACCOUNT UNLOCK; 3 modify the user's table space and temporary space ALTER USER username DEFAULT TABLESPACE tablespace_n ...
