Oracle

First, Conn/as sysdba display garbled "??? “ Sqlplus/nolog Conn/as SYSDBA Display??? Workaround:To view the database language:Sql> SELECT * from props$ where name = ' Nls_language ';Setting Language:Sql>update props$ SET value$= '

1, first find out which table of the table space is not correctSELECT * from Dba_tables where tablespace_name= ' TDB ';2. Move table space in TDB to table space TDB2009The syntax is: ALTER TABLE table_name move tablespace tablespace_name;alter table

The correct syntax is:Select /*+ Index (x idx_t) */ * from T X where x.object_id=123/*+ * * and comments like, more than comments a "+", this is hintThe above hint means that Oracle is forced to take the index when executing this SQL.If the syntax

Toss for a long time not, the crux of the problem is not to find exactly which process caused the lock, v$locked_object this view and no permissions.The final solution is as follows:PL/SQL Developer inTools->sessions Open the Session window, in the

1, the official download installation package: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htmlLinuxamd64_12102_database_1of2.zipLinuxamd64_12102_database_1of2.zip 2, creating oracle Users and Groups  [Email

Stored procedures are used to perform specific operations when a stored procedure is established, you can specify either an input parameter (in) or an output parameter (out), you can pass the data to the execution part by using the input parameters

There are three ways Oracle's pagingMethod one according to rowID to divideSELECT * fromEMPWHEREROWIDinch (SELECTRID from(SELECTROWNUM RN, RID from(SELECTROWID RIDs, EMPNO fromEmpORDER byEMPNODESC) WHEREROWNUM((currentpage-1)

First, create a user overview: in Oracle to create a new user using the Create USER statement, typically with the DBA (database administrator) permissions to use. Create UserUser name identified byNote: Oracle has a problem, the password must start

DeclareV_xtxmbhNumber; V_zjzjzjrqVARCHAR2 (40);Cursor C_jobIsSELECT XT. XtxmbhAs Xtxmbh, QJ. ZjzjzjrqAsZjzjzjrqFromXtxmxx XT, Qjglxx_zql_mid QJThe WHERE XT. Xtxmbh=QJ. Xtxmbhand XT. Xtxmclrq>=‘20120630‘and (QJ. ZjqhzjrqIsNullOR QJ. ZjzjzjrqIsNull);

The Oralce table contains a field that stores the table name, queries all the table names in the table (that is, the table name result set), and executes the result set from the table name result set:DeclareV_ccountvarchar2( -); --defining a cursor

I. Naming rules for table and column names1), must start with a letter2), length cannot exceed 30 characters3), cannot use Oracle's reserved words4), use only the following characters a-Z,a-Z0-9, $, #等 ii. data type1), character classesCharfixed

in Oracle database operations, we sometimes use lock table queries and operations such as unlocking and kill processes, so how are these operations implemented? In this paper, we mainly introduce this part of the content. (1) The Code of the Lock

1. Delete the primary key ALTER table TABLENAME drop Primary_key Execute the above SQL to remove the primary key; If unsuccessful, you can use ALTER TABLE TABLENAME drop CONSTRAINTS COLUMN Cascad E --delete constraint alter TABLE TABLENAME DISABLE

Very often we will appear, for example, if a piece of data already exists in the table, update it, assume that it does not exist, and insert the new data. Assuming that you don't use the merge syntax provided by Oracle, you might want to check the

Oracle to remove line breaks after a lot of data is stored in the database, you may need to take the whole piece of data out and split it with a special symbol, and the whole piece of data must be on one line, so if the data is wrapped, then there

Oracle PRIMARY KEY auto-growThese days to make Oracle, to let the table's primary key implementation automatically grow, check the network implementation is as follows:CREATE TABLE Simon_example(ID Number (4) Not null primary key,Name VARCHAR2 (25))-

Oracle RAC 10.2 storage options on LinuxBlog Category: Oracle Oraclelinux Project Management configuration ManagementOracle clusters require storage of software and data Project Content Minimum disk space

[Email protected] ogg]$./ggsci./ggsci:error while loading GKFX libraries:/u01/app/oracle/ogg/libclntsh.so.11.1:cannot restore segment Prot after re Loc:permission deniedTurn off SELinux, First modify the parameters[Email protected] ~]#

Oracle primary key deletion, joint primary key Creation1. Delete the primary key alter table tablename drop PRIMARY_KEY execute the preceding SQL statement to delete the primary key; if it fails, use ALTER TABLE TABLENAME DROP CONSTRAINTS COLUMN

Adjusting the size of oraclesga causes ORA-00851 and ORA-00844 errors Today, I adjusted the sga size. As a result, the following error is returned when I restart the database.SQL> alter system set sga_max_size = 1024 M scope = spfile;SQL> shutdown