Database Administrator

Example of Incomplete recovery based on time points When it comes to Incomplete recovery, there are generally three scenarios: Incomplete recovery based on time points, Incomplete recovery based on scn, and incomplete recovery based on cancel.In all

Oracle uses comment statements to add Table Comments The Oracle comment statement can be used to add remarks to tables, fields, views, and other objects. Syntax:Comment on TABLE table_name IS 'Remarks '; Permission requirements:By default, users can

Oracle user password Problems Oracle users seldom pay attention to their passwords. Generally, the password expiration time is set to never expire after the database is installed, but an error occurs when autotrace is enabled, it attracted my

Sort out some MySQL interview questions 1. How to log on to the mysql databaseMysql-u username-p 2. How to enable/disable the mysql ServiceService mysql start/stop 3. view the mysql statusService mysql status 4. How to display the number of all

Simple Test of forall in PL/SQL I wrote a bulk collect article, but I made a simple example of bulk collect.In fact, it is not only bulk collect, but forall also greatly improves pl/SQL Performance.You can see the two figures below. In pl/SQL, the

Subtotal on MySQL Master/Slave latency I have encountered several MySQL master-slave latency issues recently, and some of my colleagues complained about this. Sort it out a little bit. ------------------------------------ Body ---------------------

Oracle 12C TRUNCATE TABLE CASCADE The truncate table cascade statement is provided in Oracle 12c to delete the association when the TABLE has a primary foreign key relationship and is cleared. The following is a demonstration. 1. Prepare the test

How to install MySQL Server in CentOS 7 Previously, RHEL 6.3 and 6.4 were used. The system disk contains the mysql server. After configuring the yum source, you can directly install mysql-server on the yum install mysql server. Recently, CentOS 7.1

Analyze and solve the problem that MRP cannot be started in DataGuard I have a dedicated uard environment on hand, because it has been useless for some days. As a result, I was suddenly prepared to start learning, and suddenly found that after I

Error code: 1109 Unknown table 'ename' in multi delete, 1109 ename 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: delete. ename from emp error code: 1109 Unknown table 'ename 'in multi delete execution time: 0

NoSql-MongoDB GridFS + ASP. net mvc implements upload and display, The previous article introduced how to perform some simple operations on MongoDB in the dos window. However, no matter what you learn, you still need to apply it to your project,

SQL Database Upgrade process-solve the WMI Service cannot be linked process, sqlwmi The trial period of the previously used SQL SERVER database is reached, and the database cannot be opened, prompting that the database has no permissions. I believe

[Data center cooperation]-SqlHelper we have another appointment. Data Center cooperation sqlhelper1. What is it? SqlHelper is a database operation component based on · NET Framework, which contains database operation methods.2. Why? Why use the

Oracle9i statspack report analysis direct path read wait event, oracle9istatspackDB Name DB Id Instance Inst Num Release Cluster Host-------------------------------------------------------------------------LIXORA 1409317108 LIXORA 1 9.2.0.1.0 NO

[Translated from mos] compatibility between the rman Standard Edition and the Enterprise Edition, mosrman Compatibility between rman Standard Edition and Enterprise Edition Source:RMAN Standard and Enterprise Edition Compatibility (Document ID 730193

Basic mysql Data Type, mysql Data Type Big Data Type Create table data (fti TINYINT, fsi SMALLINT, Fmi MEDIUMINT, fi INT, fbi BIGINT ); Int type Create table data1 (age INT (7 )); Float Type Create table data2 (price FLOAT (5, 2 )); Insert

Mysql syntax errorError message: MySQL server version for the right syntax to use nearPossible cause 1: The Database Name, table name, and field name cannot contain the mysql keyword.For example, 1) desc or asc2) group2. Database Name, table name,

Common SQL code and SQL codeSome of the most important SQL commandsSELECT-extract data from the database1. select syntaxSelect column_name, column_name drom table_nameOrSelect * from table_name (select all columns)2. select distinct is used to

MySQL Study -- MySQL tool mysqlshow, -- mysqlmysqlshow MySQL Study-MySQL tool mysqlshowMmysqlshow customers can quickly find the databases, tables in the database, columns or cables in the table.Mysqlshow provides a command line interface

Error Caused by tablespace _ temporary tablespace: ora-01652 small example, ora-01652 Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/46888243 Error Reporting temporary tablespace