fast delete, Best practice on Very large table
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” ;
提供综合数据库运维服务与优化方案(不限Oracle MySQL PG GaussDB GoldenDB OceanBase等), 微信/Tel:(+86)134-365-60330
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” ;
declare
maxrows number default 1000;
row_id_table dbms_sql.Urowid_Table;
currcount_table dbms_sql.number_Table;
cursor cur_t2 is….
sql server 的维护计划可以定期的备份与删除备份文件,下面只提供备份文件从OS角度的处理方法,如何压缩传ftp,及删除过期的压缩文件
2011年7月21日 5:22,是对于我及家人来说非常重要的时刻,因为我的女儿出生了…
附照片一张
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.
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.
同一实例下,不同用户之间的数据同步导入
1,exp from a user,imp to b user,
2,impdp network_link,不生成dump文件直接导入
…
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
接上一篇,
如果丢失数据库默认表空间的任一数据文件,数据库会不会shutdown?
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
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…
UDE-00008: operation generated ORACLE error 28009
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
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 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. …
Identify the two tablespaces whose data files are so critical that only a closed recovery is possible. (Choose two.)
在linux 上很容易查询 oracle的错误编码,得到提示、原因、及大概解决思路,但windows操作系统就没有办法应用oerr查询错误了,但是有群国外的哥们实现了在windows上使用oerr的方法
今天群里谈DUAL,网上找了点说明,DUAL表就像ORACLE的宝贝女儿,一直隐藏而众多人士又想了解靠近,我决定试一下,发现10G的dual表比9i有变动,也更加合理,话不多说,老风格动手吧
从表里提取汉字, 需要考虑字符集, 不同的字符集汉字的编码有所不同
这里以GB2312为例, 写一函数准确地从表里提取简体汉字.
在itpub上看到了这个方法,我修改了一下,修改后如下
SecureCRT的默认配置对中文支持不好。很容易出现中文乱码。总结就是客户端的字符集问题