NAV: SLTechnology News&Howtos > Database >

• 

  Oracle deletes large amounts of data in batches

  In many cases, we have to clean up a large table of data, such as hundreds of millions of dollars, the business can not be stopped, but can only delete, in this case, batch deletion is a good way. Create or replace procedure delBigTab-batch submission

  2022-06-01 06:30:31 Views: 261
• 

  Oracle Rac Delete Node

  Oracle inventory stores configuration and operation information on the node and updates automatically when the node is deleted. Oracle Rac 11g R2 is very easy to remove nodes: logically unlock a cluster node from the cluster and shut it down, which can be separated from the cluster, and then

  2022-06-01 06:30:31 Views: 252
• 

  Mysql 5.7sql_mode=only_full_group_by problem

  Com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression # 2 of SELECT list is not in GR

  2022-06-01 06:30:31 Views: 218
• 

  Mongodb shard fragmentation technology

  Start route process to configure route process and start it, as follows: [root@localhost ~] # / usr/local/mongo/bin/mongos-- port 40000

  2022-06-01 06:30:31 Views: 298
• 

  Oracle 12c uses SQL*Plus to create and mobile application Seeds

  There are several ways to create an application seeds, including using CDB seed, cloning an existing PDB or Non-CDB, and attaching an uninstalled PDB. You can also remove the application seeds from the application container. In order to create a new

  2022-06-01 06:30:31 Views: 297
• 

  Tdposync utility-IBM Tivoli Storage Manager for Databases

  Https://www.ibm.com/support/knowledgecenter/en/SSGSG7_7.1.0/com.ibm.itsm.db.orc.doc/r_dporc_util_tdp

  2022-06-01 06:30:13 Views: 251
• 

  Many kinds of OPPO phones like to mention ColorOS 6, netizens: the original Green Factory system is so excellent.

  With the fierce competition in the mobile phone market, the hardware has entered a stage of high assimilation, which makes many mobile phone manufacturers regard software innovation as a new starting point. There are many smart phone systems with distinct characteristics in China. For example: Huawei EMUI, Xiaomi's MIUI and OPPO's color

  2022-06-01 06:30:13 Views: 286
• 

  Hand in hand to teach you to install Data Guard

  (1) the main library installs the database, and the standby library only installs the software. we can copy the virtual machine when the main library finishes installing the software. When the main library uses dbca to build the database, the global database chooses szscpdb,sid and szsc. (2) configure master database and slave database information master database: operation

  2022-06-01 06:30:13 Views: 264
• 

  The wave of young people in Goose Factory uses "clouds" to monitor clouds.

  Introduction: "Green water and green mountains is Jinshan and Silver Mountain". With our country strengthening legislation and devoting great efforts to environmental control, we have obviously felt that the atmospheric environment around us is constantly improving, in addition to the city-level monitoring data of the National Meteorological Bureau. What is the micro-environment around us like? The next step

  2022-06-01 06:30:10 Views: 272
• 

  Mirror production by Docker No.2 Institute

  1. Interactive commands are not allowed in dockerfile. FROM centos:6.9 loads the image RUN curl-o / etc/yum.repos.d/CentOS-Base.repo http://mirr

  2022-06-01 06:30:04 Views: 224
• 

  ORACLE 11.2.0.3 muri 11.2.0.4

  Stop listening (two-node grid execution) lsnrctl stop to check whether the application is connected (two-node root execution) ps-ef | grep rac | grep LOCAL=NO creation directory (two-node root execution) mkdir

  2022-06-01 06:30:03 Views: 200
• 

  Authoritative Guide to MySQL (3rd Edition)

  MySQL authoritative Guide (3rd Edition): Detail:MySQL authoritative Guide (3rd Edition) [@ more@]

  2022-06-01 06:29:58 Views: 218
• 

  ORACLE expdp backup and ORA-31693, ORA-02354, ORA-01555

  Recently, an exception occurred in the expdp backup of an integrated network management system. The error message is as follows: Export: Release 10.2.0.4.0-64bit Production on Tuesday, December, 2016 11:30

  2022-06-01 06:29:58 Views: 219
• 

  Building MySQL Cluster to achieve High availability

  Overview and installation environment of MySQL cluster building high availability MySQL cluster MySQL Cluster is a highly practical and highly redundant version of MySQL suitable for distributed computing environment. Cluster means "cluster" in Chinese. It uses NDB Clust.

  2022-06-01 06:29:58 Views: 271
• 

  Oracle Externale Tables

  Oracle Externale TablesCreating External Tables You create external tables using the CREATE TABLE st

  2022-06-01 06:29:52 Views: 274
• 

  Detailed explanation of eye-catching characteristics of MariaDB 10.0

  Many students must have heard of MariaDB. As one of the important branches of MySQL, it continues to be completely open source (MySQL also has many useful features for a fee), and is widely used by many large Internet companies (such as Google, Twitter). meanwhile,

  2022-06-01 06:29:48 Views: 262
• 

  Installation and explanation of MySQL

  One: database explanation before 15.6 source code installation source code format. / configure option make make install2 yum installation 6 yum-y install mysql-server mysqlser

  2022-06-01 06:29:48 Views: 295
• 

  Problem diagnosis of abnormal detection in tablespace

  I don't know how you manage the tablespace at work, but you can be divided into two groups. In the previous company, we preferred to allocate all the space directly, such as 500G capacity planning, then prepare 500G in advance, and the other is that if I give 200g first, the subsequent space will automatically increase, anyway.

  2022-06-01 06:29:48 Views: 231
• 

  Exp/imp uses pipelines to directly export and import

  Exp/imp uses pipelines to directly export and import files without landing; mknod / backup/dmp/pipe pexp\'/ as sysdba\ 'file=/backup/dmp/pipe log=expsco

  2022-06-01 06:29:47 Views: 274
• 

  MySQL5.7 Master-Slave replication-Asynchronous replication Building

  Two servers, the system is Redhat6.5,MySQL version 5.7.18. 1. On the main library, create a user for replication and grant replication slave permission. The user repl is created here, and it can be 10.10.10 from IP.

  2022-06-01 06:29:47 Views: 250