发布时间：2013-03-13 18:39:03
create profile one_session limit sessions_per_user 1;alter user scott profile one_session; alter system set resource_limit=true;connect scott/tigerConnected.host sqlplus scott/tigerERROR:ORA-02391: exceed如果是RAC，则每个instance都会允许有一个session.......【阅读全文】
发布时间：2013-03-12 18:54:00
点击(此处)折叠或打开SQL> create profile one_session limit sessions_per_user 1;SQL> create user test identified by test;User created.SQL> grant connect,resource to test;Grant suc.........【阅读全文】
发布时间：2013-02-05 18:13:30
To verify the integrity of the structure of a table, index, cluster, or materialized view, use the ANALYZE statement with the VALIDATE STRUCTURE option. If the structure is valid, no error is returned. However, if the structure is corrupt, you receive an error message.For example, in rare cases suc.........【阅读全文】
发布时间：2012-12-28 16:56:19
The following INIT.ORA/SPFILE parameter can be used if your current redologs are corrupted or blown away. It may also be handy if you do database recovery and one of the archived log files are missing and cannot be restored. NOTE: Caution is advised when enabling this parameter as you might......【阅读全文】
