ORACLE 9i-23ai – Page 53

Today I read foreign blog,I think I learned the true knowledge
One of most operations we are performing is “Deleting many rows from oracle big tables” ;

利用rowid快速在线更新海量数据

2011-08-09 by weejar zhang

declare
maxrows number default 1000;
row_id_table dbms_sql.Urowid_Table;
currcount_table dbms_sql.number_Table;
cursor cur_t2 is….

trigger一点儿小发现new or :new、ORA-04091

2011-07-19 by weejar zhang

If you delete the line “FOR EACH ROW” from the trigger, it becomes a statement trigger which is not subject to this restriction, and the trigger.

Backups to tape can only be backup sets. use rman

2011-07-19 by weejar zhang

By default, RMAN creates all backups as backup sets, on tape or on disk. You can change the default backup type for disk backups to be image copies using the CONFIGURE command. Backups to tape can only be backup sets.

oracle同一实例不同用户之间所有对象的数据导入

2011-07-19 by weejar zhang

同一实例下，不同用户之间的数据同步导入
1，exp from a user,imp to b user,
2,impdp network_link,不生成dump文件直接导入
…

HWM 高水位储存位置

2011-07-18 by weejar zhang

Extent Header:: spare1: 0 spare2: 0 #extents: 4 #blocks: 32
last map 0x00000000 #maps: 0 offset: 2716
Highwater:: 0x02400391 ext#: 3 blk#: 8 ext size: 8

Loss database default tablespace files affected and recovery

2011-07-15 by weejar zhang

接上一篇，

如果丢失数据库默认表空间的任一数据文件，数据库会不会shutdown?

Any loss of controlfile effects of database and recovery the controlfile

2011-07-15 by weejar zhang

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?(丢失所有控制文件，数据库会关闭？)

2011-07-152011-07-15 by weejar zhang

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

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

oracle11g掩盖敏感数据(remap_data)

BLOB select、insert、exp with sqlplus

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

DML error capture (捕获DML错误日志)

fast delete, Best practice on Very large table

利用rowid快速在线更新海量数据

trigger一点儿小发现new or :new、ORA-04091

Backups to tape can only be backup sets. use rman

oracle同一实例不同用户之间所有对象的数据导入

HWM 高水位储存位置

Loss database default tablespace files affected and recovery

Any loss of controlfile effects of database and recovery the controlfile

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

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