ITPub博客

Check all partioned and non-partioned tables & IndexesSQL> set linesize 180set pagesize 10000column owner format a10column index_type format a25column table_name format a35column index_name format a35column partitioned format a10column tablespace_name format a15column partitioned f...

SQL> set linesize 150set pagesize 10000column table_name format a30column tablespace_name format a20column partitioned format a20SELECT table_name, tablespace_name, partitionedFROM dba_tablesWHERE table_name LIKE 'WR%'AND partitioned='YES'ORDER BY table_name;TABLE_NAME &nbsp...

In this DocumentSymptoms Cause Solution ReferencesApplies to: Enterprise Manager for Oracle Database - Version 10.1.0.2 to 12.1.0.2.0 [Release 10.1 to 12.1]Oracle Database - Enterprise Edition - Version 9.0.1.4 to 12.1.0.2 [Release 9.0.1 to 12.1]Oracle Database - Personal Edition -...

How TDPO works with RMANhttp://www.tsmtutorials.com/2013/11/what-is-the-use-of-TDP-of-oracle.html IBM Tivoli Data Protection for Oracle Database is one of the IBM TSM product family used to protect the data stored in Oracle databases. Data Protection for Oracle performs online or o...

http://www.tsmtutorials.com/2013/11/backup-and-restore-oracle-database-using-tdp-for-oracle.htmlHow to configure IBM Tivoli Data Protection for Oracle (TDPO) and take the oracle database backup to TSM Server storage ?If you want to configure IBM Tivoli Data Protection for O...

There are situations when the backup information between RMAN catalog and Tivoli Storage Manager (TSM) is not in sync. Hence there are backup pieces found in TSM catalog which are not available in RMAN catalog or vice versa. There is a need here to release the tapes for recycling by rem...

https://www.ibm.com/support/knowledgecenter/en/SSGSG7_7.1.0/com.ibm.itsm.db.orc.doc/r_dporc_util_tdposync.htmlIBM Tivoli Storage Manager for Databases, Data Protection for Oracle, Version 7.1

IBM Tivoli Data Protection for Oracle provides 3 utilities to troubleshoot the problems or issues faced during oracle backup/restore processes. You can use these utilities to configure and and also maintain Data Protection for Oracle. These utilities are located in the directory where Da...

tail -f -500 /data/oracle/SHPBLS/admin/diag/rdbms/shpbls_sb/SHPBLS/trace/alert_SHPBLS.log| grep 'ORA-|rror'tail -n 1000 alert_ahjcyl.log |grep ORA-cd /data/oracle/SHPBLS/admin/diag/rdbms/shpbls_sb/SHPBLS/trace/tail -n 1000 alert_*.logtail -n 1000 alert_*.log  | grep OR...

本文介绍了linux下的压缩程式tar、gzip、gunzip、bzip2、bunzip2、compress 、uncompress、 zip、 unzip、rar、unrar等程式，以及如何使用它们对.tar、.gz 、.tar.gz、.tgz、.bz2、.tar.bz2、.Z、. tar.Z、.zip、.rar这10种压缩文件进行操作Linux下最常用的打包程序就是tar了，使用tar程序打出来的包我们常称为tar包...

什么是OJVM PSU？CPU: Critical Patch UpdateOracle对于其产品每个季度发行一次的安全补丁包，通常是为了修复产品中的安全隐患。PSU: Patch Set UpdatesOracle对于其产品每个季度发行一次的补丁包，包含了bug的修复。Oracle选取被用户下载数量多的，并且被验证过具有较低风险的补丁放入到每个季度的PSU中。在每个...

https://updates.oracle.com/Orion/Services/download?type=readme&aru=21753493This document describes how you can install Patch 26925532 - Oracle JavaVM Component 11.2.0.4.180116 Database PSU on your Oracle Database 11g Release 2 (11.2.0.4.0).This patch is not Oracle RAC Rolling installab...

[oracle@slient ~]$ opatchOracle Interim Patch Installer version 11.2.0.3.4Copyright (c) 2012, Oracle Corporation.  All rights reserved.Syntax Error... No command specified. Usage: opatch [ -help ] [ -report ] [ command ]          &n...

SQL> set linesize 150column OWNER format a20column SEGMENT_NAME format a20column PARTITION_NAME format a20column SEGMENT_TYPE format a15column TABLESPACE_NAME format a18select OWNER,SEGMENT_NAME,PARTITION_NAME,SEGMENT_TYPE,TABLESPACE_NAMEfrom dba_extentswhere FILE_ID=9 and 885 between blo...

SQLServer 复制和数据库镜像 详细配置部署https://blog.csdn.net/kk185800961/article/details/46369577SQL Server扫盲系列——镜像篇https://blog.csdn.net/dba_huangzj/article/details/35995083

How to Recreate the Automatic Workload Repository (AWR)(Doc ID 782974.1)Applies to:  Oracle Database - Enterprise Edition - Version 10.2.0.5 to 12.1.0.2 [Release 10.2 to 12.1]Oracle Net Services - Version 10.2.0.5 to 12.1.0.2 [Release 10.2 to 12.1]Information in this document applies ...

ORA-24247：网络访问被访问控制列表 (ACL) 拒绝开发编写了一个oracle 发送邮件的存储过程，之前是在10G 的版本运行使用，现在11.2.0.4 的版本使用，调试无法使用发现报错ORA-24247， 网上查询资料如下：1.需要先使用 DBMS_NETWORK_ACL_ADMIN.CREATE_ACL 创建访问控制列表（ACL），   BEG...

背景：数据库由10.2.0.4升级到11.2.0.3.6后发送邮件报错。原因：      For database users upgrading to Oracle Database 11g Release 1 (11.1), applications that depend on the PL/SQL network utility packages compile without any issues. However, at runtime the applications migh...

-- 创建 ACLBEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (  acl          => 'email_server_permissions.xml',   description  => 'Enables network permissions for the&nbsp...

ORA-00001: unique constraint (constraint_name) violatedError MessageORA-00001: unique constraint (constraint_name) violatedCause of ErrorYou tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index.ResolutionThe option...