Oracle

Oracle 11g import and export table method summary also said, the above method: Export: www.2cto.com Fang Yi: 1. first set oracle_sid. 2. find the bin directory. my options are D: \> cd D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ BIN 3.

The following describes how to quickly implement the oracle test and installation environment: 1. Use the root user to mount the disc to the corresponding path, for example,/mnt (note that the default path is not needed ).Configure local yum

In linux, Oracle cannot be started due to IP address modification. The main issue is to modify the/etc/hosts configuration file. Configuration before modification: www.2cto.com 127.0.0.1 localhost192.168.2.50 CCXFIT-DBSERVER # The following lines

Oracle Parallel uses oracle Parallel (Parallel) to use 1. query the SQL code SELECT/* + Parallel (t, 8) */* FROM emp t; SELECT/* + Parallel (8) */* FROM emp t; SELECT/* + Parallel */* FROM emp t; 2. SQL code for creating an index: create index

64-bit system with PLSQL Dervloper solution 1) install Oracle 11g 64-bit 2) install 32-bit Oracle client (instantclient-basic-win32-11.2.0.1.0) download instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not download the wrong version.

Change redo log size (online redo log size) the Oracle online log and Oracle archive log record the complete change information of the entire database. Is an important part of Oracle architecture. Therefore, online log planning is also very

In oracle, auto-incrementing columns are implemented through SEQUENCE and TRIGGER. 1. The column data type to be auto-incrementing in the table is NUMBER, which cannot be LONG 2. create sequence s_id NOMAXVALUE NOCYCLE3. create trigger 1 create or

[Oracle] the difference between a stored Procedure (Procedure) and a (custom) Function (Function) the Stored Procedure (custom) Function needs to be executed independently, and there is not necessarily a return value; functions can be called

ORA-00600: internal error code, arguments: [4194] solution found that the alarm log contains the ORA-00600: internal error code, arguments: [4194] error. This error indicates that the undo tablespace has the following solution: SQL> create undo

Interval parameter 1 in oracle job: Execute Interval => TRUNC (sysdate, 'mi') + 1/(24*60) or Interval => sysdate + 1/1440 2 per minute: daily scheduled execution example: Execute Interval => TRUNC (sysdate) + 1 + 1/(24) 3: weekly scheduled execution

Oracle modifies the path of the spfile file. Background: today, my colleague found that the oracle spfile file was used as a resource under + DG_DATA during the database dual-host switch, it was originally found in + DG_ORA that the spfile path was

The oracle process and function process and function process and function are both stored in the database in the form of compilation. The function can have multiple parameters and return values without any parameters. The process has zero or

Oracle number data type number (p, s) p: Total number of digits s: number of decimal places, for example, number (5, 2), indicates that the number of digits in an integer is 3 digits, and the number of decimal places is 2 digits and 1 digit. number (

In suse11, oracle11g and tomcat boot auto start operating system: suse11_x86-64 1: oracle 11g r2 auto start 1, modify/etc/sysconfig/oracle file: ORACLE_BASE =/oracle // The oracle directory you have installed is changed to START_ORACLE_DB = "no" no

Change the maximum number of connections in Oracle Database 10g Express Edition the default number of connections in Oracle XE seems to be 40. If the process exceeds this number, the request for connection again will be rejected. 1. log on to

The basic format of the sqlplus command is sqlplus [/] [@ ]/[as sysdba | as sysoper]/nolog, where: username: username password: password connect_identifier: Connection ID string. If you connect to the current instance, you do not need to specify

The mechanism of the transaction concurrency control lock is to prevent the interaction between transactions and control concurrent access to ensure data consistency and integrity. When a transaction or operation attempts to prevent another

Oracle Database SQL statement exercises-preparationPrefaceI have been learning Oracle SQL statements for some time. I have always determined that the true learning is:It can be used in practice. Otherwise, it can only be explained that it is simple

Example of stored procedures and stored functions and triggers 1. Example of stored procedures: SQL> create or replace procedure raiseSalary (empid in number) as pSal emp. sal % type; begin select sal into pSal from emp where empno = empid; update

Oracle online redefinition oracle 9i provides an online redefinition function, which can be used to redefine a table structure or storage online without affecting the use of the current application, it is a very useful feature of oracle high