Oracle

1. Delete ocr, vote, and data disks. (1) After the database is backed up, stop the database and use dbca to delete the database. (2) Remove diskgroup Enter Node 2: export ORACLE_SID = + ASM2 Sqlplus/as sysdba Alter diskgroup dgdata dismount; Enter

1. Set the master database to force loging mode. 5:48:54 sys @ felix SQL> alter database force logging; -- Verification: 16:10:00 sys @ felix SQL & gt; selectforce_logging from v $ database; FORCE _ ------ YES Check the Master/Slave database

Oracle queries the DBA_SEGMENTS table to obtain the tablespace file information, including the tablespace name and size. Select tablespace_name, sum (max_size), sum (bytes) from dba_segments group by tablespace_name; Max_size and bytes are

Symptom description: In linux, using sqlplus sys/oracle @ prod as sysdba to log on is very slow. It takes about a dozen seconds to log on successfully. Using sqlplus/as sysdba to log on to the database is fast and fast. Using sqlplus sys/oracle @

Oracle compression technology includes basic table compression, OLTP table compression, and index compression) and hybrid column compression (hybrid columnar compression (HCC )). Basic compression was launched from 9i and is the default compression

Oracle considers null to be the largest. Sort in ascending order. By default, the null value is placed behind. Sort in descending order. By default, the null value is ranked first. How to change the null value: (1) Use the nvl function or decode

Ant 1.8.2 is deployed on machine 241 and oracle 11g is deployed on machine 242. the following error is reported when ant 1.8.2 is used to insert data to the oracle 11G environment through the oracle DRIVER: builddb:BUILD FAILED/home/build.xml:10:

DG is divided into the master database and the slave database. We also guess that it belongs to the interaction between primary and standby, so the switchover between primary and standby: However, switching is divided into switchover and failovers.

Use Vertica to construct a calendar:SELECT to_number (TO_CHAR (ts: DATE, 'yyyymmdd') as day_id,Year (ts: DATE) as year_of_calendar,Month (ts: DATE) as month_of_year,Dayofweek (ts: DATE) as day_of_weekFROM (SELECT '01-01-2013 ': TIMESTAMP as

After I restart my computer recently, I open two oracle-related services but cannot connect to them. Sometimes open Z producer? Http://www.bkjia.com/kf/ware/vc/ "target =" _ blank "class =" keylink "> vcmFjbGW3/release + zvHXtMysyLTP1Mq + release +

Statistical information is very useful. Without it, the SQL optimizer is like a clever man! A good and efficient SQL Execution Plan depends on real statistics. However, in some cases, for example, to compare the execution plans of the production

The oracle 10g clusterware processes on UNIX-based systems are: Oracle Clusterware Oracle-provided clusterware that manages clusterdatabase processing including node membership, group services, global resourcemanagement, and high availability

In Windows, Oracle backs up data every night through EXP and retains the backup data for ten days. 1. Create the backup script oraclebackup. bat Contents: @ Echo offEcho deletes the backup file and log 10 days ago. Forfiles/p "E: \ oraclebackup"/

  Processing certain data requires reading data from Oracle Because there is not much Data, it is simple and convenient to directly use System. Data. OracleClient Add references, write SQL statements in one breath, and report an error immediately

Oracle and firewall settings To access the windows oracle database after the firewall, simply open the fixed TCP port. The root cause of this problem is the BT design of the windows oracle Database (this problem is not found in unix/linux ).I.

LPAD (c1, n [, c2]) [function] fill string c2 on the left of string c1, until the length is n, [parameter] C1 string n append total length c2 append string, default is space [Return] character type [description] If c1 length is greater than n,

A role is a set of related permissions. The main purpose of a role is to simplify permission management. Once the permissions of this set exceed the minimum requirements of users, it may bring security risks to the database. Role password Test In

Oracle packages are divided into package specifications and packages I. Create a package specification first Create or replace package p_pagewithgroup is-- Author: Xiao Wei-- Created: 2014/3/18-- Purpose: group paging ProcessTYPE type_cur is ref

Check whether the tablespace in the database is idle and used to add data files to the tablespace. View the percentage of tablespaces used Code   Select. tablespace_name,. bytes/1024/1024 "Sum MB", (. bytes-b.bytes)/1024/1024 "used MB", B. bytes/102

Assume that there are two tables a and B. UseOn Select * from a left join B on B. col = a. col and B. col2 = 'A' UseWhere Select * from a left join B on B. col = a. col where B. col2 = 'A' and B. col2 is null // B. col2 is null is used to prevent