Steve_Noah的博客

--更改空表select 'alter table ' ||table_name||' allocate extent(size 64k);'  from tabs twhere not exists (select segment_name          from user_segments s         where s.segment_name = t.TABLE_NAME)--查询...

SELECT * FROM v$locked_objectselect object_name, machine, s.sid, s.serial#  from v$locked_object l, dba_objects o, v$session swhere l.OBJECT_ID = o.OBJECT_ID   and l.SESSION_ID = s.SID;alter system ki...

--数据库闪回（delete删除表回退）ALTER TABLE ACRM_F_CI_SQU_ORG_LVL ENABLE ROW movementFLASHBACK TABLE ACRM_F_CI_SQU_ORG_LVL TO TIMESTAMP to_timestamp('2017-7-19 1:50:20','yyyy-mm-dd hh24:mi:ss');SELECT SYSDATE FRO...

--数据库最大连接数SELECT VALUE FROM v$parameter WHERE NAME='processes';SELECT * FROM v$process WHERE program='oracle.exe(SHAD)';--查看锁select object_name as 对象名称,s.SID,s.SERIAL#,p.SPID as 进程号,l.OS_USER_NAMEfrom...

1.先来个模板--模板create view ADMIN_AUTH_ACCOUNT(col1,col2,col3...)--视图名(字段一，字段二，字段三...)as --后跟查询语句select col1,col2,col3...from table1;简单的说就是：create view +‘视图名(字段一，字段二，字段三...)’+ as + ‘查询语句’ 2.再举个例子 --创建视图ADM...