flashback table t1 to before drop;

2022-05-26

1、select ‘drop table ‘||tname||’;’ from tab;
drop table t1;
2、flashback table t1 to before drop;  阅读全文...

yum install OpenLDAP Server on RHEL8/Centos8

2022-05-22

Current version: 2.4.59.1  阅读全文...

Linux OpenLAP 修改max open files

2022-05-08

默认安装OpenLDAP,其max open files个数太小,设置为1024  阅读全文...

/var/log/journal日志清理

2022-04-14

/var/log/journal日志清理  阅读全文...

608ZZ ABEC-7 轴承钢轴承

2022-03-08

高速轮滑鞋滑板双翘板剪刀车扭扭车童车轮608ZZ RS工业轴承ABEC-7 【原装】608ZZ【8支装】 ABEC-7  阅读全文...

nacos授权

2022-02-22

nacos.core.auth.enabled=true  阅读全文...

vi每个字中间加空格

2022-02-01

vi每个字中间加空格
:%s/\([u4e00-\u9fa5]\)/\1 /g  阅读全文...

ssh -o StrictHostKeyChecking=no

2022-01-24

-o StrictHostKeyChecking=no
scp -o StrictHostKeyChecking=no -P22 ${SHELL_FILE} root@${IP}:/root  阅读全文...

sed指定字符串后面添加

2021-12-21

sed -i “/JAVA_OPT_EXT/a JAVA_OPT=\”\$\{JAVA_OPT\} –add-exports java.base\/jdk.internal.ref=ALL-UNNAMED\”” bin/runbroker.sh  阅读全文...

mysql批量drop table

2021-12-07

SELECT concat(‘DROP TABLE IF EXISTS ‘, table_name, ‘;’) FROM information_schema.tables WHERE table_schema = ‘dbdb’;  阅读全文...

拼音输入法之u模式

2021-12-05

win10中借助微软拼音输入法输入生僻字、和在u模式下输入特殊符号的方法  阅读全文...

openldap超过最大并发

2021-12-01

Linux OpenLAP 修改max open files  阅读全文...

阿里云oss云存储ossutil工具

2021-11-23

ossfs挂载当磁盘rsync时候非常卡,替换ossutil工具  阅读全文...

alter index rebuild online

2021-11-06

rebuild index online不阻塞DML操作,这是相对于rebuild index来说的,加上了online,只是在rebuild的期间不阻塞DML,但是在开始和结束阶段还是可能阻塞其他进程的DML的,系统负载飙升,甚至宕机。10G rebuild index online 会锁表  阅读全文...

oracle ALTER INDEX RENAME TO

2021-11-06

ALTER INDEX [schema.]index RENAME TO ;   阅读全文...