Oracle SYS使用者無法設定session級別的read only

kisslfcr發表於2017-11-07
OracleSession
官方文件參考：
SYSDBA is used internally in the Oracle database and has specialized functions. Its behavior is not the same as for generalized users. For example, the SYS user cannot do a transaction level consistent read (read-only transaction). Queries by SYS will return changes made during the transaction even if SYS has set the transaction to be READ ONLY.  Therefore export parameters like CONSISTENT, OBJECT_CONSISTENT, FLASHBACK_SCN, and FLASHBACK_TIME cannot be used.

進行Oracle事務相關的實驗時，要儘量使用普通使用者，因為很多事務級別的設定，對於sqlplus / as sysdba連入方式無法獲得正確的結果。
如果想給使用者獲取資料字典以方便實驗的目的可給使用者賦予如下許可權：
GRANT CONNECT,RESOURCE,SELECT ANY DICTIONARY,SELECT ANY TABLE TO TUSER;



參考：How To Connect As SYSDBA When Using Export Or Import (文件 ID 277237.1)

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29135257/viewspace-2146932/，如需轉載，請註明出處，否則將追究法律責任。

相關文章