Oracle

Oracle DatabaseModerate timingDmp FileBackup can improve the security and stability of the database and facilitate recovery in the event of a fault. This article describes how to regularly back up the dmp file of an oracle database in SCO Unix.

1. Trigger:Concept:It can be seen as a special process, which is automatically executed and does not allow parameters to be included.The trigger can be used to automatically perform some operations, such as row triggers and data triggers. It is

For PL/SQL connection, 64-bit Oracle has recently changed to 64-bit Win7, and oracle has also changed to 64-bit 11g. After the change, we found that the plsql cannot load the database at all. There are also various changes to version Shenma on the

One of Oracle learning notes: SQL internal link, external link, and self-LinkIt is not easy for the landlord to learn Oracle recently. After six months of failure, he has to start over again.SQL internal links, external links, and self-links. I have

Oracle-hr Table query command exercises (a complete list of select commands) switch to the oracle hr user to practice 1. query the names and salaries of employees whose salaries are greater than 12000. Select initcap (concat (last_name, first_name) "

Powerful SQL: SQL Cookbook Reading Notes 1-sorting the mixed data of letters and numbers recently, I am reading a really good book on SQL Cookbook. Many solutions are very subtle, I really realized that SQL is powerful. Note: I use ORACLE 11g and

When you use the nid command to modify the Database name and dbid, you will inevitably encounter the situation where you need to modify the dbname and dbid, for example, restoring the database to the same machine is one of them. However, dbname and

Oracle to mysql migration steps and various precautions recently a company project needs to migrate the database once, from oracle to mysql, there is little information on the Internet, I will summarize some of the problems I encountered in this

Control file backup and recovery (RMAN tool) database version SQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionPL/

Oracle Data Guard is an important configuration parameter. Oracle Data Guard provides one or more backup databases for the production database (a copy of the database ), to ensure that data is not lost when the master database is unavailable or when

Oracle ORA-03137: TTC protocol internal error: [12333] an error occurs when the analytics program connects to the database through JDBC and reports ORA-03137 [12333. The JDBC driver version of the current program: ojdbc16-11.2.0.1.0.jar database

The value of distinct is displayed only once. No matter how many times this value appears, it is only displayed once. Select distinct field name 1, field name 2 from Table order by field name 1 It is best to use it in combination with order.

This article will introduce the usage of the oracle/plsql case Condition Statement, which is similar to mysql mssql. If you need to learn more, let's take a look. Statement syntax The Code is as follows: Copy code CASE

No matter what database I use, duplicate data exists. Next I will introduce in detail various methods and Performance Analysis for deleting duplicate records in Oracle tables, for more information, see. Method: The Code is as follows:

Oracle partnered with Hewlett-Packard to launch the first hardware product, database equipment. Oracle CEO Larry Elllison said the product is suitable for high-end, high-performance data warehouse applications.At the Oracle Open World Conference,

Directory structure:1 _ crazy Java _ crazy software _ Xiao wenji instructor _ Oracle_Oracle Server InstallationThe video includes: Download, installation, uninstallation, and precautions for Oracle10g servers.2 _ crazy Java _ crazy software _ Xiao

View the system permissions of the current userCopy codeThe Code is as follows:Select * from user_sys_privs; System permission granted by the system administrator ----- sys userCopy codeThe Code is as follows:Create user lisi identified by 123456 //

1. Oracle downloadNote that Oracle is divided into two files. After downloading, extract the two files to the same directory. In the path name, it is best not to show Chinese characters or irregular characters such as spaces. Official Address: Bytes.

SQL code-- Obtain the current SCNCopy codeThe Code is as follows:Select dbms_flashback.get_system_change_number scn1,Timestamp_to_scn (sysdate) scn2 from dual; -- Converts SCN to a successful time.Copy codeThe Code is as follows:Select to_char

11.2.0.3 the database crashed due to damage to the asm disk header block and encountered an incorrect ORA-15196.More detailed error: ORA-15196: invalid ASM block header [kfc. c: 26076] [endian_kfbh] [256] [0! = 1]Further checks have found that the