Oracle

Author: runming 2012-2-1 QQ: 226399587 http://blog.csdn.net/runming918 This article describes the concepts and operations of Partitioned Tables from the following aspects:1. Concepts of tablespaces and partition tables2. Specific functions of table

Materialized View is a special physical table. The Materialized view is relative to a common view. A common view is a virtual table, which has many application limitations. Oracle converts any View query to a view SQL statement query. This improves

Recently report data source switch to the query database, the query reported ORA-25153: Temporary tablespace is empty, it is strange, some queries have problems, some normal, switch to the business database Normal. The system database www.2cto.com

Query table field details select column_name, data_type, data_length, DATA_PRECISION, DATA_SCALE from all_tab_columns where table_name = 'tablename' field comment select * from user_col_comments; Table comment select * from user_tab_comments; it

1. set SQL code SQL> archive log list in archive mode; # Check whether archive mode is used. SQL> alter system set log_archive_start = true scope = spfile; # enable active archiving SQL> alter system set log_archive_dest = ''location

During the Asktom and Eygle Shanghai discussion at ORACLE, eygle proposed: "What is the maximum size of ORACLE Redo logfile ". This issue is rarely noticed. Because redo logfile is used cyclically, there is no need to configure a large number of

Problem:During database migration, if the table contains LOB fields (BLOB, CLOB, etc.) and IMP fails, the system prompts that the tablespace does not exist.Cause:All data of the LOB type is stored in the tablespace, and only the pointer is stored in

1. Choose "start"> "Settings"> "Control Panel"> "Administrative Tools"> "services" to stop all Oracle services. 2. Start-> Program-> Oracle-OraHome81-> Oracle Installation Products-> Universal Installer uninstalls all Oracle Products, but the

When you roll back to fisrt (), note that you need to move the cursor to the first line before using previous (); package com. trs. util; www.2cto.com import java. util. calendar; import java. util. date; import java. util. properties; import java.

In oracle 9i/10g, if the database instance does not have the scott mode, you can manually create it as follows:Log on to the databaseCreate scott userAssign permissions to scott users Use scott to log on to www.2cto.com1. Execute the following SQL

When do you need to use these two time periods? To put it simply, if you pay off the monthly subscription product you purchased on April 9, March 15 at the end of the month, you will be charged for 17 days, at this time, you should determine whether

RANGE partitions of Oracle table partitions use the range partition syntax for values of one or more columns in the table: [SQL] PARTITION BY RANGE (column_name) (www.2cto.com PARTITION part1 value less than (range1), PARTITION part2 value less than

Create a table, prompting ORA-00959: tablespace 'mc _ data' does not exist solution first, first confirm the current user's tablespace. Select username, default_tablespace, temporary_tablespace from dba_users where username = 'mcmidyl'; www.2cto.com

1. What is RMANRman (Recovery Manager)? It is an important tool for DBAs after Oracle 8i. It is generally located in the $ ORACLE_HOME/bin directory,It is mainly used for backup, recovery, and recovery. You can achieve full recovery and Incomplete

Related Links: Exploring the RMAN_01 concept of ORACLE http://www.bkjia.com/database/201205/132243.html RMAN is an implementation tool launched by Oracle8i to better implement database backup and recovery. It can achieve online database backup and

Test oracle 11g fixed execution plan-Baseline1. Select SQL _id [html] SQL> pagesize 300 SQL> set linesize 300 SQL> set autotrace on SQL> var name varchar2 (10); SQL> exec: name: = 'it'; select department_name from hr. orders ments dept where

ORA-12519, TNS: no appropriate service handler found problem Java code ORA-12519, TNS: no appropriate service handler found The Connection descriptor used by the client was: 110.16.1.17: 1521: orcl www.2cto.com solution: the current number of

Similar to indexof in oracle, The _ instr function [SQL] does not have the indexof () function in oracle, but an instr () method is provided. Specific usage: select instr ('baoding nanchengqu ', 'city',)-1 from dual; Explanation: 1. 'baoding city

Oracle _ users only have permission to access other USER views -- CREATE user lf identified by lf profile default tablespace user temporary tablespace temp account unlock; -- grant permission to create session to query_dqb; grant select on

Related Links: Exploring the RMAN_01 concept of ORACLE E/201205/133559 .html; explore ORACLE RMAN_06 backup policy the ultimate goal of http://www.bkjia.com/database/201206/136832.html backup is to better restore data recovery and recovery, in the