Database Administrator

Oracle Tutorial: ORA-25153 temporary tablespace is empty, ORA-01652 cannot pass 128 I wrote a complex select statement, and suddenly Oracle reported: ORA-25153 temporary tablespace is empty, this error, so I checked online, found the following

Accidental deletion of redo log file group causes startup Database Error ORA-03113 Speaking of more than one person, learning technology requires Constant tossing and destruction. For example, backup and recovery, you can try to delete files,

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-Proxy implements MySQL read/write splitting to improve concurrent Load Working topology:110018378. jpgA powerful function of MySQL Proxy is to implement "read/write splitting". The basic principle is to let the primary database handle write

View the version of the remote Redis Server How can I view the version of a remote Redis server? What should I do if I have no SSH access permission for the remote Redis server and want to know which version of the Redis server is used? It's easy to

Oracle condition selection statement and loop statement Oracle Condition Selection statements (IF, CASE), LOOP statements (LOOP, WHILE, and FOR), and sequential control statements (GOTO, NULL ).1. IF condition selection statement1.1 simple condition

Install MySQL 5.6.26 through source code in CentOS6 MySQL 5.1 installed through yum in CentOS6 is old, so I want to install the later version 5.6.26 through the source code. I. Uninstall the old version Run the following command to check whether

ASM Single Instance CRS-4124, CRS-4000 error handling Install GI. Due to limited notebook resources, you have installed Oracle11g GI so that you can learn ASM. After the installation is complete, everything works normally.However, the following

Cassandra Getting Started Guide-installation and configuration, cassandra Getting Started Guide -- Today, we will start to learn about Cassandra, A NoSQL database, and record the process for your reference. Introduction Apache Cassandra is an

Mysql checks duplicate indexes and mysql checks indexes. Mysql can re-create an index on the same field, but oracle cannot. Installation requiredPt-query-digest. [Root @ VM-10 ~] #Pt-duplicate-key-checker-h10.10.11.208-uroot-proot-P3316 -- charset =

Redis Command Execution Process, redis command process This problem is simple and simple. The client sends a command request, the server reads the command request, and then the command executor searches for the command implementation, executes the

I think this is the difference between marketing ideas. The so-called ideas determine the way out and the Way OutArticle marketing rather than soft text MarketingFirst of all, I want to talk about it.C. I prefer to call it article marketing for soft-

Optimization of multi-level distribution interconnection with third-party APIs to obtain data systems, and third-party APIs Recently, I was working on a multi-level distribution management system based on likes. All members of the store had likes

Connect to Mariadb and mariadb remotely // This article describes how to connect to the Mariadb database on centos7. // There is no difference with mysql Package test. java. mysql; import java. SQL. connection; import java. SQL. driverManager;

Common listener-related errors in ALERT logs: troubleshooting of ORA-609 errors, alertora-609Reference MOS documents include:Troubleshooting Guide ORA-609: Opiodr aborting process unknown ospid (Documentation ID 1121357.1)Alert. log shows ORA-609

Error code: 1582 Incorrect parameter count in the call to native function 'str _ to_date ', parameter1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: SELECT t. 'name', DATE_FORMAT (str_to_date ('20140901'), '% y') as

MySQL Time Zone parameter, mysql Time Zone Environment Introduction: OS Version: RHEL5.5 MySQL version: 5.5.40 Reference: http://dev.mysql.com/doc/refman/5.5/en/time-zone-leap-seconds.html There is a requirement: an attendance system, where multiple

CDC changes data capture technology issues and limitations, cdc capturesThe current cdc function will still disappoint you.The advantage is not mentioned, that is, those written in online books.Disadvantages:1. So far, cdc cannot be associated with

File attachment or query results size exceeds allowable value of 1000000 bytes, exceedsallowable DECLARE @ tab char (1) = CHAR (9) EXEC msdb. dbo. sp_send_dbmail @ profile_name = 'backgroundy', @ recipients = 'xxx @ wuxiapptec.com ', @ query =

Advantages and disadvantages of paradigm and anti-paradigm When designing databases, there are paradigm and anti-paradigm considerations. The following is a summary. Advantages of paradigm: 1) more rapid updates of the paradigm-based database;