Oracle

First, IntroductionA logical backup is the process of exporting the structure and data of a data object to a file using the tools export.Logical recovery refers to the process of importing a data object into a database using a backup file when the

Ora-01012:not logged on exceptionCause of the problem: the application may have a bug that did not release the connection in time.Workaround: The root of the problem is to modify the processes value, or prohibit some unusual access.Problem-Solving

package com.ist.common.util;import java.sql.*;import javax.naming.context;import  Javax.naming.initialcontext;import javax.naming.namingexception;public class jdbcoracletest {//ORCL is the database name in the Oracle database, and localhost

cenOS5.5 installation oracle10g (Fool article) http://www.cnblogs.com/fnng/archive/2012/06/19/2554159.html (Turn)Installing Oracle 10G on cenOS5.5 It's not that fresh stuff, but it took a week to build it around. I think everyone will encounter some

CREATE OR REPLACE FUNCTION f_irt_date_yyyymmdd (ENTER VARCHAR2)/***** The Effective date format is YYYYMMDD, the input date format is: 16-jul-15 (date-month-year)* Example: 20151231******/RETURN VARCHAR2 isNiendate DATE;NUM VARCHAR2 (3);Input_char

The current summary of the statement, in view of the data connection is very useful, after writing the program while testing the code side to see the release of database connections to help optimize the analysis of a robust system program.1. SQL

1: Three paradigmsA: A table must have a primary key, the column is not divided.B: If a table contains two fields as the primary key, then the other fields cannot be partially dependent on the two fields.2:PL Sql:procedural Language (Process

SelectSysdate--2016-04-14 16:57:09 Current Time, Sysdate+1--2016-04-15 16:57:09 Current time of the second day, TRUNC (sysdate)--2016-04-14 Current Date, TRUNC (sysdate)+1--The second day of 2016-04-15, Trunc (sysdate)+ at/ ---2016-04-14 23:00:00

Syntax for adding a field: ALTER TABLE tablename Add (column datatype [default value][null/not null],....);Modify the syntax of the field: ALTER TABLE tablename modify (column datatype [default value][null/not null],....);Syntax for deleting a field:

Summary of Oracle's tablespaces, partitioned tables, and indexesKeywords: Oracle, table space, partition table, indexThe first time last week to do database testing encountered a lot of questions to summarize:Table Space:Oracle's UNDOTBS01.DBF file

Oracle Study-aix6.1 Building Oracle 10GR2 RAC (2)First, view system I/O (asynchronous I/O is enabled for Oracle database)For AIX6.1, the default asynchronous I/O is automatically activated when there is a requirement, and no configuration is

Problem Description: Oracle database, Java code uses a DB instance, gets connection and closes at end of use, and the session is not destroyed, but the state becomes inactive causing the temporary table data not to be emptied.The Oracle staging

Oracle Study-aix6.1 Building Oracle 10GR2 RAC (1)Environment:Operating System: AIX 6100-09 (SP3)Cluster Software: CRS 10.2.0.1Database: Oracle 10.2.0.1There are two ways in which RAC can be used to build an AIX platform based on shared storage:1.

Oracle to MySQL modification:1. substr ()substr (String, 0, 10) Here the test must be obtained from the first bit both substr (string, 1, 10)2. To_char ()Can only be used as a function of Oracle, compatible with Oracle and MySQL and changed to

Transferred from: http://blog.itpub.net/133041/viewspace-438549/1. Discrete manufacturing.2. Repetitive manufacturing3. Flow-type ManufacturingOracle applications supports manufacturing methods such as discrete, project, repeat, order-by-assembly,

System environment: Win7 32-bit systemInstallation steps:1,oracle (Oracle) Download the appropriate database installation package,http://www.oracle.com/technetwork/cn/indexes/downloads/index.html#database2, download There are two packages Win32_11gr2

Source to: http://jvortex.blog.163.com/blog/static/16961890020122141010878/We know that indexes are database objects that are used to speed up database queries. The principle is to reduce the IO operation of the query, so as to achieve the purpose

OracleSQL classic query trainer Article 3 Oracle SQL classic query trainer Article 3 This article is the third article about Oracle SQL classic query. It is just the author's opinion. If you have any questions, I hope you can provide suggestions or

Oracle Study Notes (7) -- Advanced query (1) Before learning advanced queries, let's take a look at how to view all the tables in the Oracle database. This is because we need to use several tables under the SCOTT user in the Oracle database (these

Oracle Database 11g For Windows 7 flagship version installation, 11gwindows7 System Environment: win7 32-bit System   Installation steps: 1, Oracle (Oracle) official website download suitable for their own database installation package,