oracle
1316901704@qq.com
这个作者很懒,什么都没留下…
展开
-
oracle数据库连接人数过多
https://www.cnblogs.com/zmlctt/p/3881175.html原创 2021-02-03 16:03:40 · 190 阅读 · 0 评论 -
oracle字段值追加
update table set name = name ||'append value' where id ='111'原创 2021-01-22 16:01:18 · 1513 阅读 · 1 评论 -
oracle/MySQL group by id,一个id对象多个值 拼到一行中
select id , xmlagg(xmlparse (content t.title值|| ','分隔符 wellformed) order by time).getclobval() as titlefrom policy_states表名group by id;policy_statesid title 1 a 1 a 1 b 2 TT 结果:id title 1 a,b, 1 TT, ...原创 2020-12-18 20:00:00 · 354 阅读 · 1 评论 -
oracle创建用户以及导出数据泵
0、Oracle数据库执行表分析,为步骤 1 做准备analyze table table_name compute statistics;1、查询要导出的用户表中存在的空表;select table_name from user_tables where NUM_ROWS=0;2、修改空表使其能导出;ALTER TABLE tablename1 ALLOCATE EXTENT;ALTER TABLE tablename2 ALLOCATE EXTENT;...... 3、导出数据源...原创 2020-12-17 15:53:44 · 111 阅读 · 0 评论 -
Oracle表被锁 解锁杀kill
select object_name,machine,s.sid,serial# from v$locked_object l,dba_objects o,v$session s where l.object_id=o.object_id and l.session_id = s.sid;alter system kill session '640,577';原创 2020-12-09 16:57:22 · 89 阅读 · 0 评论 -
ORA-02292 delete语句外键报错
查看外键表名select table_name from dba_constraints where constraint_name='xxx外键名';原创 2020-10-21 17:35:46 · 96 阅读 · 0 评论