Database Administrator

PL/SQL Exception error handling A good program should be able to correctly handle all kinds of errors and recover from errors as much as possible. Oracle provides EXCEPTION and exception handler for error handling. -----------------------------------

Introduction to PL/SQL Program Design ① PL/SQL program design overview PL/SQL is an advanced database programming language used to access Oracle databases in various environments. Since the language is integrated into the database server, PL/SQL

Oracle | PL/SQL Unique index (Unique Constraint) Usage 1 goalThe following example shows how to create, delete, disable, and use uniqueness constraints. 2. What is a uniqueness constraint?A uniqueness constraint refers to the constraint that a field

Oracle 11g new feature system partition table A new feature in Oracle 11g is the Partition Table of the system. Here is an experiment: SQL> select * from v $ version;BANNER------------------------------------------------------------------------------

Install the full version of MySQL source code in Linux Install MySQL in Linux, usually by using RPM and source code. For the production environment, you need to customize the installation path, data file location, Character Set, and supported

Archive logs (below), archive logs ( 1 SQL> archive log list; # Check whether the archive mode is used2 SQL> alter system set log_archive_start = true scope = spfile; # enable active ArchivingSQL> alter system set log_archive_dest = 'location

[Oracle] Wide ledba28 open a connection to the RMAN recovery catalog, which contains the RMAN metada, metada You executed the following command in Recovery Manager (RMAN ): RMAN> restore controlfile; Which operation must you perform before this

How to Use RMAN Incremental backup to restore data guard log gap (log disconnection), rmangapThe minimum scn information of the master database:SQL> col current_scn for 999999999999999SQL> SELECT CURRENT_SCN FROM V $ DATABASE; Select min (fhscn)

Character set 'utf8mb4' is not a compiled character set, utf8mb4compiled A Character set error occurred during a recent MySQL Data migration. The prompt is "character set 'utf8mb4' is not a compiled Character set ". That is, the character set utf8mb4

MySQL Master/Slave latency monitoring script (pt-heartbeat), mysqlpt-heartbeat We can use percona's powerful weapon pt-heartbeat to monitor the master-slave replication latency of MySQL databases. Pt-heartbeat updates a specific table in the master

Database ----- Common Database Connection Methods, ----- database connection Oracle Driver oracle. jdbc. driver. OracleDriver URL jdbc: oracle: thin: @ loaclhost: 1521: orcl // orcl indicates the database SID. MySQL Driver com. mysql. jdbc.

[Mysql] mysql windows configuration file, mysql configuration file The environment is win7 mysql5.6 Test whether the configuration file is available (no msyql configuration in windows has been used before)Query the configuration before modification:

How to Use navicat for mysql to connect to a local database and import data files How to Use navicat for mysql to connect to a local database and import data files1. Introduction Navicat for mysql is a database management tool designed to simplify,

BI Financial DBDIFF Analysis Issue, Core formula: DB --> ETL --> DW vs REF file   Cause of error: 1. DB/DW Connection Issue 2. SQL Issue 3. Product Bug 4, REF file not updated   Physical requirement analysis: 1. Source DB: EBS, PSFT, Fusion... DB

Check items before deleting oracle archive logs, oracle Archive This article is an original article, Reprinted please indicate the source Http://blog.csdn.net/msdnchina/article/details/41413313 To delete archived logs, you must confirm the

One ORA-600 [13011], one ora-60013011SunOS 5.10 Oracle 10.2.0.2.0 development environment a database has a ora-600 error.Alert. error message in log: Thu Nov 13 15:11:43 2014 Errors in file/oracle/admin/sun/bdump/sun_j000_29589.trc: ORA-00600:

ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [1498], [18713], [18720], internalerrorDatabase Server appears ORA-00600 [kcratr_nab_less_than_odr], cannot open database 1. open DATABASE reports ORA-00600 [kcratr_nab_less_

Mysql stored procedures and common functions, mysql stored procedures I. Functions 1. mathematical functions CEIL () into one integer Select ceil (1, 1.2); 2 FLOOR () Rounding Select floor (1, 1.9); 9 MOD remainder (Modulo) Select mod (3,8); 3-3

How to get an execution plan and an execution plan How to get an execution plan from oracle 1. Get a common execution plan. The effect is similar to executing set autot on exp first and then executing SQL. Explain an plan for your_ SQL; select *

Development: Issues related to table creation in DB2 due to abnormal collection Because the table creation statements may be different when using the DB2 database for the first time, the Manual table creation method is used to fill in fields one by