Oracle

[What is an index]In a relational database, an index is a data structure associated with a table that makes it faster to execute a query's SQL statement. In fact, the index is like a book directory, we can quickly find the content according to the

Database large segment (CLOB, BLOB) is not suitable for storing more than 1MB of dataTypically, the database provides a large segment type such as Clob,blob,text,long to hold more than 4K of data, however this does not mean that large fields should

The large file tablespace is a new table space type introduced by oracle10g and later versions, primarily for troubleshooting large files. Unlike normal table spaces, a large file table space can only correspond to a single data file or temporary

--Table Space fileSELECT * from Dba_data_files;--Table space occupancySELECT A.tablespace_name,a.bytes/1024/1024 "Table space size (M)",(a.bytes-b.bytes)/1024/1024 "used Space (M)",b.bytes/1024/1024 "free Space (M)",Round (((a.bytes-b.bytes)/a.bytes)

1 Node 2 use DBCA to delete a node 2 node 1alter database disable thread 2; 3 Node 1 Verify that a node database has been deleted [03:49:06 Oracle (DB) @rac1 ~]$ srvctl Config database-d proddatabase Unique name:proddatabase name:prodoracle home:/u01

Oracle View native Service nameSelect Global_name from Global_name;Database Listener.ora# Listener.ora Network Configuration File:e:\app\chenjz\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration

GROUP BY Cube Take a look at the first statement:Select Deptno, Job, sum (SAL) Sal from EMPGroup BY Cube (DEPTNO, Job)Order BY Sal;This output can be seen, there are deptno empty, there is job is empty, there are empty, of course, there are

Introduction Intra-company projects tend to implement business logic in Oracle stored procedures, so each project upgrade involves the upgrading of database objects such as many Oracle tables, stored procedures, and so on. However, the upgrade

Oracle Database helps Shanghai Free Trade Zone build a powerful Information System Platform On June 23, October 31, 2014, China Shanghai) Pilot Free Trade Zone (hereinafter referred to as "Shanghai Free Trade Zone") announced the adoption of Oracle

Temporary tables, external tables, and partition tables in OracleTemporary tables, external tables, and partition tables in OracleTemporary table In Oracle, a temporary table is "static". It only needs to be created once like a common data table.

Powerful booster for Oracle database selection to optimize data centers In the era of cloud computing and big data, the ever-changing business environment puts more stringent requirements on enterprise IT infrastructure. In order to provide strong

Oracle subquery, create, and manage tablesSummarySubquery: Single Row subquery: returns a single rowUse Single Row comparison OperatorsMulti-row subquery: multi-row subquery returns multiple rowsMultiline operators:IN, ANY, ALLIf the query result of

Oracleexp appears & quot; ORA-00302: must describe the SET_NO_OUTLINES component & quot; Solution1. Problem Description Using the oracle exp tool, oracle 11g is installed on my client, and oracle 9i is installed on the server. The following error

Oracle basics-Index 1. What is indexing? A: indexes are used in databases to improve query efficiency. Supplement: too many indexes can greatly reduce the efficiency of DML statements. The indexing principle is to create fields that are frequently

[Oracle] Sequence object usage Sequence: oracle can generate primary keys through sequences.1. Create a sequence Create table Foo (foo_id number (11), foo_value varchar2 (50), constraint FOO_PK primary key (foo_id )) Create sequence DDL Create

Oracle: Other Data Objects (sequences, indexes, synonyms)1. sequence) Sequence: A set of database objects that can be used by multiple users to generate unique values.Unique value automatically providedShared objectIt is mainly used for primary key

Oracle flash back flashbackFlash back: fixed a logic error and returned from the current point.1. There are dedicated flashback logs stored in the FIA, but they are only used in the database. 2. If a full database flash is performed, it is

Oracle users unlock lockd The following error is reported when the user doiido connects to oracle: ORA-28000: the account is locked View user statusSQL> conn/as sysdba SQL> SELECT username, account_status FROM dba_users; USERNAME

Tomconrefused solution for tomcat7 connection to oracle The server. xml configuration of tomcat is as follows:   The error message is as follows:     java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169870592)

Implicit Oracle ConversionsIt is said that Oracle has implicit conversions of the NUMBER and VARCHAR2 types, which must be avoided in a strict sense, but why should we avoid them? We will verify it from the following experiment.1. Create test tables