Oracle

To see if the database is an archive mode: Sql> Show parameter Db_flashback;NAME TYPE VALUE------------------------------------ ----------- ------------------------------Db_flashback_retention_target integer 1440sql> archive log list;Database

First, File downloadThe installation is Oracle 11G, the installation file name is Oraclexe112_win32.zip,Official documents: http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.htmlIi. Installation of filesIn the win 7

The Dbms_output package is primarily used to debug PL/SQL programs, or to display information (displaying message) and reports in the Sql*plus command, such as we can write a simple anonymous PL/SQL program block that is used for some purpose dbms_

# coding=utf-8__author__ =  ' jspdba ' u ' read Oracle notes ' import cx_oracle     #  Import Module Sql=r "" "select * from user_col_comments t where 1=1and  t.comments is not nulland t.table_name =  ' @TABLE ' "" "words=[" Custom "," Code ","

The process of operation and maintenance is a process that constantly produces new problems and needs to be researched and moved forward. 11 holidays just before the customer calls to inform the Oracle synchronization data inconsistencies need to be

Transferred from:http://jingyan.baidu.com/article/f54ae2fccda68d1e93b84942.htmlExample:--Class tableCREATE TABLE number VARCHAR2 (not NULL);--Add a primary key to the Tclass tableALTER TABLE ADD CONSTRAINT PRIMARYKEY(cl_id);---student tableCREATE

1 Index creation Syntax:CREATE UNIUQE | BITMAP INDEX .On .( | ASC | DESC, | ASC | DESC,...)Tablespace STORAGE LOGGING | NologgingCOMPUTE STATISTICSnocompress | CompressNosort | REVERSEPARTITION | GLOBAL partitionRelated instructions1) UNIQUE |

Environment: Redhat 5.9 64-bit, Oracle 10g1.To modify the Dbstart script:$ VI $ORACLE _home/bin/dbstart#ORACLE_HOME_LISTNER =/ade/vikrkuma_new/oracleoracle_home_listner= $ORACLE _home2.Modify the/etc/oratab to the following format:$ vi/etc/oratabSID:

Summarize:1. Three configuration files are placed in the $oracle_home\network\admin directory.2. Sqlnet.ora determine the parsing method3. Listener.ora on Sid_name, commonly used for JDBC access, corresponding error code is 125054. Tnsnames.ora on

Oracle of the DatabaseI. Management of the user1. The user is like a person in the company, and the authority is what the person can do in the company, his role is to explain his position.2. The user's privileges are divided into:System permissions:

1. There are three flash back technologies, namely, flashback database, flashback query, flash back delete.The flashback database restores the database to a certain point in time; The flashback query is the history of the query table, and the

The problem has occurred in the previous period:The table has a column number type rec_recordlength (two time interval length/sec)Some data statistics This field will appear "Calculate the operation Overflow" error, it is a headache, can not find

Common oracle Stored Procedure skills1. Stored Procedure structure 1.1 The first Stored Procedure Create or replace procedure proc1 (p_para1 varchar2, p_para2 out varchar2, p_para3 in out varchar2) as v_name varchar2 (20); begin v_name: = 'zhang

Dapper is perfectly compatible with Oracle for executing stored procedures and returning resultsThis problem has plagued me for two days. When I used Dapper, I felt very cool. In particular, in combination with the new. net 4.0 dynamic, let me

JDBC (using Eclipse to operate on Oracle databases) basic operation set, jdbceclipse JDBC: JDBC (Java Data Base Connectivity, java database connection) is a Java API used to execute SQL statements. It can provide unified access to multiple

The Oracle NoLogging Append method reduces the redo_size and nologgingredo_size of batch insert operations. In business processing, the temporary table of the real table is often used to process intermediate results, and the Insert operation of the

Simple ORACLE Statement (add, delete, modify, and query) and code example// Create user c # name identified by password; // naming rule: 1 Name must start with a letter, 2 length cannot exceed 30 characters (60 bytes ), 3 cannot use oracle reserved

Query, disable, enable, and delete Foreign keys in Oracle 1. query the Foreign keys of all tables:   select table_name, constraint_name from user_constraints where constraint_type = 'R'; 2. Disable all foreign key constraints and use the following

Auxiliary SQL statements for oracle Optimization -- Query the SQL statement that is being executed. SELECT the OSUSER computer logon identity, the PROGRAM where the PROGRAM initiates the request, the USERNAME used to log on to the system, SCHEMANAME,

EBS xml publisher Chinese garbled Problem and Solution, ebspublisher Due to local environment problems, the xml publisher report cannot be run and the XML page cannot be displayed. XML input cannot be viewed using the XSL style sheet. Correct the