技术成就梦想，梦想依托成就事业的平台与团队
2014年（11）
发布时间：2014-03-14 11:19:39
select segment_name from dba_segments where tablespace_name='OSS' AND segment_type='INDEX';PK_TENANT_ENTCODE唯一索引还在。select segment_name from dba_segments where tablespace_name='OSS' AND segment_type='TABLE';但表不在了。怎么也删除不了主键索引，怎么办呢？解决方法：用以下语句.........【阅读全文】
发布时间：2014-03-14 11:15:10
查看归档日志应用情况语句：SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;比如查到的日志序号是： SEQUENCE# APP---------- --- 108399 YES 108406 NO 查看未传过来中断的日志序号：SQL>select * from v$.........【阅读全文】
发布时间：2014-03-14 11:12:39
报错：Errors in file /u01/oracle/admin/erp/bdump/erp_mrp0_25824.trc:ORA-00313: open failed for members of log group 4 of thread 1ORA-00312: online log 4 thread 1: '+DATA/erp/onlinelog/redo04.log'ORA-17503: ksfdopn:2 Failed to open file +DATA/erp/onlinelog/redo04.logORA-15173: entry 'redo04.log'.........【阅读全文】
发布时间：2014-03-14 11:07:58
drop user gnsael cascade;报错：ora-00054:resource busy and acquire with nowait specified解决方法解决方法：查看相关的用户表是否有被锁，如果被锁，那就结束掉它select b.owner,b.object_name,a.session_id,a.locked_modefrom v$locked_object a,dba_objects bwhere b.object_id = a.object_id;然后.........【阅读全文】
