Oracle

First, about the uninstallation of OracleIn the previous blog we mainly introduced the basic concepts of Oracle, architecture, installation procedures, etc., but the design of the uninstallation of Oracle did not do a detailed introduction, but if

A table connection is required for multiple table queriesConnection can be divided into: (self-Baidu)Cross Join (Cartesian product of the digital logic, no explanation)Equivalent connectionFor example: SELECT * from T_a, t_b where t_a.xx = t_b.xxNo

[Oracle][onlineredo] The corresponding policy when the database fails to start: 1. Start with mount.   sql> conn/as sysdba   sql> startup Mount  2. Check the redo log in which v $ log failed.   sql> SELECT * from v $ log;    ===> If

1. Export the database instance:operate under the cmd command:Exp database user name/password @ server ip:1521/ Example file=c:\devdb.dmp full=y2. Import the database instance:Create the related database, set up the related table space + user +

The recent systematic study of Oracle SQL statement Performance Tuning has come to the conclusion that many performance tuning on the web is wrong or not comprehensive.Now the DBA Daniel are too low-key, not come out treatise, the younger brother to

When Oracle is installed, the specified SID already exists on this computer if it appears. Such an error. This is the second time you've installed your Oracle, and the error is that you didn't have to clean up the original stuff about Oracle, so let'

[Oracle] fast way to construct large amounts of data:CREATE table tab001 (ID integer primary key, Val varchar2 (100));INSERT INTO tab001Select I+j,rpad (To_char (i+j), +, ' A ')From (With DATA2 (j) as (Select 0 J from DUALUNION ALLSelect j+1000 from

Oracle users, roles, permissions, etc.Privilege Management is the essence of Oracle systems, where different users log in to the same database, may see different numbers of tables, and have different permissions. Oracle's permissions are divided

There are several items in the Oracle constraint state that can be confusing, for each of them: enable/disable--whether to enable/disable validate/invalidate--Confirmation/Not confirmed Deferrable/not deferrable--can be

[Oracle] Why Archivelog was not removed immediatelyThe customer has set up the Archivelog deletion policy is CONFIGURE Archivelog deletion policy to applied on all STANDBY;So, he thinks that as long as the standby side commits, it should be

The client asked which side of the data buffer was cached across Dblink, when combined with local and remote tables.The result of the test is that the local cache is locally cached and the remote table is cached at the remote end.# # #Testcase-0929-1

Specify the instance name and modify IP address of the listener in the Listener.ora file:View instance name: [localhost$] Echo $ORACLE _sidLISTENER = (description_list = ( DESCRIPTION = ( address = (PROTOCOL = IPC) (KEY = EXTPROC1521))

--Query The SQL statement being executedSelect A.program, B.spid, c.sql_text,c.sql_fulltext,c.sql_idFrom V$session A, v$process B, V$sqlarea cwhere a.paddr = B.addrand A.sql_hash_value = C.hash_valueAnd a.username is not null;--- query executed SQL

1. Tablespace read-onlyTo view the current table space status[Email Protected]>column file_nameformat A60[email protected]>columntablespace_name format A20[email protected]>SelectTablespace_name,file#,file_name, v.status,v.enabled fromDba_data_files

When you use a report with a database, you often encounter matrix transpose. This requirement in Excel is easy to implement, but many people do not know how to use the Oracle database implementation, the following shows you a few ways to use SQL

SQL1: --1, view the name and size of the tablespaceSELECT T.tablespace_name, round (SUM (Bytes/(1024x768)), 0) ts_sizeFrom Dba_tablespaces T, Dba_data_files DWHERE T.tablespace_name = D.tablespace_nameGROUP by T.tablespace_name;--2, view the name

Some time ago there is a need to export the database of 500 table structure, using the Plsqldev tool can also export the build table statements, but need to manually a table one table, very laborious. I wrote a splice of SQL.Select ' Select

CENTOS7 Minimal Installing the Oracle 11GR2 environment VM12+the newly installed CENTOS7 x64 minimal#root some softwareYum Install wget UnzipNet-tool-y#root Installation Environment automatic configuration CD/etc/Yum.

Returns 1-31, or 1-12, or aSelect RowNum From dual Connect by rownum Is connect byhttp://marcospring.iteye.com/blog/1721600Oracle gets a list of months between a time periodGet a list of months between a time period (example returns a list of months

#!/bin/bash# set Oracle Database run account and Oracle's system environment variables Export oracle_base=/data/oracleexport oracle_home= $ORACLE _ Base/product/10gexport oracle_sid=testexport path= $ORACLE _home/bin: $HOME/bin: $PATHexport  ld_