Database Administrator

How to Diagnose Oracle Data Pump-How to add diagnostic information to a Data Pump There are still many bugs in the 11g Data Pump (expdp/impdp), and we often encounter inexplicable card death, which makes people feel overwhelmed. I recently read an

Summary of MySQL remote connection For a long time, I have never had the habit of summing up the problems encountered in the project. I feel that from today on, regardless of the problems encountered, note that it is necessary to summarize the

Mysql selects the previous and next data records, sorts the data to move up, move down, and top, and mysql next1. The list sorting function needs to be completed! Shows the effect:2 setting ideas Set a rank as the timestamp. By selecting "Move Up",

"TNS-03505: unable to resolve the name" Problem Solution case, tns-03505 case  1. Problem A developer adds an ORACLE client in a windows environment and configures "tnsnames. ora, prepare to connect to the ORACLE database Linux environment, with

[Oracle] export ledba14 archived log files, oraclealert. log The loss of which two types of files may require a recovery The RESETLOGS option? (Choose two .) A. control files B. password file C. archived log files D. system-critical data files

Use a batch file to complete registration information. When writing software, the dynamic link library in the Window system must be registered for use. For example, to run the ADO program in Windows XP, you must register regtlibv12

Impdp terminate ORA-7445 [kpodpals], impdpkpodpals due to fatal errorsIt was difficult to successfully export all the data to the user the day before yesterday. Today, the user told me that the exported data could not be imported. First, ask the

Command Line in HDFS and HDFS command line Command Line in HDFS This article describes the functions and usage of several common command lines when running HDFS with command lines ~ 1. fs Fs is the command line action to start. It is used to

Data storage solution evaluation standard RDBMS or KV, Evaluation Standard rdbms Author: zhanhailiang Date: This article mainly introduces common data storage solutions and evaluation criteria for corresponding selection. Guideline: select a storage

Explain tables does not exist. Check the explain plan properties for this database connection., tablesproperties Use DbVisulalizer to connect to db2. An error is reported when you view the execution plan. Explain tables does not exist. Check the

Mysql_connect v/s mysql_pconnect, mysqlpconnect Original article: mysql_connect v/s mysql_pconnect Translation: mysql_connect v/s mysql_pconnect Translator: dwqs When you need to use PHP to connect to the MySQL database, you will find two database

Mybatis calls the mysql stored procedure, mybatismysqlCreate a stored procedure: DELIMITER $$USE `test`$$DROP PROCEDURE IF EXISTS `user_user_selectUserByProAndCity_sp`$$CREATE DEFINER=`demao`@`%` PROCEDURE `user_user_selectUserByProAndCity_sp`(IN

Use of the SQL midstream mark and the SQL markDeclare @ id intDeclare @ addTime datetimeDeclare cursor1 cursor for -- defines the cursor cursor1Select id, addtime from MR_Examine -- use the cursor object (enter select text as needed)Open cursor1 --

Introduction to py_innodb_page_info, innodbpagesizePy_innodb_page_infoThis tool is written by Jiang chengyao, author of MySQL technology insider InnoDB Storage engine, to analyze the types and information of each page in a tablespace and is written

ORA-03249: automatic segment space management of the tablespace size should have at least 5 blocks, ora-03249 space size Create a tablespace for a test and report an error. SQL> select * from v $ version;BANNER ---------------------------------------

Alex's Hadoop rookie Tutorial: 8th Sqoop1 installation/import/export tutorial, hadoopsqoop1 Depend! Sqoop2 has too few documents and does not support Hbase, which is very simple. So I gave up Sqoop2 and switched it to Sqoop1. I followed my tutorial

Oracle 11g installation causes the database to fail to automatically collect statistics, oracle11g Recently, it was found that some 11 GB databases could not automatically collect statistics. Some View query results are as follows: SQL> select

MySQL InnoDB Storage engine table (2), mysqlinnodb This article continues the unfinished part of the previous article. 4. InnoDB Data Page StructurePage is the minimum disk unit for the InnoDB Storage engine to manage databases. A page of B-tree

How to install mysql using yum in linuxMy blog previous (http://blog.csdn.net/tjcyjd/article/details/41646889) has talked about the yum source configuration, with yum then install mysql will be very simple, specific as follows:1. Install the client

Cannot connect to remote postgresql, connect to postgresql If postgresql is installed on a remote server, adding a server using pgAdmin will never work. Solution: Add host all 0.0.0.0/0 trust to pg_assist.conf on the remote postgresql database.