Import and export of Oracle databases

Import and export of Oracle databases The import and export of Oracle databases is an important technical activity, which not only solves the import and export of databases, but also facilitates and quick data access. Use imp and exp to import and

Overall physical migration of Oracle databases on Linux platforms

Overall physical migration of Oracle databases on Linux platforms Overall physical migration of databases on Linux platformsRequirement: machine A is no longer in use. You need to migrate the Oracle of machine A to machine B.I have previously

Usage of the count function in MySQL

Usage of the count function in MySQL The count function is a function used to count records in tables or arrays. Here we will introduce the usage and Performance Comparison of the count function in MySQL. Count (*) returns the number of rows to be

Migrate Oracle database files to ASM

Migrate Oracle database files to ASM Read navigation Migrate data files to ASM Migrate log files to ASM Migrate control files to ASM Migrate data files to ASM Database migration in the case of Database Consistency: Start the database to the

Quick Reference for installation, deployment, and configuration of a single Oracle 11g instance on Linux

Quick Reference for installation, deployment, and configuration of a single Oracle 11g instance on Linux 1. re-build the Oracle user group of the host and standardize uid gid to ensure the permission specification for shared storage mounting or

Detailed process of using mysqld_multi to deploy a single-host multi-instance

Detailed process of using mysqld_multi to deploy a single-host multi-instance With the development of hardware, multi-core Linux systems have become a general trend, while MySQL is a single-process multi-thread, so the exploitation of multi-process

Preparation of RMAN backup policy for the DG Environment Database

Preparation of RMAN backup policy for the DG Environment Database Preparation of RMAN backup policy for the DG Environment Database:Primary database (Primary) Full database backupArchive backupDelete historical foldersStandby database

MySQL understands the indexing and indexing principles

MySQL understands the indexing and indexing principles [Understanding indexes] To understand indexes, you must first understand how data is stored on the hard disk. Different storage engines may adopt different measures. For example, the MySQL

Distributed Session based on Redis

Distributed Session based on Redis 1. OverviewWe can implement a Session-like mechanism by ourselves, using Redis and other distributed cache middleware. Redis is independent of the Application Server. The Session mechanism based on Redis

MySQL index and optimization Query

MySQL index and optimization Query An appropriate index can accelerate the query speed. There are four types: primary key, unique index, full-text index, and common index. Primary Key: It is unique and has no null value.Create table pk_test (f1 int

Use DBMS_SCHEDULER package to manage scheduled tasks

Use DBMS_SCHEDULER package to manage scheduled tasks Read navigation Create a scheduled task: Detailed description of supported task types: Example Manual execution plan Delete plan Dbms_scheduler is a package provided by Oracle to create

About password-less logon in Oracle and MySQL

About password-less logon in Oracle and MySQL Password-less logon can simplify the process to a certain extent. It is a good choice if it is password-sensitive but requires access permissions. It is a tangle of passwords and passwords, especially

Oracle Database Help

Oracle Database Help The Oracle Database Help class encapsulates the methods used to connect to the Oracle database, which can be called on other pages without repeated writes. Import java. SQL. Connection;Import java. SQL. DriverManager;Import java.

MySQL thread pool summary

MySQL thread pool summary Thread pool is a core function of MySQL5.6. For server applications, high concurrency requests are always a topic that cannot be bypassed, whether it is web Application Service or DB service. When there are a large number

Distributed Message Queue Based on Redis

Distributed Message Queue Based on Redis 1. Why do I need a message queue?When factors such as the speed or stability of "production" and "consumption" are inconsistent in the system, a message queue is required as an abstraction layer to bridge the

With rollup in MySQL

With rollup in MySQL MySQL's extended SQL has a very interesting application WITH ROLLUP. The same statistics (SUM, AVG, COUNT…) are performed based on the grouping statistics ...), Similar to the statistical functions in Oracle, Oracle's

Mysql innodb engine's shared and independent tablespaces, mysqlinnodb

Mysql innodb engine's shared and independent tablespaces, mysqlinnodb For innodb data storage files, we must first solve two conceptual problems: Shared tablespace and exclusive tablespace. (The innodb engine and MYISAM engine are very different. In

Oracle internal and external connections, oracle internal connections

Oracle internal and external connections, oracle internal connections Inner join: We usually connect tables to display data with matched IDs. SELECT * FROM a, B WHERE a. aid = B. bid only retrieves matched data. Outer connections: Left

MySQL DATE_FORMAT () function, mysqldate_format

MySQL DATE_FORMAT () function, mysqldate_formatDefinition and usage The DATE_FORMAT () function is used to display date/time data in different formats.Syntax DATE_FORMAT(date,format) DateThe parameter is a valid date.FormatSpecifies the output

Use sqlplus return output & quot; ^ H & quot; in X-manager to solve the problem. x-managersqlplus

Use sqlplus return output "^ H" in X-manager to solve the problem. x-managersqlplus Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will

Total Pages: 1013 1 .... 171 172 173 174 175 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.