Oracle

Discussion on the problem of Oracle character set (Nls_language)--------------------------------------------------------------------------------Nls_database_parameters, Nls_instance_parameters, nls_session_parameters----------------------------------

Nls_lang parameter formatNls_lang=_.Language: Display Oracle message, checksum, date nameTerritory: Specify default date, number, currency, and other formatsClient Character Set: Specifies the character set that clients will useFor example: Nls_lang=

A lot of time we certainly hope that the database read and write and the program is separate, so that can improve the business and improve the performance of the server, let me take SQL Server 2005 as an example to introduce the database read and

When Windows starts, the admin$ ipc$ and the sharing of each drive letter are turned on by default, and for unnecessary default sharing, it is generally canceled, but when you need to open this default share, where to set it, generally there are two

Because there is too much data to speed up retrievalTo build a table as a partitioned tableAdding temporary tables dynamically when data is inserted as --Local variables hereFq_dmvarchar( -); P_count Number; --p_fadm number;P_sqlvarchar( -);begin -

Http://www.2cto.com/database/201208/150620.htmlOh, spent one hours, around the 11g installation toss good. Which toss the SQL Developer took a long time, finally fix. OK, first summarize the installation steps, hope to the rear of the children's

Reference documents:Http://www.5ienet.com/note/html/scheduler/oracle-scheduler-using-window.shtmlWindow conceptThis Windows is not windows, usually said Windows refers to cover the richest of the operating system, and here said Windows, refers to a

Look at the previous private log, the original has been a lot of small and simple problems have been confused!Look at that time we are still novice novice to do memo notes!In fact, it is using the statistical function of Oracle!The previous diary

Archive file ManagementOracle archive files are often full or not mounted, here is a brief example of a full case.backing up archive files : Backup Archivelog All ;Backing Up archive logs1 ,   Sql>alter System Archive logcurrent; Archive the

1. Start with ID connect started by prior id= parent ID 2. Level levels 3. Example SELECT * FROM ( Select A.*,level TT from Biz_district a start with district_id=8 connect by prior district_id=parent_id ) Where tt=3 Select a.district_id, A.district_

User rights mechanism 1, different user table permissions grant grant SELECT on Scott.emp to software;　　---the currently logged on user is the table owner, the table name does not have to be specified before the user 2, login with software select *

What if your server has switched to IP?What if your server changed its name?What about the former little buddy?What about previous old customers?It doesn't matter, simply teach you to modify the listening address, old friends casually find!To modify

SYS System (Administrator)Scott (normal user)SQL Server SAPremise: Oracle, if you are an administrator, when the need to establish a user, the operation by themselves;1. Create User (SYS system user)Create user username identified by password;Note:

Oracle MonitoringStart monitoring: Lsnrctl startView monitoring: Lsnrctl statusStop listening: Lsnrctl stop1. Oracle data Server includes: instance process and database;Instance processes include: Memory structure (SGA) and background process (Pmon (

C # + Oralce 10GA useful parameter in the project handles the UPDATE statement. The Parameter name and table field have the same name. Execution error: ORA-01722: Invalid numberAfter modifying all parameters and corresponding fields are different.

As we all know, in MySQL, it is very easy to automatically increment the primary key. You only need to add auto_increment to the primary key definition, but not in Oracle, and it takes a few steps to complete 1. Create a table Create tables account  

BIP Requests Are Failing With Error "OPP Error Oracle. apps. xdo. XDOException: Error Creating Lock Fil, failingto In this Document   Symptoms   Cause   Solution   References

ORACLE basic SQL statements-user and table creation, oraclesql statements I. User-related SQL statements /* Create a user */Create user SA identified by 2013; Description: SA user name and 2013 Password /* Authorize connect and resource to sa

[Translated from mos] maximum data capacity limit of oracle Database and maximum data capacity limit of tablespaceMaximum data capacity limit for oracle databases and maximum data capacity limit for tablespacesReference Original:What Is The Maximum

The method for Manually processing log v $ archive_GAP in oracle dataguard is called dataguardgap. After 9i, the oracle slave uard standby database generally does not need to manually process the lost logs. FAL will automatically help us with the