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 on linux

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推出的闪回表空间是一样的…


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伪表(原)


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

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




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;
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.


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

SQL> conn anbob/anbob 已连接。 SQL> select count(*) from al […]

IMP-00046: using FILESIZE value from export

if export specify the FILESIZE parameter,so when you import specify TABLES parameter and you must specify the FILESIZE same ths export filesize too