Create test table SQL> create table alice.user_stats ( 2 id number primary key, 3 username varchar2 (4000), 4 app blob) 5 partition by range (id) 6 (partition part01 values less than (50), 7 partition part02 values less than (maxvalue)) 8 / Create ...
oracle string handling summary 1, NVL () function In Oracle / PLSQL, the NVL function lets you substitute a value when a null value is encountered. The syntax for the NVL function is: NVL (string1, replace_with) string1 is the string to test for a nu ...
Oracle Database 10g introduces the new Data Pump (Data Dump) technology to DBA or developer to the database metadata (object definitions) and data quickly moved to another oracle database. Data Pump Export Import (EXPDP and IMPDP) role 1, to achieve ...
Still view technology UOA-Database Cluster Architect (V6) View 50,000 annual salary employment yet signed the guarantee agreement, but are not working 100% refund of all tuition (Not recommended by the so-called employment agreement or employment agr ...
Query data in the database, we often encounter the problem and the date time format, such as display language, display format. Data may be stored in the database format is: YYYY-MM-DD HH24: MI: SS, but we check out is 22-1 -10 months, the first react ...
1. Download cx_Oracle * Http://cx-oracle.sourceforge.net/ 2. Installation [Root @ atyu30 opt] # rpm-ivh cx_Oracle-5.0.4-10g-py24-1.x86_64.rpm Preparing ... ########################################### [100% ] 1: cx_Oracle ############################# ...
1. Table space Create table space create tablespace ts_name datafile '/ path/file1.dbf' size 200M, '/ path/file2.dbf' size 200M default storage (initial 64k next 64k maxextents unlimited pctincrease 50); The following parameters affec ...
oracle time integrated addition and subtraction Addition select sysdate, add_months (sysdate, 12) from dual; - plus 1 year select sysdate, add_months (sysdate, 1) from dual; - increase in January select sysdate, to_char (sysdate +7, 'yyyy-mm-dd H ...
1.OS authentication After Oracle installation is enabled by default, OS authentication, certification mentioned here refers to the server os os authentication. OS certification means the database user login and password checking on the operating syst ...
Oracle Crystal Ball 11.1.2 installation documentation, and sharing for everyone to interact! File: Installation and Licensing Guide.pdf Size: 735KB Download: Download
Three authentication methods: Database OS Network Involving two parameters os_authent_prefix remote_os_authent To sum it up here, good-looking: os_authent_prefix = ops $, the operating system user authentication and password authentication via sqlplu ...
# Enable block change tracking feature, and asked the paper to create change tracking SQL> alter database enable block change tracking 2 using file 3 'D: / oracle/product/10.2.0/DataBase/bct/changed_block_tracking.log'; Database has been c ...
From oracle 9.2, the jdbc driver on the naming will be changed, JDK1.1, JDK1.2 driver name (class12.jar) will not change Has been allowed to continue, start the driver from the JDK1.4 famous of all changes, such as: JDK1.4 driver named ojdbc14.jar Th ...
Rman is to provide an ORACLE backup and recovery tool that can be used to back up and restore the database files, archive logs and control files. It can also be used to perform complete or incomplete database recovery. Now review review. In solaris 1 ...
For reading, you can build more write-oriented index, as little as possible index oltp - real-time transaction - less indexes olap - - more indexes b-tree index--nonleaf/leaf Bitmap index
1. Oracle10G unable to access a customer reflects EM 2. SQLPLUS login through the normal testing, case, monitor all normal 3. Landing EM: C: \ Users \ Jacky \ Pictures \ a0a48381f20c8ee59023d926.bmp 4. Check database EM the following error: 2005-03-1 ...
oracle load.sh through the shell of the sqlldr to re-package, so sqlldr easier to use, more convenient to import the text without too much trouble re-configuration sqlldr control file. 1 can pass parameter specifies the separator-a 2-e specify the li ...
Today, customers do encounter the project will not write a sql statement, summary, table structure is as follows: cat table: (store category table) categoryid catname 1 cat1 2 cat2 3 cat3 catpro table: (the relationship between product and category t ...
1. Oracle10G unable to access a customer reflects EM 2. SQLPLUS login through the normal testing, case, monitor all normal 3. Landing EM: C: \ Users \ Jacky \ Pictures \ a0a48381f20c8ee59023d926.bmp 4. Check the database error EM are as follows: 2005 ...
oracle 11g sqlldr also loaded in a record can be used to binding two tables, such as 2 table: CREATE TABLE "SCOTT". "TESTSQLLDRA" ("TESTSQLLDR" CHAR (10), "TESTSQLLDRNO" NUMBER, CONSTRAINT "TESTSQLLDRPK&qu ...
rn RMAN> connect target / ------------------------ rman target / ------------------------ rn channel (control the behavior of RMAN backup) Start a process on the target server rn limit read rate limit kbytes limit maxopenfiles -------------------- ...
ORACLE in the user management, create, delete, and query syntax: CREATE USER username IDENTIFIED (BY password | EXTERNALLY) [DEFAULT TABLESPACE tablespace_name] [TEMPORARY TABLESPACE tablespace_name] [QUOTA [n [K | M]] ON tablespace_name] [PASSWORD E ...
Check the log error is as follows: Stack: [0xffe0b000, 0xffffd000), sp = 0xffff9db8, free space = 1979k Native frames: (J = compiled Java code, j = interpreted, Vv = VM code, C = native code) C [libc.so.6 +0 x62b69] __libc_free +0 x49 C [libclntsh.so ...
PCC-02344: host variable array size mismatch. Using minimum: size Cause: Host variable arrays in a single statement should all be of equal size. Action: Redefine the bind variable array lengths to all be the same size. Met here today warned people to ...
SQL> set linesize 800 SQL> select * from user_synonyms;
Question: I will be Oracle's memory management to automatic memory management, the emergence ORA-00844 error, can be solved? Answer: This error should not be counted as Oracle's bug, because you set up Oracle's MEMORY_TARGET parameter val ...
Check the log error is as follows: Stack: [0xffe0b000, 0xffffd000), sp = 0xffff9db8, free space = 1979k Native frames: (J = compiled Java code, j = interpreted, Vv = VM code, C = native code) C [libc.so.6 +0 x62b69] __libc_free +0 x49 C [libclntsh.so ...
grid control 10.2.0.1.1 Installation Notes 1.hostname Network: To make use of static IP, / etc / hosts file format is very important, do not know is a BUG or a requirement is less stringent. I started to eat the loss is in this, when demand in preche ...
Today, a friend installed oracle problem, think of a two years ago to write a script to automatically install environment rhel4.6, oracle 10.1.0. , Run the process in detail in the records of the installation log. Posted easy everyone would be requir ...
People new to ORACLE instance and the database will certainly puzzled by the representative examples in the end what? Why the emergence of this concept? ORACLE instance = process + process using the memory (SGA) Instance is a temporary thing, you can ...
File: [Think twice Notes] a comprehensive study and the partition table and partition index. Pdf Size: 363KB Download: Download File: Oracle SQL.zip learning from practice Size: 1643KB Download: Download
Two I / O mode of operation were: through the index to access, will cause db file sequential read (sequential read) Order: by full table scan to access, will cause db file scattered read (Random Read) Wait events v $ SESSION_EVENT Waiting for the mai ...
We in the application of ORACLE, they might encounter many seem difficult problems, particularly right novice, today I put it briefly summarize what, publish Ji 大家, we want to help! With everyone Tan Tao progress together! ORACLE is not on the master ...
When you apply ORACLE may experience a lot of the problems seem difficult, especially for novice, and today I briefly summarize it, release to you, we want to help! And everyone of progress together! ORACLE is not on the master to see. 1. Oracle inst ...
Oracle used dump command. 1. Memory Dumps 1). Global Area ALTER SESSION SET EVENTS 'immediate trace name global_area level n'; 1 contains the PGA 2 contains the SGA 4 contains the UGA 8 contains indrect memory 2). Library Cache ALTER SESSION ...
http://blog.sina.com.cn/s/blog_405bdbdd0100d771.html
Alternative explanation of key (alternate key) SQL Tips: The only constraint so-called unique constraint (unique constraint) is a data table, however, another alternative key name only. Replacement key (alternate key) can be a data table as the prima ...
The talk about high-level grouping queries using, of course, the primary use I do not like to write, after a meeting on the use of space. First going to review a few common functions grouped query (GROUP FUNCTIONS): AVG, SUM, STDDEV, VARIANCE (A) review G
Today in the full library with 11GR2 client version of the database export 10GR2 Times ORA-00904 error. C: \> exp userid = system / manager @ uatdb2 file = full.dmp full = y buffer = 10485760 Export: Release 11.2.0.1.0 - Production on Thursday Jul ...
Environmental Description: Physical machine: 2C +4 G +1 TB PC machine (non-SERVER) VMWARE: 2C +2 G +100 G Large table: "EI_SRCDATA_HIST". "OF_05_CL" 25.20 GB 178690871 rows OWNER SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME BYTES/102 ...
When we submit After a sql statement, Oracle bind variables to check the shared buffer pool (shared pool) in exactly the same with or without the related statements, if any, can only perform a soft analysis, otherwise may be hard analysis. The following a
Encountered ORA-29701, 11gR2 ASM instance startup fails
Oracle wait events is an important measure of operating conditions based on Oracle and indicators. The concept of waiting for the event introduced in Oracle7.0.1.2, roughly 100 to wait for the event. In Oracle 8.0 in this number increased to about 15 ...
Symptoms: Service in Oracle listener and instance of the state is "Started", the normal state; landing application error: "Oracle has been shut down or are in the start." Sign SQLPLUS, mandatory start: startup force; Tip: ORACLE i ...
Written one: use the variable sessionA> create or replace procedure t_p is 2 x varchar (20): = 'abb'; 3 begin 4 dbms_output.put_line (x); 5 execute immediate ('insert into big_table_1 values ('''|| x ||'''); 6 e ...
File: The index of basic principles. Pdf Size: 686KB Download: Download
oracle backup into full backup and incremental backup incremental backup: diffrential incremental and cumulative incremental follow: 1.differential incremental backup Definition: back up the same level or lower than the same level. analyse: Sunday ha ...
In many cases, we may want to set a column default value to avoid NULL values exist, but if set properly, it will bring the performance of the hidden dangers. SQL> conn ysp / ysp Connected. SQL> drop table test purge; Table dropped. SQL> CRE ...
http://www.itpub.net/showthread.php?s=&threadid=109787 You can find Biti_rainy, Chao_ping, Coolyl, etc. For more discussion on this topic.
There are three isolation level oracle read commited submit time, this is the default isolation level Serial read serializable read only read-only Serial Read isolation level guarantees that the serial transaction starts reading the contents of the a ...