Oracle

If you delete a data file in a tablespace before you oracle10g it, the file will still exist in the database data dictionary, and the file information will not be erased unless you delete the tablespace. But starting with ORACLE10GR2, Oracle allows

First, overview:Blocking is a common scenario for DBAs, especially the blocking caused by poor application design, which can result in a severe degradation of database performance until the database crashes. For DBAs, it is necessary to know how to

Using language to achieve Benefits: 1, can reduce access to the database. 2, good portability. Harm: 1, the operation to consider more things, modify a place to modify another place. In other words, they are interrelated. If you change a little, it

1, if there is a Plsql client, you can use the user login, select all the table right key drop can be.2, if you have the right to delete users, you can: Drop user user_name cascade; Cascade can be added to the users of all the data deleted.

The Automated diagnostics information Base (ADR) is introduced in Oracle 11g, which provides a uniform and consistent mechanism for storing, formatting, and locating all database diagnostics (EASY-TO-USE file structures). ADR associates errors with

I. Introduction to the Index 1, index equivalent directory 2, the index is through a group of sorted index key to replace the default Full table scan search method, so as to improve the retrieval efficiency. 3, the creation of the index should be

Friend asked: There's a school. Oracle database encoding is GBK, and the library has a lot of production data, now want to change to UTF8, if the implementation of this step, what will occur? My answer is: Because UTF8 's library Chinese

Instead of using a select in a stored procedure like SQL Server, Oracle can return a result set, which is returned by a result set of an out type parameter. is actually using ref CURSOR Copy Code code as follows: --procedure returns the

Oracle Client Nls_lang Settings Oraclewindowsmicrosoftunixbash 1. Nls_lang parameter composition The Nls_lang parameter consists of the following sections: Nls_lang=_. The meaning of each part of the Nls_lang is as follows: Language

1. The SYS user has DBA authority and has the SYS mode to log in to the database only through SYSDBA. is the highest-privileged account in the Oracle database System has DBA authority. But no SYSDBA permissions. Usually use this account to manage

In is mainly used for incoming parameters, can be variables, constants, expressions, within the subroutine can not change its value. Copy Code code as follows: DECLARE N Number: = 10; PROCEDURE do_something ( N1 in (number) is

An Oracle cursor is divided into a display cursor and an implicit cursor. Display cursor (Explicit Cursor): A cursor defined in a PL/SQL program, used for querying, is called a display cursor. Implicit cursors (implicit Cursor): A cursor that is

first, log in to the database, create the table User00 in the database, and insert the data . The fields of the table are: Id (number), name (name), Grid (level), Score (integral), Password (password), age (Ages), Code (invitation code). (where

Indexing is the most effective way to improve data querying and is the most difficult technology to master, because proper indexing can increase efficiency by 10,000 times times, and invalid indexes may be a waste of database space, or even greatly

The following summarizes the MySQL conversion Oracle several points of attention, I hope to help. 1. Automatic growth of data type processing MySQL has an automatically growing data type, and the data value is automatically obtained when you

Because:1) Improve performance: As far as possible the table and index of the table space stored in different on the disk, the two types of different IO data to open, so as to improve the overall performance of the disk IO; 2 Easy to manage:

Oracle RAC provides two ways to achieve load balancing, the first is pure technology, that is, when users connect, depending on the current load of the system to decide which node to handle the user request; the second is business-oriented, and the

Oracle CPU is too high to handle, this article will describe the Oracle process CPU usage is too high, need to know more than friends can refer to the 1: First use the top command to upload the CPU-intensive SPID number PID USERNAME THR PRI Nice

In the development process, often encountered a number of tests, this time will want to understand the process of testing, and then based on the process to analyze the code is wrong, in this case, you need to use a custom exception, you need to know

Recently did the project encountered the Oracle database import export, where I do the record, to prevent their own forgotten, there is nothing wrong or insufficient place, welcome bo friends Clap bricks, haha ~Export command:1 single table export :