Oracle

Oracle database installed on the Ali Cloud, one day received the following alerts:Name=atabasenameType=database InstanceHost=izw2519p6r9uzeeeMetric=statusTimestamp=nov, 2014 4:16:37 AM CSTSeverity=criticalmessage=failed to connect to database

The main is Query All_tables table table_name and owner, if the table exists, execute execute immediate ' drop tableTABLE_NAME '; --Determine if the table exists, delete if present DeclareNum number;BeginSelect COUNT (1) into NUM from all_tables

1. Plsql Connection database prompt listener does not recognize the service currently listening to the descriptor request Modify Listener.ora to:Sid_list_listener =(Sid_list =(Sid_desc =(Sid_name = Plsextproc)(Oracle_home = f:oracleproduct10.2.0db_1

Cascading updates using the nominal: The code is as follows Copy Code CREATE TABLE A001 (ID INT PRIMARY key,name VARCHAR (20))CREATE TABLE A002 (id INT REFERENCES A001 (ID) on DELETE CASCADE on UPDATE cascade,age TINYINT)

Today, when you create a view of a table, users are prompted to ORA-01031 user rights, insufficient privileges. You still cannot create a view by using the system user to assign permissions such as DBA. Create a View The code is as

Question Prompt Error tip: Error:ora-12514:tns:listener could not resolve service_name given in Connect Workaround: The code is as follows Copy Code 1. Open the /network/admin/listener.ora file and

See "Environment variables" in path, adding D:oracleora92bin to global variables (if your Oracle is installed in D disk). Four modes of 2.1.1 Exp: 1, the table mode, used to export a table. 2, user mode, used to export a user's schema. 3, table

First, single instance to open the order of the archive log 1. The original parameter file needs to be backed up first Create pfile= ' F:\pfile1018.ora ' from SPFile; 2. Adjust the format of the archive log Alter system set log_archive_format= '%

Today when you do the project to achieve paging functionality, previously only on MySQL, Oracle has not tried, but know that there is such a rownum this thing. But this thing is not so easy to use, there are quite a lot of places to pay

Distinct this keyword to filter out the extra duplicate records only one, but often use it only to return the number of records not duplicates, rather than using it to return all the values not to be recorded. The reason is that distinct only use

Let's take the Oracle removal clean and prepare for the reload.1. Delete Service commandThe concrete method of operation is: Start--run--cmd, enter cmd command lineThen enter: SC Delete Service nameFor example: SC delete serv-u serverQuery Service

--Create a test table   code is as follows copy code Create Table T_a (ID number); --Insert data directly using loops Begin   for I in 1..100000 loop      INSERT INTO t_a (ID) values (i);   End Loop; End; --

One: The simple test job creation process case:1, first create a job_test table, the field is a date format The code is as follows Copy Code Sql> CREATE TABLE Job_test (a date);Table createdSql> commit;Commit Complete

/** Test.java 2008-7-30**/Import java.sql.Connection;Import Java.sql.DriverManager;Import Java.sql.ResultSet; Import Oracle.jdbc.OracleDriver; public class Test {public static void Main (string[] args) throws Exception

1. Add a reference to the Web application project first: Interop.oracleinprocserver 2, the Web.config configuration: " ...... 3, Global.asax Create the Oraclesession object, the code is as follows: Using System; Using

Today, Oracle databases are favored by more and more enterprises because of their high reliability, security and compatibility. The reader may wish to consider some of the following aspects of how to keep the Oracle database permanently in good

Download the software package to the official website, first register an account number, download is a compressed package, extract the oracle-xe-11.2.0-1.0.x86_64.rpm. There are only 64-bit versions under Linux. 1, install the dependent package

Oracle deadlock analysisThere are three methods to handle deadlocks.1. Advance prediction2. Resource classification3. Release after detectionI know that ORACLE MYSQL uses the third row lock level.Here we will analyze an ORACLE deadlock. First, a

Assm level-3 bitmap is the basic skill knowledge of dba. Here we use the test method to verify the principle of level-3 bitmap.1. Create tables required for the lab environmentSQL> create tablespace a1 datafile

First, when the customer adds disk to one of the rac nodes, it finds that the node is not successfully added to the other node, and then repeatedly adds or even adds the dd disk header.One of the most fatal actions is to force add disk. In fact,