NAV: SLTechnology News&Howtos > Database >

• 

  [OGG] download and install OGG

  [OGG] OGG download and installation part 1. 1 BLOG document structure figure 1. 2 preface part 1. 2.1 guide to technical enthusiasts. After reading this article, you can master the following skills, and you can also learn some other knowledge that you do not know, ~ O (∩ _ ∩) Olympiad: ① O

  2022-06-01 13:00:40 Views: 301
• 

  Oracle LOB

  The Oracle .NET Framework data provider includes the OracleLob class, which is used to work with Oracle LOB data types. OracleLob may be one of the following OracleType data types:

  2022-06-01 13:00:40 Views: 248
• 

  Performance analysis: hash index causes delete to slow

  In the front-end time, the application staff reported a performance problem: in the production environment, the database runs very slowly in the early hours of every day, and some EVENT fails, resulting in abnormal functions of some applications. Check the database according to the time period provided by the application staff. First connect to the host CPU, IO and database

  2022-06-01 13:00:34 Views: 216
• 

  MySQL stored procedure CASE statement usage

  MySQL provides an alternative conditional statement CASE. MySQL CASE statements make the code more readable and efficient. There are two forms of CASE statements: simple search CASE statements. Let's talk about the usage of CASE statements in MySQL stored procedures. 1Perfect case language

  2022-06-01 13:00:30 Views: 227
• 

  Overview of database softwar

  1. Relational database refers to the database that uses the relational model to organize the data. Relational model was first proposed by Dr. E.F.Codd, a researcher at IBM, in 1970. in the following decades, the concept of relational model was fully developed and gradually became dominant.

  2022-06-01 13:00:30 Views: 205
• 

  Configure synchronous replication of Goldengate from Oracle to PostgreSQL

  1. Platform environment Oracle:rhel6.7+Oracle11.2.0.4 ip:192.168.56.2PostgreSQL:rhel7.2+Pg9.6.1 ip:192.168.56.25Golden

  2022-06-01 13:00:30 Views: 282
• 

  MySQL incremental backup

  The characteristics of incremental backup the advantage of incremental backup is that there is no duplicate data, the backup quantity is small, and the time is short. The disadvantage is also obvious that all incremental backups need to be restored after the last full backup and full backup, and it is cumbersome to restore all the increments one by one. MySQL does not provide straightness.

  2022-06-01 13:00:29 Views: 260
• 

  Oracle Advanced Group

  / * Oracle Advanced Group * * / / *-auther:similarface

  2022-06-01 13:00:24 Views: 299
• 

  Navicat usage tutorial: automating Database replication with Navicat Premium 12 (4)

  Download the latest version of Navicat Premium Navicat Premium is a management tool that can connect to multiple databases. It allows you to connect to MySQL, Oracle and PostgreSQL databases in a single program at the same time.

  2022-06-01 13:00:12 Views: 202
• 

  Percona pt-archiver Reconfigurable Edition-- A tool for archiving large table data

  Percona pt-archiver refactoring version-large table data archiving tool believes that many friends, in daily docking development, many big tables do not take any form of business segmentation, data is constantly poured into a table, sooner or later, disk space alarm. As

  2022-06-01 13:00:09 Views: 289
• 

  DBUnit use case

  1. Concept DbUnit is an extension of JUnit for database-driven projects. In addition to providing some common functions, it can place your database in a state between test cycles. 2. Maven Integrated DBUnit2.1 Guide package

  2022-06-01 13:00:09 Views: 287
• 

  Method of moving one table to another schema

  There are several common methods: 1. Expdp/impdp2, ctas + parallel + nologin the second method should note that the primary key is not created in the new table NOT NULL constraints that we

  2022-06-01 13:00:08 Views: 293
• 

  Notes on oracle 11g installation

  Install ORACLE 11G 64-bit error message: prepare to launch Oracle Universal Installer / tmp/OraInstall2012-07-25room03-10-02PM from the following address. Just a moment, please

  2022-06-01 13:00:08 Views: 232
• 

  Connect apache geode with java

  Yesterday, I studied apache geode for a long time. It is relatively simple to query and operate through the gfsh command, but how to query through the program because of too little seniority, did not understand, after a long time to understand 1. Create a test regioncreate region-- name

  2022-06-01 13:00:08 Views: 266
• 

  On prefork and worker Mode switching of Apache

  The problem is that on Prima/Plesk/Virtuozzo, apache uses the rpm package of httpd-2.0.5x that comes with the system on redhat linux, and defaults to prefork mode instead of worker mode.

  2022-06-01 13:00:07 Views: 299
• 

  Install the Oracle12.2 database silently

  Experimental environment: operating system: Redhat 6.464-bit database: Oracle 12c R2 1, preparation before installation 1, create users and groups [root@wjq~] # groupadd-G1000 oinstall//oins

  2022-06-01 13:00:07 Views: 227
• 

  Common parameters of expdp and impdp

  The parameters of daily use of expdp and impdp are summarized as follows: 1. ATTACH-attach this option is used to establish a relationship between a customer session and an existing export function. The syntax is as follows: ATTACH= [schema _ name.] job_nam

  2022-06-01 13:00:07 Views: 212
• 

  The use of SUBSTR function

  Http://docs.oracle.com/cd/E11882_01/server.112/e41084/functions181.htm#i87066Substr syntax: the part of a character that the substr function returns

  2022-06-01 13:00:03 Views: 260
• 

  SQLServer does not need Restore recovery erroneous deletion table (2): restore table data

  In the previous article, "SQLServer does not need Restore recovery to erroneously delete tables (1): restore table structure", restore table structure is described, and table data recovery EXEC Recover_Dropped_Table_SQL_Porc 'db01','Lo is performed here.

  2022-06-01 12:59:57 Views: 247
• 

  What oracle operation and maintenance need to master

  What oracle operators need to know: 1. Install oracle 11g using OUI and commands on rhel 6 and rhel 7. 2. Planning file storage includes control files, data files, log files, and creation of tablespaces. 3. Create users and grant basic permissions

  2022-06-01 12:59:57 Views: 245