Database Administrator

TOAST function in PostgreSQL The content of TOAST in PostgreSQL is stored in another object, which is different from the OID of the original table. Similar to the LOB type storage in Oracle (the out-of-line Storage is stored in lobsegment by default,

Oracle Database Import and export practices There is an Oracle server that needs to be exported and imported. I have been familiar with Oracle before, but I have never studied Oracle Export and Import. Now I am in a hurry, so I have to make up the

Expdp export report ORA-39181 Processing Method [Environment] database version: Oracle 11.2.0.3 [Error Log] An error is reported when you use the system user to perform database expdp operations. The details are as follows: Starting "SYSTEM".

Oracle 12c new feature crsctl provides preview confirmation when stopping Resources In the Oracle 12c database version, crsctl provides the preview confirmation function when stopping related resources, but this function is not available in earlier

MySQL multi-master and One-slave Synchronization Test preparation: host A and host B are the primary IP addresses 192.168.131.129 and 192.168.131.130, and host C is the slave server. Configure MySQL multi-instance on the slave server with the IP

Use undo in Oracle to restore Data [Note] when I accidentally saw a colleague's QQ message saying "really tired", I got a call from this colleague in less than 30 minutes, as shown below: When I was just doing data deletion, I found that the

Processing When the Oracle tablespace is too large First, view the data usage of all Oracle tablespaces. SELECT Upper (F. TABLESPACE_NAME) "tablespace name", D. TOT_GROOTTE_MB "tablespace size (M)", D. TOT_GROOTTE_MB-F. TOTAL_BYTES "used space (M)",

Install Oralce 11gR2 database in CentOS 6.6 Environment requirements: Rlwrap-0.42 CentOS release 6.6 (Final) VMware Workstation 11 Linux. x64_11gR2_database_1of2 and linux. x64_11gR2_database_1of2 Download CentOS 6.6 official version Rlwrap:

Linux Oracle deletes archive logs Oracle reported this error today: ORA-00257 Check that the archive logs of Oracle are full. Solution: Two 1. Increase the archive log size. 2. Delete useless archive logs. (select this solution) In Linux:

How to solve the error Repositories is not a valid short file name, visualsvnserver An error is prompted during the installation of the latest version of visual SVN Server: "'Repositories 'is not a valid short file name ."Click OK to terminate the

[Translated from mos] mosrfs Trace the RFS process in physical dg Source:How To Trace The Remote File Server (RFS) Process In Physical Standby Database (Document ID 1481125.1) Applicable:Oracle Database-Enterprise Edition-Version 10.1.0.2 to 11.2.0.2

Oracle table partition, oracle Partition The partition of the pivoel table can basically be divided into several categories:-Range Partition-Hash Partition-List partitions-Combined partitions: Range-Hash and Range-List.1. Create a partition table

Postgresql query by date range, postgresql date There are several methods to query by date range. The date field type is generally: Timestamp without timezone Method 1: Select * from user_info where create_date> = '2017-07-01 'and create_date

Steps and notes for SQL * Net trace on the Oracle client, oracletrace Steps and notes for SQL * Net trace on the Oracle clientReferences:How to Perform Client-Side Tracing of Programmatic Interfaces on Windows Platforms (Document ID 216912.1) My

MySQL foreign key insertion and MySQL key insertionAdd a foreign key to the added data table:Syntax: alter table name add constraint FK_ID foreign key (your foreign key field name) REFERENCES External table name (corresponding table's primary key

About connecting VBS to MySQL and Excel, vbsmysqlexcel Objective: To connect to MySQL and find data in the new Excel table Implementation process:1. Connect to the database First, go to the MySQL website to download an ODBC data source. After

Redis Topic 1: Data Structure and redis topic Data StructureSimple Dynamic string Redis does not directly use the traditional string representation in the C language, but builds a dynamic string SDS. When redis requires more than a string literal,

SQL computing time difference execution stored procedures, SQL time difference stored procedures -- datediff (day, 'compare time', GETDATE ()) DECLARE @ ctime INTSELECT @ ctime = datediff (day, (select max (InDate) FROM OrderSettlement), GETDATE (

Enable SSD storage in MySQL, and enable ssd in mysqlAuthor of enabling SSD storage in MySQL: chszs. All Rights Reserved. It cannot be reproduced without consent. Blogger home: http://blog.csdn.net/chszs Sometimes the read/write speed of the OS

Understanding and use of database connection pools and understanding of database connection pools1. What is a database connection pool? Official: the database Connection pool (Connection pooling) is a database Connection established when the program