Oracle

It seems that by checking the data dictionary information is not the cause of the problem, only by manually performing the process of collecting statistics to try to discover the problem. In order to avoid the problems caused by the accidental

XML type for a long time there has been no attention, there are times just to see; The thing to do in this study 1. Design a C # class to generate XML Schemas (XML Schema) Designing a class and then generating a table from a class there may be a

In the previous article, the analysis of the current problem was described, and a simple analysis of the unfinished job in the database was made to see if the cause of Rman's inability to log in was consistent with the reason that the job was not

With Oracle's standby technology, a single-instance database can be upgraded to a RAC database. This approach can effectively reduce the downtime for single instance migration to the RAC environment. This article describes the preparation for

1. V$database This view lets you see if the Flashback database feature is enabled Sql> select flashback_on from V$database; flashback_on ------------------ YES 2. V$flashback_database_log The earliest time flashback database can be rolled

1 The value of the 6th to 10th record in the table 1.1 The first method, using the minus statement Suppose the DDL statement is as follows: CREATE TABLE T (ID VARCHAR2 (4) PRIMARY KEY, VALUE INT) Then the first method is to take out the first 5, and

The entire transplant is three-step First, copy Oracle and HMIS folders: If the original orant and HMIs folder in C: Disk, copy to the new system also put on C: disk; The original file comes in D: Disk, copy to the new system also to be put to D:

We often want to put data from all over the warehouse for unified application. You can now use replication technology to solve this problem. However, there are some conditions for implementing database replication. First, the database should have

1. Full recovery Restores the database to the last commit state before failure through backup, archive log, current redo. (typically used for media failure) --Archive mode 1) Full recovery 2) Incomplete recovery --Non-archive mode 1) revert to

Novice in writing program, must be adventurousness, and must have patience, do not compromise, do not understand on the book, online search data, ask friends, resolutely carried out in the end. Recently has been with the knowledge of the ASP in the

Overview: Oracle database is currently the industry's most commonly used large database systems, I encountered in the actual project ORA-00257 error (lack of space error), by looking for information, most of this is due to the archive log too much,

Problem Description: In processing general data records, for numeric types of fields, in Oracle sort, the null value is the default to be greater than any number of types, of course, for varchar2 type of field, the default is also the processing,

Today encountered a problem: internal account password forgot: (through the information, find a way to enter the database: In Oracle database systems, There are two ways to authenticate users if they want to log on to an Oracle database as a

The goal of this article is to complete the process of automated Oracle database backups by executing a shell script, and to generate its compressed files in the current directory. The following steps are implemented: 1. Log on to the Linux system

Before doing a system, encountered a problem! Today, I accidentally found the solution to this problem and posted it!!! Problem Description: VARCHAR2 (4000) ABC; Intert into table_name (ABC) VALUES (' Here are 1500 characters ... '); Error:

create or replace procedure SYSRINGALL_TEST isall_tmp_name char(30);all_name char(30);beginif all_tmp_name is null thenselect 'ring_all_old_'||to_char(sysdate,'yyyymm')||'_tmp' into all_tmp_name from dual;end if;if all_name is null thenselect

Methods that Oracle stored procedures return arrays: 1. Create a Package create or replace package test isTYPE filename_array IS TABLE OF varchar2(1);filename filename_array;end test; 2. Establish a stored procedure create or replace procedure

I. Loss of recovery of the inactive log file group: Because the inactive log file group indicates that the checkpoint has been completed (dirty data has been written to the data file). The database itself does not have database loss, and if the

The following is just the information you get from reading the document, and everything may change before 11GR2 is officially released. 1. RMAN web-services Backup Oracle now allows the database to be backed up directly to Amazon S3 or other cloud

1 Brief introduction In general, in order to ensure that the database data is not lost or less lost, reduce the accident recovery time, we often use the Oracle Database Export tool to regularly back up the database. For commonly used exp backups,