NAV: SLTechnology News&Howtos > Database >

• 

  Oracle Chinese numerals to Arabic numerals

  CREATE OR REPLACE FUNCTION chi2num (chivalue IN VARCHAR2) RETURN NUMBER ISTYPE MAP IS TABLE OF BINARY

  2022-06-01 15:59:30 Views: 274
• 

  Informix lock

  1. When you unload a table, it appears: 244:Could not do a physical-order read to fetchnext row107:ISAM error:record is lo

  2022-06-01 15:59:16 Views: 211
• 

  Troubleshooting SQL Server memory

  SQLServer memory troubleshooting translated from: https://blogs.msdn.microsoft.com/karthick_pk/2012/06/15/troubleshooting-sql-serve

  2022-06-01 15:59:16 Views: 273
• 

  Deployment of Zabbix2.2.6 Monitoring system under CentOS64 bit 6.5

  System environment: [root@it3246] # cat/etc/redhat-releaseCentOS release 6.5 (Final) software environment LAMP:1. Install on the basis of existing LAMP or LNMP

  2022-06-01 15:59:16 Views: 243
• 

  Oracle Study-AIX6.1 to build Oracle 10gR2 RAC (2)

  Oracle Study-AIX6.1 build Oracle 10gR2 RAC (2) 1. Check the system I _ peg O (for Oracle databases you need to enable asynchronous I _ Unip O) for AIX6.1, the default asynchronous I _ Unip O is automatically activated when required, no

  2022-06-01 15:59:15 Views: 289
• 

  Mysq Foundation

  1. Concept   database, folder database table, file data row, a row of data in a file 2. Initial: show databases; # check what data is available in the current Mysql and what folders are in the root directory create database database name

  2022-06-01 15:59:12 Views: 227
• 

  Derivative operation of MongoDB based on timestamp

  There is a need to assist in extracting cashloanDb from a data system involving MongoDB collections: cardBill (time period 6.1-8.28), cardReport (time period 2.1-8.28) if time retrieval is not supported

  2022-06-01 15:59:12 Views: 243
• 

  Description of common parameters for MySQL slave library configuration

  # enable slave log, so that you can chain copy log-slave-updates=1# whether the slave library is read-only, 0 means read-write, 1 means read-only read-only=1# only copies a table replicate-do-table=tablen

  2022-06-01 15:59:09 Views: 280
• 

  Summary of Mysql Master-Slave backup and recovery

  Mysql master-slave implementation 1, configure master-slave node service profile 1.1, configure master node: [mysqld] binlog_format=mixedlog-bin=master-binserver-id=1port=

  2022-06-01 15:59:00 Views: 273
• 

  There is an error in master-slave synchronization: Slave_IO_Running: Connecting

  The following error occurred in master-slave synchronization: Slave_IO_Running: ConnectingSlave_SQL_Running: Yes solution: the main cause that causes lave_IO_Running to be connecting

  2022-06-01 15:58:59 Views: 232
• 

  Practice of MongoDB Log switching (Rotate Log Files)

  MongoDB log switching (Rotate Log Files) practice 1. Under mongo shell, execute the logRotate command: use admin db.runCommand ({logRotate

  2022-06-01 15:58:59 Views: 217
• 

  New features of mysql5.7

  After the mysql5.7 version comes out, there are still a large number of modifications and some tuning, fix some bug, delete some old parameters, and simply sort it out here because the usual binary package is used to install mysql, so here we will start with the binary package deployment of mysql. First

  2022-06-01 15:58:59 Views: 229
• 

  Oracle 12C CDB, PDB common management commands

  -- View PDB information (in CDB mode) show pdbs-- View all pdbselect name,open_mode from vdatabases;-- v$pdbs is PDB Information View select co

  2022-06-01 15:58:59 Views: 243
• 

  Install mysql5.6 and multi-instance configuration

  Centos mini 6. 5 install mysql5.6.41. Download and install package cloud disk address: http://pan.baidu.com/s/1bpsgXUf installation requires package tool yum-y install wget vi

  2022-06-01 15:58:58 Views: 215
• 

  Oracle cold backup script

  Principle: cold backup database completes the process of copying all physical system files in a closed state, also known as offline backup suitable for non-archive mode, the database is in a consistent state step of first getting all the physical file locations of the database running in the running database, and then shutting down the database in the plan (sh

  2022-06-01 15:58:58 Views: 209
• 

  Mysql database-user and password management

  Create user and password mysql > create user 'zhao'@'loacl' identified by' 123123 password MySQL > use mysql; create ciphertext password mysql > select

  2022-06-01 15:58:43 Views: 287
• 

  EMCA configuration OEM

  Under oracle user, type directly (if you start listener first) emca-config dbcontrol db-repos recreateSTARTED EMCA at Dec 8, 2012

  2022-06-01 15:58:42 Views: 279
• 

  VMWare fault repair one, two, three

  1. The clone cannot be started: Device eth0 does not seem to be present, delaying initialization failure background: in vmware workstation

  2022-06-01 15:58:42 Views: 247
• 

  Basic knowledge of MongoDB (1)

  With the rapid development of the Internet industry, there are many different solutions for data storage and architecture optimization, such as relational database, non-relational database, data warehouse technology and so on. The emergence of more database products has solved the problem of data storage for us, such as Redis buffer

  2022-06-01 15:58:42 Views: 274
• 

  Stored procedure + function to create data myql

  Insert N records into the identity table, NumberPurge Q _ drop table if exists t_identity p: the number of records inserted in each insert statement, the number of loops determined by the number of temporary tables, and the input parameters of the stored procedure-identity information table

  2022-06-01 15:58:42 Views: 240