Oracle

The Oracle synonym (synonyms) is literally an alias. Similar to the attempted function, it is a ing relationship. This topic describes how to create a synonym statement, delete a synonym, and view a synonym statement.Summary of oracle Synonyms:The

> IntroductionIn daily development, Oracle stored procedures are used to handle the case that multiple cursors are returned. The following describes how to use the Jorm framework to handle this situation. > Database preparation1. TableCreate table

  Permission: Create session   Create table   Unlimited tablespace   Connect   Resource   Dba   Example:   # Sqlplus/nolog   SQL> conn/as sysdba;   SQL> create user username identified by password   SQL> grant dba to username;   SQL> conn

Relationship between instances and databasesThe database can be loaded and opened by multiple instances, and the instance can load and open a database at any time point.· An instance is a group of background processes (Unix/Linux), threads (Windows),

  Thomas Kyte summed up his successful experience in Oracle programming art, which is excerpted as follows:   Summary of successful experiences: · Whether applications built based on databases (or databases) are successful depends on how databases

  Software environment: 1. Operating System: win xp 2. Database: oracle 10.2 3. installation path: d: \ oracle 4. test the class Directory: d: \ test Premise: If you use an external call to the java program, make sure that the jdk under the oracle

  Oracle Net can be used for communication between databases: a user session of a database can execute SQL statements for another database. This can be done through the database link.     Create database link sync Connect to store identified

1. Custom composite variable query and output case:DeclareTYPE myrecord is record (Aa varchar2 (10 ),Bb varchar2 (10); -- defines compound VariablesRecord1 myrecord;BeginSelect a1, a2 into record1 from a where a2 = 'mmm'; -- assign a value to the

ORA-14037: partition limit for partition "P2" is too highCreate table PROVINCE_INFO(PROVINCE_ID VARCHAR2 (8) not null,PROVINCE_NAME VARCHAR2 (40) not null,CREATE_DT DATE)Partition by range (PROVINCE_ID )(PARTITION P1 values less than ('8

This article briefly introduces how to register A database instance on one machine to another machine, for example, registering A database instance on machine A to machine B. 1. Check the status of listener of machine B before machine A registers

The output of this command shows that the duplicate command of Oracle RMAN is executed internally and has a deeper understanding of cloning.For demonstration of the previous steps, see:Http://andylhz2009.blog.51cto.com/728703/771481 C: \ oracle \

PrefaceRecently, the company's technology and R & D have been asking me about how to set memory parameters to optimize oracle performance. So I took the time to sort out this document for reference. Purpose We hope to organize this document to give

# Log on to the Database Host using an oracle user (ssh or telnet)$ Ssh oracle @ Database Host IP# Log on to the database as sysdba$ Sqlplus "/as sysdba"SQL * Plus: Release 10.2.0.4.0-Production on Mon Oct 10 15:53:45 2011Copyright (c) 1982,200 7,

Oracle view users, user permissions, user tablespaces, user default tablespaces 1. view the relationship between users and default tablespaces. Select username, default_tablespace from dba_users; 2. view the table of the current user: select

Oracle10g Data Pump EXPDP and IMPDP backup and recovery dataI. Preparations before Database BackupCreate a backup DIRECTORY and authorize it to the userSteps:1. log on to sqlplusAccount name: ptemp password: 000000 host string: EMPDBSqlPlus

Oracle procedure trigger small example oracleproceduretrigger SQL code -- create or replace procedure p_update_dept (l_remarker in number, -- 0 increment, 1 Delete, 2. Change l_deptno in number, l_dname in varchar2, l_loc in varchar2, l_result out

Oracle 11G Single Instance uses asm, and test the migration of data files to other disk groups 1. configure/etc/hosts network vi/etc/hosts192.168.1.181 asm asm.oracle.com 1. disable FIREWALL 2. disable SElinux vi/etc/selinux/config => SELINUX =

Top 10 physical segments of Oracle databases select owner, name, type, mega, tbs from (select owner, case when segment_type = 'LOBSEGMENT' then logical_name else

Inner join, left join, where and in right join. 1. inner join (natural join): Only the rows matching the two tables can appear in the result set. 2. Outer join: including (1) left Outer Join (the table on the left is not restricted) select.

Solving CRS-4639: cocould not contact Oracle High Availability Services When starting the asm instance, the following error is reported: [grid @ b1 ~] $ Sqlplus/as sysasmSQL * Plus: Release 11.2.0.1.0 Production on Thu Sep 12 18:14:13 2013 Copyright