ITPub博客

alter system set "_allow_resetlogs_corruption"=true scope=spfile;

Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: and later ]Information in this document applies to any platform.Oracle Server Enterprise Edi...

　经常有同事咨询oracle数据库字符集相关的问题，如在不同数据库做数据迁移、同其它系统交换数据等，常常因为字符集不同而导致迁移失败或数据库内数据变成乱码。现在我将oracle字符集相关的一些知识做个简单总结，希...

Table 4 NLS_LANG Parameter Values for Linux Locales Language Locale ID NLS_LANG English (America...

create or replace trigger tr_ddlbefore ddl on databasedeclare  l_errmsg varchar2(100) := '你无权修改,项目组!!!';begin  if (Ora_dict_obj_type = 'TABLE' or Ora_dict_obj_type='INDEX') AND ...

Step by Step Checklist1. Check if the GATHER_STATS_JOB exists in the database:SELECT object_id, object_name FROM dba_objects WHERE  object_type = 'JOB';The output should look like:OBJECT_ID&nbsp...

Select k.segname 对象名, k.userm 使用表空间, k.tablespace_name 表空间, k.segment_type 段类型/*, '0' || substr(to_char(k.userm / (Select Sum(bytes) / 1024 / 1024 userm From User_Extents)), 1, 5) 表空间使用率*/ from (Select Segment_Name segname, Sum(bytes) / 1024 / 1024 userm,t.tablespace_name,t.segment_type From dba_Extents t where t.owner in ('AA') /*and t.segment_type='TABLE'*/