Database Administrator

ORA-00604 ORA-21700 error handling Delete SDE user (GIS map data user) report ORA-00604 ORA-21700 today, detailed steps are as follows: SQL> drop user SDE cascade; ERROR at line 1:ORA-00604: error occurred at recursive SQL level 2ORA-21700: object

MySQL configuration file The latest MySQL product actually exceeded the version carried by Red Hat Enterprise Linux. However, stability and open source code are very important factors, so it makes sense to use an earlier MySQL version on the

When importing a batch of data to Oracle today, I encountered a problem: Toad prompts me to assign a value to a custom variable AMP. At first I was wondering that data is a series of Insert statements, how can I have custom variables? Then I

Environment: Operating System: windows xp Virtual machine: VMware 5.5.3 Linux: RHEL 5 Note: Since RHEL 5 is not supported in Oracle official documentation, the following configuration items are subject to Oracle requirements for RHEL 4.0. I. Check

How is Buffer Busy Waits generated? As an Oracle Dba, if you have never met Buffer Busy Waits, you cannot count as a real Oracle Dba. Buffer Busy Waits is a common wait for Oracle databases, especially in environments with frequent concurrent writes.

There are many ways to install MongoDB. you can install MongoDB in source code or in CentOS using yum source. Because MongoDB is updated fast, I prefer the yum source installation method. The installation steps for 64-bit Centos are as follows: 1.

When using SQL to insert update a table directly in Oracle today, the error of ORA-01704: string literal too long occurs. Our SQL is UpdateMall_configSetA. category_info ='| Standard Among them, the category_info field is of the clob type, and the

I. Environment preparation1. experiment environmentOperating System: Oracle Enterprise Linux 5.6Virtual Machine version: VMware 8.0Virtual Machine Hardware configuration: processes 1, ram 1G, disk type SICS, disk size 30G, Nic type NATWhen

1. Install the operating system Oracle Enterprise Linux 5.2 2. Create a user Create an oracle user, create a dba group and an oinstall Group[Root @ oel_11g ~] # Groupadd oinstall[Root @ oel_11g ~] # Groupadd dbaThen, create a

In the Oracle 11g environment, you can use utl_smtp to create a storage process for sending mails, 11gutl_smtp If there are too many email storage processes on the internet, I will not forward them. Let's make a simple example; Create or replace

Integrity constraints (Chapter Summary), integrity constraints Chapter Summary1. The Integrity Constraint of the database is a check measure for data updating. One or more constraints exist on a data table.2. constraints are divided into five types:

Multiple Oracle databases physically stored in the network can be logically considered as a single large database. Users can access the data in the remote database through the network, the collaborative processing between servers is completely

The relationship between tts and character sets -- requires that the source and target database character sets must be the same, and the national character sets must be the same ., Tts Character SetThe relationship between tts and character sets --

[Oracle Study Notes], oracle Study Notes The content mainly includes: (1) three cycles and their simplification (2) Use of cursors (3) Exception Handling (4) Stored Procedure (5) storage functions (6) triggers (7) Other pl/SQL operations -----------

Zookeeper Pre-11gR2: "crsctl check crs" command hangs at EVMD check (Document ID 1578875.1)Applies:Oracle Database-Enterprise Edition-Version 10.2.0.3 to 11.1.0.7 [Release 10.2 to 11.1]Information in this document applies to any platform.SYMPTOMSIn

Summary of the advantages and disadvantages of the five ORACLE tables:1. Normal table: Suitable for most design scenarios, with advantages and disadvantages.Advantages:A. The syntax is simple and convenient.B. Suitable for most

Football and oracle series (3): oracle process rankings, the World Cup round is about to fight! Statement: This is not a technical document. Since I have learned a few tricks about oracle, I cannot afford to sell it to anyone. Just after a meal, I

Some time ago, I helped a friend recover a damaged dmp file, which is more than 100 Gb. I recorded the recovery process and briefly summarized it.I. DescriptionThis dmp file is exp from an Oracle 9i Database. Two types of errors may occur randomly

Oracle Database Backup is encrypted. Encryption can protect Backup files and prevent backup data leakage.Oracle backup encryption mainly refers to RMAN encryption, and EXP/EXPDP encryption is not available. RMAN encryption mainly includes the

Understanding about ora-01000: a point beyond the maximum number of opened cursorsORA-01000: maximum open cursors exceededERROR at line 1:ORA-01000: maximum open cursors exceeded Problem Analysis:1. When the cursor is open, an error occurs and no