天龙八部物品全部加锁，有没有急时解锁的办法？

Oracle如何解锁与加锁？

SQL*Plus: Release 9。2。0。4。0 - Production on Tue Jul 14 18:12:38 2009 Copyright (c) 1982, 2002, Oracle Corporation。 All rights reserved。 SQL> conn sys/sys as sysdba Connected。 SQL> show user USER is "SYS" SQL> desc dba_users Name Null? Type ----------------------------------------- -------- -----...全部

  SQL*Plus: Release 9。2。0。4。0 - Production on Tue Jul 14 18:12:38 2009 Copyright (c) 1982, 2002, Oracle Corporation。
   All rights reserved。 SQL> conn sys/sys as sysdba Connected。 SQL> show user USER is "SYS" SQL> desc dba_users Name Null? Type ----------------------------------------- -------- ---------------------------- USERNAME NOT NULL VARCHAR2(30) USER_ID NOT NULL NUMBER PASSWORD VARCHAR2(30) ACCOUNT_STATUS NOT NULL VARCHAR2(32) LOCK_DATE DATE EXPIRY_DATE DATE DEFAULT_TABLESPACE NOT NULL VARCHAR2(30) TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30) CREATED NOT NULL DATE PROFILE NOT NULL VARCHAR2(30) INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30) EXTERNAL_NAME VARCHAR2(4000) SQL> set lines 200 SQL> select username,account_status from dba_users; USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- SYS OPEN SYSTEM OPEN DBSNMP OPEN SCOTT OPEN OUTLN EXPIRED & LOCKED WMSYS EXPIRED & LOCKED ORDSYS EXPIRED & LOCKED ORDPLUGINS EXPIRED & LOCKED MDSYS EXPIRED & LOCKED CTXSYS EXPIRED & LOCKED XDB EXPIRED & LOCKED USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- ANONYMOUS EXPIRED & LOCKED WKSYS EXPIRED & LOCKED WKPROXY EXPIRED & LOCKED ODM EXPIRED & LOCKED ODM_MTR EXPIRED & LOCKED OLAPSYS EXPIRED & LOCKED HR EXPIRED & LOCKED OE EXPIRED & LOCKED PM EXPIRED & LOCKED SQL> alter user hr account unlock;（解锁） User altered。
   SQL> select username,account_status from dba_users; USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- SYS OPEN SYSTEM OPEN DBSNMP OPEN SCOTT OPEN HR EXPIRED OUTLN EXPIRED & LOCKED WMSYS EXPIRED & LOCKED ORDSYS EXPIRED & LOCKED ORDPLUGINS EXPIRED & LOCKED QL> alter user hr identified by hr;（更改密码） User altered。
   SQL> select username,account_status from dba_users; USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- SYS OPEN SYSTEM OPEN DBSNMP OPEN SCOTT OPEN HR OPEN OUTLN EXPIRED & LOCKED SQL> conn hr/hr Connected。
   SQL> conn /as sysdba Connected。 SQL> alter user hr account lock;（加锁） User altered。
   SQL> select username,account_status from dba_users; USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- SYS OPEN SYSTEM OPEN DBSNMP OPEN SCOTT OPEN HR。收起