Database Administrator

Troubleshooting ORA-12516 At work in the morning, my colleague told me that the database can not connect, the prompt "ORA-12516" error, I tried to connect to the database remotely through PL/SQL Developer, and indeed, the error "ORA-12516: TNS: the

Expdp ORA-31693 & ORA-00922 Expdp ORA-31693 & ORA-00922The following error is reported when executing expdp:ORA-31693: Table data object "HQ_X1". "B3901_P" failed to load/unload and is being skipped due to error:ORA-00922: missing or invalid

MySQL details (19) ---------- paging Query Optimization for massive data, mysql ---------- The detailed explanation of the paging, please see the http://blog.csdn.net/u011225629/article/details/46775947 View the code print 1 SELECT * FROM table

Install and use MySQLdb and MySQLdb I. Installation Install the compiled version (this method is simple and convenient ): Http://www.codegood.com/downloads Download the package from your system and double-click it to install it. Import MySQLdb to

Oracle primary and foreign key management, oracle Key Management Use the primary and foreign key constraints to ensure data integrity. 1. query all the constraints on the table Select * from user_constraints tWhere t. table_name = 'father '; 2.

Use Jasper report to calculate opening balance and jasperopening Source: http://community.jaspersoft.com/questions/850400/how-create-report-opening-balance-using-jasper-reports. When calculating the balance at the initial stage based on the access

Impdp gets stuck, DW waits for library cache lock, impdplibraryMy colleagues reported that impdp was stuck in the SCHEMA_REPORT/TYPE/TYPE_SPEC step and did not respond after more than one hour,Check the v $ session:Select program, sid, event,

Detailed description of the query planner in SQLite, detailed description of the SQLite Planner 1.0 Introduction The task of the query planner is to find the best algorithm or "query plan" to complete an SQL statement. As early as SQLite 3.8.0, the

[Oracle error highlights]: ORA-00119 & ORA-00132, oracleora-00119 Sometimes, God is joking with you. Yesterday we had a hard time configuring Oracle, so we could use PL/SQL to log on and use it normally. Today we suddenly cannot. And the error is

Centos7 solves django. db. utils. OperationalError: FATAL: Peer authentication failed for user "s", userauthentication After the postgre database is installed in yum under centos7, the database connection configuration is located

Getting started with oracle database data query: oracle Data Query 1. perform operations on data using arithmetic expressions during the Query ProcessThe student table structure is as follows: The last salary represents the monthly salary of each

Oracle merge query and oracle merge 1). UnionThis operator is used to obtain the union of two result sets. When this operator is used, repeated rows in the result set are automatically removed. 2). union allThis operator is similar to union,

Research on MySQL auto-growth primary key and MySQL growth primary key The keyword used for automatic MySQL growth isAUTO_INCREMENTBecause it is DDL, It is case insensitive. Columns used must be defined as keys, such as primary keys and unique keys.

Oracle sets the User Password usage time, oracle sets the User Password How do I set a password to force a regular password change?Assume that the password must be modified after 10 days, and the grace period is 2 days: Call the computer time

MySQL 5.6 installation-free version (green or decompressed version) to modify the encoding, mysql5.6 See here: http://www.bkjia.com/sjkqy/989251.html It took more than half an hour to try various methods on the Internet. It is estimated that the

Oracle study -- "ORA-00845: MEMORY_TARGET not supported on this system" error, oraclememorytarget Oracle study -- "ORA-00845: MEMORY_TARGET not supported on this system" error System Environment: Operating System: RedHat EL6 (64) Oracle: Oracle 11g

SQLyog v11.24: How to query Chinese garbled characters in MySQL5.6.24 sqlyogmysql5.6.24 After searching for this problem online for half a day, I did not find a solution. Finally, I used a small skill to solve it myself. Reprinted please indicate

Foreign key constraint columns are not indexed, resulting in a large number of library cache pin/library cache locks and librarypinThe foreign key constraint column is not indexed, resulting in a large number of library cache pin/library cache locks.

Php accesses the mysql database and phpmysql Database PHP can access the Mysql database through the mysql interface and mysqli interface. You must add the mysql and mysqli interfaces to access the mysql database. In windows, configure amp: a and

Datazen custom map, datazen customZookeeper Datazen's map data definition is mainly based on ESRI's Shape file format, which is now widely used as a map data format. In Datazen, the following two map data definition files must be provided for a