ORACLE 9i-23ai – Page 53

expdp with sys or Include Multiple tables like

2024-07-152011-07-14 by weejar zhang

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

recyclebin session on ,system off

2011-07-14 by weejar zhang

SQL> show parameter recy NAME TYPE VALUE ———————————— ———– —————————— buffer_pool_recycle string db_recycle_cache_size big integer 0 recyclebin string on SQL> alter system set recyclebin=off 2 ; System altered. SQL> show user USER is “SYS” SQL> conn anbob/anbob Connected. SQL> create table testdrop(id integer); Table created. SQL> desc testdrop Name Null? Type —————————————– ——– —————————- ID … Read more

flashback DDL not affect

2011-07-14 by weejar zhang

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

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

2011-07-14 by weejar zhang

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题实验

2011-07-14 by weejar zhang

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

windows配置oerr 查询oracle错误

2020-07-042011-07-13 by weejar zhang

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

oracle10G 深入dual伪表(原)

2011-07-13 by weejar zhang

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

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

2011-07-12 by weejar zhang

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

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

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

2011-07-07 by weejar zhang

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

sqlplus login Error accessing PRODUCT_USER_PROFILE

2011-07-07 by weejar zhang

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的影响

2011-07-07 by weejar zhang

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

flashback drop table,index is recovery?

2011-07-06 by weejar zhang

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

2011-07-06 by weejar zhang

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

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

2011-06-28 by weejar zhang

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’

expdp with sys or Include Multiple tables like

recyclebin session on ,system off

flashback DDL not affect

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

1z0-042 259题实验

windows配置oerr 查询oracle错误

oracle10G 深入dual伪表(原)

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

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

sqlplus login Error accessing PRODUCT_USER_PROFILE

insert append hint 对INDEX的影响

flashback drop table,index is recovery?

ORACLE DBMS_TDS

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

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

oracle 11g index IFS/IFFS

IMP-00046: using FILESIZE value from export

oracle in (,,)最多多少个枚举项 ORA-01795

oracle cols 查询表字段类型及长度 function

oracle 10r2 透明加密TDE 实战