Oracle

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

Recently checked a blog before, unexpectedly found this bug was I forget, after a year to continue to solve this problem. Based on the analysis process described in the previous article, it is generally possible to confirm that the statistics of

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 errors encountered

According to Oracle's documentation, the data pump in different ways to export imports, performance can be significantly different, this time just have the opportunity to test, migration table space, direct path, external table, and database chain

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

The flashback Drop was initiated from Oracle 10g to restore objects (including tables, indexes, etc.) that were mistakenly deleted by the user, and this technology relies on the tablespace recycle Bin (tablespace Recycle Bin), which is very similar

1. What is Audit The audit (Audit) is used to monitor the database operations performed by the user, and ORACLE will deposit the audit trail results to the OS file (the default location is $oracle_base/admin/ $ORACLE _sid/adump/) or database

Oracle databases, as a product of managing data, must be able to recognize the administrative commands (often called SQL statements) submitted by the user to respond. The process of recognizing is called the process of parsing an SQL statement, and

A user wants to delete the table space of the database, first the user to have the permission of the drop tablespace Execute the following statement under the current user to query for confirmation Select A2.username,a1.privilege from

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:

Software Environment: 1. Operating system: Windows Server 2. Database: Oracle 8i R2 (8.1.7) for NT Enterprise Edition 3, Installation path: C:\ORACLE Implementation method: 1, D:\>set Nls_lang=american_america. USACII7 Or D:\>set

　　 　　 　　 '-----------------------------------Dim Sp_commonSet Sp_common = Server.CreateObject ("Adodb.command")With Sp_common. ActiveConnection = conn. CommandText = "Cd_update_log". Parameters.Append. CreateParameter ("@inputremark", adVarChar,

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

Summary: In this paper, an Oracle Job task exception case diagnosis, analysis of its causes and the resolution process, from the internal disclosure of Oracle job scheduling and internal timing mechanism. Problems and environment It was reported

A bad chunk of what is a database First of all, let's take a look at the format and structure of the database blocks--the data blocks of the database have a fixed format and structure, three-layer cache layer,transaction Layer,data layer. When we

Oracle can be equipped with more than one database, and only need to open a listener on it, for multiple databases as long as the appropriate service name can be configured to connect. I'm using Oracle 8.1.7 Enterprise edition,os is Windows Server,

Method Find Symcjit.dll, find two places, both JRE (Java Runtime Environment) Rename the two files to Symcjit_.dll and install them, which can be completely normal. Install hardware (already installed properly): Server:dell PowerEdge 2600 Dual

As an Oracle database administrator, you will encounter such database management requirements, stopping or opening constraints and triggers for all tables under the current user (schema). This is one of the things you need to do when merging