ITPUB认证区版主
了解并联系warehouse: http://blog.itpub.net/19602/viewspace-1059211/
发布时间:2009-01-17 16:21:04
我们通常访问其他用户下的对象时如果不创建同义词通常需要在被访问的对象前面加上这个对象的所有者(owner),那么这个所有者是对象的用户名还是schema?通过下面测试自己觉得应该是schema名![@more@]SQL> connect b/b已连接。SQL> select user#,username,schema#,schemaname from v$session where sid=(select sid from v$mystat where rownum=1); USER# USERNAME SCHEMA# SCHEMANAME---------- ---------- ---------- ------------------------------ 35 B 35 B--访问a用户下的tt表,事先做过了......【阅读全文】
发布时间:2009-01-17 16:20:20
doc上解释的格外清楚,还是看doc吧[@more@]Detection of Fractured Blocks During Open BackupsOne danger in making online backups is the possibility of inconsistent data within a block. For example, assume that you are backing up block 100 in datafile users.dbf. Also, assume that the copy utility reads the entire block while DBWR is in the middle of updating the block. In this case, the copy utility may read the old data in the top half of the block and the new data in the bottom top half of the bloc......【阅读全文】