Any loss of controlfile effects of database and recovery the controlfile

Your database is having two control files, three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down

loss of all controlfile,database is automatic shutdown abort?(丢失所有控制文件,数据库会关闭?)

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you…

,

expdp with sys or Include Multiple tables like

UDE-00008: operation generated ORACLE error 28009
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

, , ,

recyclebin session on ,system off

SQL> show parameter recy NAME TYPE VALUE ————– […]

flashback DDL not affect

flashback query 可以闪回以前的数据行,但不可以闪回alter table修改前的表结构,这点在11G推出的闪回表空间是一样的…

1z0-042两个错误答案225,180

One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. …

1z0-042 259题实验

Identify the two tablespaces whose data files are so critical that only a closed recovery is possible. (Choose two.)

windows配置oerr 查询oracle错误

在linux 上很容易查询 oracle的错误编码,得到提示、原因、及大概解决思路,但windows操作系统就没有办法应用oerr查询错误了,但是有群国外的哥们实现了在windows上使用oerr的方法

oracle10G 深入dual伪表(原)

今天群里谈DUAL,网上找了点说明,DUAL表就像ORACLE的宝贝女儿,一直隐藏而众多人士又想了解靠近,我决定试一下,发现10G的dual表比9i有变动,也更加合理,话不多说,老风格动手吧

sql 判断字段值是是否包含中文字符

从表里提取汉字, 需要考虑字符集, 不同的字符集汉字的编码有所不同
这里以GB2312为例, 写一函数准确地从表里提取简体汉字.

在itpub上看到了这个方法,我修改了一下,修改后如下

SecureCRT输入中文

SecureCRT的默认配置对中文支持不好。很容易出现中文乱码。总结就是客户端的字符集问题

sqlplus 限制用户delete(product_user_profile) sp2-0544

SQL> delete test where id=1;
SP2-0544: Command “delete” disabled in Product User Profile

sqlplus login Error accessing PRODUCT_USER_PROFILE

SQL> conn zwz/zwz;
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM

insert append hint 对INDEX的影响

一般向一个表插入数据时,为了提速用到append 提示,但有没有想过表上的索引是怎么维护的?

flashback drop table,index is recovery?

For a table to be recoverable using Flashback Drop, it must reside in a locally managed tablespace. Also, tables in the SYSTEM tablespaces cannot recovered using Flashback Drop regardless of the tablespace type.

ORACLE DBMS_TDS

Transportable tablespace feature introduced since Oracle 10g allowed a tablespace placed in a read only mode to be transported to another database and plugged in. However system and sysaux tablespaces were not transportable

sqlserver base time-point recovery

backup database oa to disk=’d:/oa.bak’
select getdate()
2011-06-30 14:46:36.653

oracle10g online redolog lost(当前日志文件丢失)

Database mounted.
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: ‘/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_3_5y4dgorl_.log’
ORA-00312: online log 3 thread 1: ‘/u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_3_5y4dgq04_.log’

oracle 10G 不区分大小写 (nls_sort、nls_comp)

ORACLE默认所存的值是取分大小写的,但有些需求想忽略大小写,今天就浅谈一下nls_sort ,nls_comp实现查询忽略大小写查询

oracle 11g index IFS/IFFS

oracle对于全索引的扫描支持两种,一种为index full scan简称IFS,另一种是index fast full scan简称IFFS, 后者带了fast是因为前者是单块有序读,而后者是多块无序读,所以多块读对于全扫来说要快于单块读, 对于两者的区别TOM在OTN上描述如下

, ,