Oracle

Previously wrote a line-and-column article: Oracle Simple column changeSql> select * from V$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit

Oracle 11.2.4.0 ADG Single Instance installation (copy creation repository)Planning:Main:Os:linux Centos 6.5 X64Hostname:ora11g-dg1ipaddress:192.168.213.199Db_unique_name=netdata_pdDb_name=netdataPreparation:Os:linux Centos 6.5 X64Hostname:ora11g-dg2

 It's absolutely unlucky to have a bug in the language of development as a compilation of people.Because basically as grass-roots we, basically no solution, can only avoid!?Now take 2 examples to discuss with you:1Usage:Used in

Lock: is a resource that is a small piece of memory. is to control the serial operation in concurrency.If the micro is serial.Type of Lock:DML LockDDL Lock Data Dictionary lockInternal lock or latch (mutex)Sql> select distinct type from V$lock;

Orale Common Statements1: Query the field for the specified table nameSELECT * from sys.user_tab_columns where table_name= table name//query field specifying table name2: Querying Database parametersShow parameter db;3: Query The instance name of

Original: http://www.cnblogs.com/netsql/articles/1745978.htmlNote the point:1. If it is opened in a tool such as PL/SQL, directly modify the following code [ Italic bold section] to execute2. Ensure that the path exists, such as

When you normally import Excel into Oracle, here's how to summarize:1. Use OLE mode: stringConnStr ="provider=microsoft.jet.oledb.4.0;"+"Data source="+ file. xls+"; Extended Properties=excel 8.0"; OleDbConnection Conn=NewOleDbConnection

Oracle DG--Build physical Standby (one main library for multi-repository)System environment: operating system: RedHat EL6 Oracle:oracle 10.2.0.1.0650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/54/10/wKioL1R25dqSqrvxAADnIlkOMXs321.jpg

1. Connect to the server using the Liunx terminal2. Switch root account to Oracle account: Su-oracle3. Manually Start Oracle (Open the instance first, then turn on the monitor)1) Start the DB instance:Sqlplus/as SYSDBAStartupExit2) Start

3. Install the operating system3.1 On the VMware console, double-click the CD-ROM device on the right panel and select ISO image to start the virtual machine;3.2 The middle most of the default can be, select Manual partition, first only divided

If only some of the data is deleted by mistake or a piece of data can be1. Select * from the error deletion indicates that as of timestamp to_date (' Recovery date seconds ', ' Recovery time format ') where query condition ;Example: SELECT * from

1. Method One: Create DBL (data base link)CREATE Public Database link Data link name CONNECT to login user name identified by password USING ' (DESCRIPTION =(Address_list =(address = (PROTOCOL = TCP) (HOST = IP address of the other Oracle server)

First, set feedback onBy default, Oracle gives a feedback when a SQL is issued.For example, execute the following CREATE TABLE statement:CREATE TABLE t_test_lll (ID varchar2 (10));The Command Guild returns: Table created.For example, when performing

Environment version:Oracle 11g R2Windows 7 Ultimate Edition X32Steps Directory:1. Determine the database and instance name2. Confirm the database authentication method3. Create a database initialization parameter file4. Create an instance5. Connect

In the update operation for a table, in many cases, you need to refer to data other than the table you want to update in an expression. Like SQL Server provides the FROM clause of the update, you can connect the table you want to update with its

How to create a new self-increment column in Oracle, in general, need to set up a sequence and pay the sequence to a column and rebuild the trigger.The first step is to open PD, create a new PDM document, and then create a new table:The second step

Alter ANY cluster permission to modify any clusterAlter any index to modify permissions on arbitrary indexesAlter any role to modify permissions for arbitrary rolesAlter ANY SEQUENCE permission to modify any sequenceAlter any snapshot permissions to

Oracle startup error ORA-00845: MEMORY_TARGETnotsupportedonthissystem Solution Oracle start error ORA-00845: MEMORY_TARGET not supported on this system Possible cause: the ORACLE MEMORY_TARGET parameter exceeds the memory of the oracle server. Eg:

Oracle forced index using HINT First of all, it depends on whether your Oracle optimizer uses RBO or CBO,(1) If RBO is used, it will be performed in the Rule Order.(2) If CBO is used, you can use the HINT method to modify it. Syntax:SELECT/* +

Oracle Character Set modification (ORA-29275) Today, a friend of the database ORA-29275 part of the multi-byte characters, the corresponding field can only use to_char to query the normal, it is a character set problem. You have modified the