Oracle

Original: IS2009 making Oracle Silent installation package (a) Thank you, Mr. Blank. LicensingPrevious: MyEclipse in the elimination frame caused by "The file XXX can not found." Check the location and try again. " The errorThis article by the

1 Sqlplus Login Log on locally (log on to the database server) Oracle Login Sqlplus account name/password as role name 1.1 SYS Login Example: Sqlplus sys/oracle ERROR: Ora-28009:connection as SYS should be as SYSDBA or sysoper SYS administrator must

I. PL/SQL Developer Development ToolsPL/SQL Developer is an integrated development environment (IDE) for developing PL/SQL blocks, which is a standalone product, not a companion to Oracle.Second, PL/SQL IntroductionWhen developers use PL/SQL to

How do I import a DMP database file in Oracle?Oracle data import and export imp/exp is equivalent to Oracle data restore and backup.　The EXP command can export data from a remote database server to a local DMP file, and the IMP command can import

The following are organized from Oracle's official documentationA conceptA synonym is an alias for any table, view,materialized view, sequence, procedure, function, package, type, Java Classschem A object, User-defined object type, or another

/*--The following code is the display width setting for the EMP tableCol empno for 9999;Col ename for A10;Col job for A10;Col Mgr for 9999;Col hiredate for A12;Col Sal for 9999;Col Comm for 9999;Col deptno for 99;Set pagesize 20;--Create a new table

Free spacetable (FST)FST indicates the free space contained in the ATB. ASM generates a disk FST when the disk is selected for assignment. This allows ASM to skip the space occupied by the ATBs. FST contains entries for each ATB. Each entry

Oracle Client Installation + PL/SQL Tools installation Configuration Download the Oracle client and install it locally. 11g is:Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html10g

2 character Functions1. Replace (string 1, String 2, String 3)Replace (char, search_string, replace_string)Function: Search for "String 2" in "String 1" and replace it with "string 3".For example, the following command replaces the "A" that appears

The PSU update for the first quarter of 2014 was mainly 3 version numbers: 12.1, 11.2.0.4, 11.2.0.3, and 11.1.0.7.In the 2nd quarter Oracle will announce 12.1.0.2, same time 11.2.0.4 The version number will also be the ultimate version of 11.2, no

There are several scanning methods under Oracle 10g, note that the last scanning method, when the partition column is calculated, will not walk the partition, which is calculated with the index column will result in the same as the index.--Scan

EL5_U8 i386:http://ftp.heanet.ie/disk1/oracle-linux/EL5/U8/i386/OracleLinux-R5-U8-Server-i386-dvd.isox86_64:http://ftp.heanet.ie/disk1/oracle-linux/EL5/U8/x86_64/OracleLinux-R5-U8-Server-x86_64-dvd.iso EL5_U9 i386:http://ftp.heanet.ie/disk1/orac

8.3 Managing Primary Database Events That Affect the Standby Database8.3 Managing the master Database can Affect the Events of the slave Database To prevent possible problems, you must be aware of events on the primary database that affect a standby

ORA-4031 error. ORA-04031 error is because the continuous memory cannot be allocated, it may be that the shared pool memory fragments are serious, or it may be that the memory is indeed insufficient.The cause of this situation is: frequent and more

This document describes how to use SQL Plan Management to manage SQL Execution plans. SQL Plan management provides components for capturing, selecting, and evolving SQL Plan information to prevent performance degradation caused by sudden changes in

In the Oracle Copy Command, the Copy command of SQL * Plus is a common task for Oracle DBAs to copy data between data tables. Oracle provides N solutions, the SQL * Plus Copy command is one of them. The SQL * Plus Copy command uses SQL * Net to Copy

How to use Oracle to conveniently view alarm log errors and oracle logs I checked the information on the Internet for a few days and tried to clear the alarm log Content and create an external table to solve this problem. I. Back up and clear alarm

How to modify the Oracle 11G password after the expiration of 180 days, oracle11g Due to the new features of Oracle11G, often encounter the use of sqlplus login oracle Database prompts "ORA-28002: 7 days after the password will expire" and so on.

Graphic tutorial on connecting eclipse to oracle 11g Database Eclipse is an open-source and Java-based scalable development platform. Eclipse comes with a standard plug-in set, including Java Development Kit (JDK ). 1. First, create a project DB,

Disclaimer: Some of the images used in this article come from the Internet. If there is any infringement, contact the blogger to delete them. 1. What is Oracle Glodengate? GoldenGate is an oracle data synchronization software based on database logs.