-
编辑 删除
ORA-19809: limit exceeded for recovery files
SQL> startupORACLE instance started.Total System Global Area 1071333376 bytesFixed Size 1375792 bytesVariable Size &nbs...
-
编辑 删除
转:1z0-042 259题实验
1z0-042 259题实验259.Identify the two tablespaces whose data files are so critical that only a closed recovery is possible. (Choose two.)A. SYSAUXB. TOOLSC. UNDOD. INDEXE. SYSTEMF. USERSG. TEMP...
-
编辑 删除
转:Recovering After loss of all members of the CURRENT redo log group
Recovering After loss of all members of the CURRENT redo log groupAll of the members of a current online redo log group in your database have experience media failure.You lose all membe...
-
编辑 删除
TNS 各种连接收藏
如果你的查询不断，那得做预连接。而且针对的好像只是select(我的测试)。客户端的tnsnames,ora得做相应的配置。failover与load balance是不能并存的。(我的测试)给你一个各种各样failover配置的例子：# TNSNAMES.ORA...
-
编辑 删除
常用
/*分为四步 *//*第1步：创建临时表空间 */create temporary tablespace user_temp tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent manag...
-
编辑 删除
REMAP_SCHEMA参数 .
--创建文件目录（这个目录必须真实存在，不然会出错） create or replace directory expdp_dir as 'd:\oracle11\exp_dir';--把创建的目录给2个用户 grant read,write on directory expdp_dir to AA;&n...
-
编辑 删除
转载 FGA(fine-grained auditing )
CREATE TABLE BUILD_TEST01(X NUMBER,Y NUMBER)INSERT INTO BUILD_TEST01 VALUES(2,2) Creating an FGA Policy(disabled) exec DBMS_FGA.ADD_POLICY(object_schema=>'HT',object_nam...
-
编辑 删除
审计的开启和关闭
转一 审计功能的参数控制audit_trail 参数的值可以设置为以下几种1. NONE：不开启2. DB：开启审计功能3. OS：审计记录写入一个操作系统文件。4. TRUE：与参数DB一样5. FALSE：不开启审计功能。这个参...
