--//而且上次涉及的块很少,这次我们反向思考,不修改块的段号,而修改数据字典,来恢复truncate表.--//注意truncate还是使用reuse storage选项,存储空间不会回收.SCOTT@test01p> create table t1 as select * from all_objects;Table created.SCOTT@test01p> select rowid,t1.* from t1 where rownum=1;ROWID ...【阅读全文】
今天在做看OCP的时候有道题是关于应用安全角色的,不是很明白,在网上找了个例子按照步骤验证了下.QUESTION 48You want to create a role to meet these requirements:1. The role is to be protected from unauthorized usage.2. The password of the role is not to be embedded in the application source code or sto...【阅读全文】
为什么oracle要引入检查点机制?降低实例恢复的时间通过实验来简单观察下checkpointSQL> select file#,checkpoint_change# from v$datafile order by 1; FILE# CHECKPOINT_CHANGE#---------- ------------------ 1 &nb...【阅读全文】
Start RUEI processing:# On the Reporter server as $RUEI_USERproject -start wgStart the RUEI web server:# On the Reporter server as root service httpd startTo start the Collector, issue the following command as the moniforce user:appsensor start wg【阅读全文】