ROUND Role: According to the specified decimal precision for rounding of numerical computation. Syntax: ROUND (source number, decimal precision). If the specified decimal precision n, the effective number to round the right side of the decimal point ...
LOWER Role: to convert a string to uppercase letters lowercase forms, numbers, punctuation marks and special characters remain unchanged. Syntax: LOWER (s) When the data and the date literal as a parameter appears, they will be implicitly converted t ...
Simplify the use of the general function of the column may contain null values. These functions accept all data types of input parameters. NVL function NVL function to assess any data type of column or expression is not empty. If the original item is ...
SYSDATE Role: back to the database server current system date and time. Syntax: SYSDATE By default, the format mask as: DD-MON-RR. SYSDATE will not return to the local system date and time. MONTHS_BETWEEN Function: Returns the number of months betwee ...
Installed in the windows of oracle9i, from the uninstall program can not find, oracle manually delete the installation directory will reportedly not delete ociw32.dll: Access denied, source file may be in use. Approach is to stop the Distributed Tran ...
ORACLE PATCH Copy the following address information where you can download mine. oracle 9206 patch: ftp://updates.oracle.com/3948480/p3948480_9206_AIX64-5L.zip ftp://updates.oracle.com/3948480/p3948480_9206_HP64.zip ftp://updates.oracle.com/3948480/p ...
A physical, required to support virtualized CPU, memory, great point, install RHEL 5.5, installed using LVM. rn KVM virtual machines with 2, rac1, rac2 rn LV partition Virtual Machine rn A 10G partition the space to the virtual machine rac1, lv-rac1 ...
Problem description: With the normal use plsql sqlplus when landing the same user login with a database error when: Initialization Error SQL * NET is not fully installed OracleHomekey: software / oracle OracleHomedir Solution: In PLSQL Developer Sele ...
1. Minimum hardware requirements: 256M of physical memory # grep MemTotal / proc / meminfo 512M swap partition # grep SwapTotal / proc / meminfo 400M of / tmp space # df-k / tmp 180M to 1.9G in the installation space 2. System support package: make-3 ...
1> USERENV (OPTION) Returns the current session information. OPTION = 'ISDBA' if the current is the DBA role, compared to TRUE, otherwise FALSE. OPTION = 'LANGUAGE' returns the database character set. OPTION = 'SESSIONID' f ...
There are many causes of error data records deleted, and how to restore mistakenly deleted the records show? First look at the concept: SCN (system change number), full-spelling it in English as: System Change Number, which is a very important databa ...
Operating system authentication Window System, you must ⊕ login user must be ORA_DBA or ORA_ [SID] _DBA group members ⊕ REMOTE_LOGIN_PASSWORDFILE set = NONE Little effect on this step, but said the plane landed, then use ORAPWD created passwords. ⊕ S ...
Oracle 11g there is the password expired problem [Description] problem Oracle database using sqlplus login prompt "ORA-28002: 7 days after the password will expire." [Reason / trigger factors] To determine because of oracle11g default profi ...
Oracle 11g there is the password expired problem [Description] problem Oracle database using sqlplus login prompt "ORA-28002: 7 days after the password will expire." [Reason / trigger factors] To determine because of oracle11g default profi ...
D generated in a disk file test.sql Which reads: Ah ... is to sql> spool filename beginning .... to sql> spool off .... the end of the middle of everything saved to the filename in the .........
Nested loop join today to do the test, collect statistical information mode ORA-03001 error occurs. Problems reproduced as follows: SQL> conn test / test Connected. SQL> create table drive (id int); Table created. SQL> insert into drive sele ...
In the configuration of Oracle 9i in use RMAN> show all; RMAN configuration parameters can be shown as: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # def ...
Ordinary table space: Select a.Tablespace_Name, Total, Free, Total - Free Used From (Select Tablespace_Name, Sum (Bytes) / 1024 / 1024 Total From Dba_Data_Files group By Tablespace_Name) a, (Select Tablespace_Name, Sum (Bytes) / 1024 / 1024 Free From ...
Lock timeout in 10g not the corresponding control, lock the duration of the timing depends on the transaction time. Transaction timeout can not set, so there is no time out of the said lock.
Oracle database cluster architect Linux systems and clusters architect Embedded kernel driver engineer <br /> Abstract: SWITCH command Daquan 1. IOS-based switches to set the host name / System name: switch (config) # hostname hostname CLI-base ...
Use imp to import the dump file. Dmp time .. there imp-00009: abnormal end of export file error. google search, generally there are two cases, one backup database version higher than the import database. Another reason is to enter into the buffer is ...
win7 install and uninstall oracle 10g Oralce 10G installation will extract all the hard disk image, find the \ stage \ prereq \ db \ under refhost.xml file add the following: <! - Microsoft Windows 7 -> <OPERATING_SYSTEM> <VERSION VALU ...
This document will guide you to use the physical backup server configuration Oracle Data Guard Fast Start Failover (FSFO). FSFO all environments can significantly improve the availability and disaster recovery preparation, from the cloud-based low-co ...
SQL> alter tablespace test begin backup; Table space has changed. Manually copy the physical files to the backup directory TEST SQL> alter tablespace test end backup; Table space has changed. SQL> alter system archive log current; System has ...
Offline document analysis steps: 1, increasing the archive exec dbms_logmnr.add_logfile (logfilename => 'D: \ oracle \ product \ 10.1.0 \ flash_recovery_area \ TRAIN \ ARCHIVELOG \ 2010_08_12 \ O1_MF_1_258_666OMB5V_.ARC', options => dbm ...
1. Chinese fonts installed: rpm-ivh fonts-chinese-3.02-12.el5.noarch.rpm 2. Oracle logged in, the implementation of emctl stop dbconsole stop oem service. 3. Cd $ ORACLE_HOME / jdk / jre / lib, then cp font.properties.zh_CN.Redhat font.properties 4. ...
Oracle's package is really a very good thing; PL / SQL procedures to meet the needs of modularity, in addition to block (block) and the subroutine structure, but also introduced a package structure. (1) package is a database object, logically rel ...
intersect operation? Return query results in the same part? exp: What are the various departments in the same jobs? select? job? from? account? intersect? select? job? from? research? intersect? select? job? from? sales;? minus operator? Return query ...
The use of SQL * PLUS command Daquan Oracle's sql * plus to interact with the oracle client tools. In sql * plus, you can run sql * plus command and sql * plus statement. We usually refer to DML, DDL, DCL statement is sql * plus statements, their ...
Made a C # and Oracle systems, think of each client also installed Oracle client does a lot of trouble, so the Internet search, is there no way to install the client, really good, Oracle has already thought of this problem. In his Web site already of ...
1, built form SQL> create table employees (employee_id number, last_name varchar2 (20), JOB_ID varchar2 (20), MANAGER_ID number); Table has been created. 2, table structure SQL> desc employees; Name is empty? Type ------------------------------ ...
Today WINDOWS ORACLE 10GR2 downloading a client. When a user is reported to run SQLPLUS when the following error: SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE does not work ADMINISTRATOR login to use no problem. GOOGLE what a ...
Oracle provides the exp program can easily export the data, but the tool does not compression. Disk space for the host strain, the better approach is to use named pipes used, the data lead to the pipe, mknod / dev / pipe p, By gzip, or bzip2 compress ...
Lpad () function usage: lpad function string left filled with specific character of its syntax is as follows: lpad (string, n, [pad_string]) string: But the character or the parameters n: characters in length, is the number of the returned string, if ...
OracleDBConsoleorcl service can not start: Agent process exited abnormally during initialization. OracleDBConsoleorcl service does not start in the event viewer saw Agent process exited abnormally during initialization.'s Record. That is because ...
NON-RAC Database Startup Giving Error ORA-29702 [ID 433310.1] Modified 27-JUL-2010 Type status MODERATED PROBLEM In this Document Symptoms Cause Solution Platforms: 1-914CU; This document is being delivered to you via Oracle Support's Rapid Visib ...
V $ SGAINFO supported versions: And follow-up version of 10g Role: The various components used to query the size of sga Result Set Example: SQL> select * from v $ sgainfo; NAME BYTES RES ----------- ---- - Fixed SGA Size 1299040 No Redo Buffers 52 ...
Free installation Oralce client to use PL / SQL Connect Oracle
32-bit RedHat Enterprise Linux 5 Update 4 installed Oracle10.2.0.1 (Reprinted) This article describes in detail to install Oracle Database RHEL5 whole process of writing the great http://bbs.chinaunix.net/viewthread.php?tid=1689136
1. Get the file number and block numbers Select Dbms_Rowid.Rowid_Relative_Fno (Rowid) fno, Dbms_Rowid.Rowid_Block_Number (Rowid) blkno, Dbms_Rowid.rowid_row_number (Rowid) rowno From Kr_Mail_Action_Day a 2.ALTER SYSTEM DUMP DATAFILE 4 BLOCK 516 3. Ge ...
Problem description In the Linux (Unix) environment successfully installed Oracle 10g, the next from the windows registry with IE browser, 10g of em, the button is the "word of mouth," so the box. Solution <br /> <br /> In fact, ...
1, DBA the most common data dictionary dba_data_files: usually used to query information on the database file dba_db_links: including all the database links database, which is databaselinks. dba_extents: a database of information for all partitions d ...
centos5.2 install oralce 10g release 2 rhel4 1. Hardware environment 1.RAM Available RAM Swap Space Required Between 1024 MB and 2048 MB 1.5 times the size of RAM Between 2049 MB and 8192 MB Equal to the size of RAM More than 8192 MB 0.75 times the s ...
Completion of the loading database. ORA-16038: log 3 sequence number 5035 can not be filed ORA-19809: exceeded limit the number of restore files ORA-00312: online log 3 thread 1: ...... REDO03.LOG ' DB is on file mode, each log is only one file ( ...
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise / Standard Edition for Microsoft Windows (32-bit) http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zi ...
Function of conversion can be divided into two types: implicit and explicit data type conversion of data type conversion Implicit data type conversions (Oracle automatically converted as needed) N2C/D2C: Character field is very flexible, allowing vir ...
Question: Ask HINT written I have a SQL to add the following hint, the purpose is to specify the hash_join way. select / * + ordered use_hash (a, b, c, d) * / * From a, b, c, d Where ... One, a relationship is only associated with the b, b and c are ...
Localization of multinational companies in China has been a topic of endless discussion, but the most serious Oracle acclimatized personnel turbulence is most typical in China. As the company has been very low key, the media is often difficult to con ...
SQL> CREATE TABLE TEST (ID INT, NAME CHAR (6), COL1 CHAR (2000) DEFAULT 'YSP', COL2 CHAR (2000) DEFAULT 'YSP', COL3 CHAR (2000) DEFAULT 'YSP'); Table created. SQL> INSERT INTO TEST (ID, NAME) VALUES (1, 'A'); 1 r ...
Master hard disk failure, replace the hard disk manufacturers, found in the boot database and ASM instance can not start 1, view the status oracle @ CHNFSCC1 [billdb1]: / home / oracle $ crs_stat NAME = ora.billdb.billdb1.inst TYPE = application TARG ...
