Oracle

Principle of monitoring service and access connectionPort number range: 1025~6500[[email protected] ~]$ Lsnrctl--access to the Monitoring management toolLsnrctl for linux:version 10.2.0.1.0-production on 05-jun-2014 11:13:20Copyright (c) 1991, 2005,

This article mainly examines the algorithm-recursive programming (tree Generation)---> The code in this article can also use "CONNECT by" in Oracle to complete the requirements.The examination topics are as follows:The procedure is as follows:1.

The customer today reinstalled the Windows R2 system on the IBM server, and since Oracle is installed on the D drive, the original library needs to be resumed, and the original library needs to be restored, with the following steps: To back up

Big New Year's also want to knock code, think is intoxicating. Busy today to get out of the set, when the function test found that the value of the ID has been 0, a look at the value of the ID is not self-increment, has been the default of 0. So

Since last week, the server Oracle database problems, in less than half a day, will be reported maxsession (150) problem, it is certain that the database session exceeded the maximum number.Since the server is running file transfer applications, the

There is a table named TB, field segment named Name, data type nchar (20).1. Assuming that the field data is empty, you can do it directly, regardless of the field type you are changing to:ALTER TABLE TB Modify (name Nvarchar2 (20));2, if the field

The  oracle Dataguard is the Oracle's own data synchronization feature that transfers log files from the original database to the target database and then applies the log files on the target database, keeping the target database synchronized with

var t= cardservice.getinstance (). Test ("900000000233");foreach (DataRow row in t.item2.rows){foreach (DataRow column in t.item1.rows){String columnname = Column[0]. ToString ();String comments = Column[2]. ToString ();String value = Row[columnname]

There are two logging modes in the Oracle database: Non-archive log mode and archive log mode.In an Oracle database system, in order to prevent the content in the log file from being overwritten when it is recycled, the Oracle systemwill already A

In the development of SQL, filter date is often encountered in the situation, how to efficiently filter out the date period? This article is validated by experiments:Method One, compare dates into strings by To_charTo_char (cr.contractenddate, '

This article is mainly a summary of the problem, will be updated continuously.1. When executing environment *env = Environment::createenvironment (), throws an exception, the code is ORA-32104, but there is no error messageThe reason is to use the

There has been no contact with Oracle database before, and recently the company has a project that needs to be used, so start tossing Oracle. Just started to go a lot of detours, in order to help more and I just started to contact Oracle's small

1. Click "Run" on the Start menu and enter Sqlplus/nolog2. In the popup command line window login as SYSDBA, to enter: System username/Login Password @ DB instance name, such as sys/[email protected]3. Enter ALTER DATABASE backup Controlfile to

Oracle Action Table "Resource is busy, need to specify nowait" method of unlockingProblem:When executing drop table table_name, the prompt "resource is busy, you need to specify NoWait"PL/SQL is not responding due to a problem that can only be

2.1 char field , varchar2 field(1) define the field length char (x) indicates that the field can hold up to ten characters in English (regardless of the encoding method, does the English character account for ten bytes?). ), and when allocating

First, IntroductionHave been confused about the Oracle database client, how to configure, a few days ago because of the need to use Oracle, and the need to connect two different databases, through the Internet and ask colleagues finally put the

[ORACLE] Methods for adding and deleting disk members in an ASM disk Step 1: Disable the database shutdown immediate Step 2: Check the mounting diskgroup status of the dg. SQL> show parameter diskgroup Alter diskgroup dgdata mount; Step 3: view the

Import large amounts of data into the database, dbf import oracle, csv import oracle In Excel 07-2003, a worksheet can have a maximum of 65536 rows and a maximum of 256 columns. In Excel 2007 and later versions, a worksheet can have a maximum of 1048

Restore the entire process of Oracle10g when the operating system is damaged Environment: oracle10g, operating system 5.2 The database system is under rootvg/oracle file system, The data file is under datavg/oradata File System The control file is

Dynamic SQL and oracle dynamic SQLDirectory 1. Pass values to dynamic statements (USING clause) 2. Retrieve values from dynamic statements (INTO clause) 3. Dynamic call stored 4. Pass the return value to the PL/SQL record type. The % rowtype