NAV: SLTechnology News&Howtos > Database >

• 

  Basic Operation of Oracle Database-- Tablespace Management

  Introduction: ORACLE physically consists of the following files on disk: the tablespace composed of data files and control files and LOGFILE only talks about the related data files. First of all, the concept is clear: tablespaces are a concept defined within ORACLE to unify ORACLE physics and logic.

  2022-06-01 08:43:10 Views: 222
• 

  Db2 scheduled tasks, backup scripts

  [db2inst1@db2 ~] $crontab-l3002 * / bin/sh / home/db2inst1/backup/backup.sh [db2inst1@db2 ~] $cat

  2022-06-01 08:43:09 Views: 295
• 

  Talking about the INNODB engine of MYSQL engine

  There are several commonly used MYSQL engines, MRG_MYISAM, CSV, MyISAM, InnoDB, MEMORY, NDB, among which MyISAM and InnoDB are the most commonly used storage engines for mysql. Today we mainly discuss I

  2022-06-01 08:43:09 Views: 270
• 

  Centos 7 install RocksDB

  1. Installation depends on yum-y install lrzsz git gcc gcc-c++ lz4-devel yum-y install snappy snappy-devel zlib zlib-de

  2022-06-01 08:43:09 Views: 246
• 

  Basic operation of SQLServer

  The creation of SQLServer basic operation database 1. Open the "SSMS" tool and connect to SQLServer. Right-click "Database"-"New Database" 2, and specify the new database name and owner. When you create a new database, the system automatically creates a main data file and a

  2022-06-01 08:42:39 Views: 234
• 

  Mysql multi-instance shutdown script

  #! / bin/bashport=3306basedir=/application/mysqldatadir=/data/$port/datapidfile=/data/$port/mysql.pids

  2022-06-01 08:42:39 Views: 234
• 

  Get string length, character length, byte length

  In the basic function of Metrics Rapid Development platform, there is a len function to obtain character length. Specific usage is: len ("123Abc string") the result of this method is: 9, that is, the total number of characters, there is no distinction between single-byte and double-byte cases. If a field is set

  2022-06-01 08:42:38 Views: 297
• 

  NGINX website Service-LNMP platform and Application

  Experimental requirements: LNMP implements multiple virtual hosts, deploys wordpress and phpmyadmin, and provides https experimental environment for phpmyadmin: LNMP CentOS 7.2x86_64 IP:172.16.251

  2022-06-01 08:42:21 Views: 209
• 

  Complete implementation of Master-Slave replication Model of Database Cluster

  Master-slave configuration process: see https://mariadb.com/kb/en/library/setting-up-replication/ https://dev.mysql.com/doc

  2022-06-01 08:42:09 Views: 233
• 

  Install oracle 11.2.0.4 in Docker

  Environment preparation host: CentOS Linux release 7.3.1611Docker Version: 1.12.5Oracle 11.2.0.4 basic image: docker.io/centos main step

  2022-06-01 08:42:09 Views: 233
• 

  Oracle 11g correct deletion of archive logs

  1. Log in to rman with oracle and connect to the database RMAN > connect target / RMAN > rman target / 2, list and confirm the archive log path RMAN > list archivelog all

  2022-06-01 08:42:09 Views: 226
• 

  Oracle VPD POLICY DBMS_RLS

  Background: recently, when a company was doing inventory collection in ERP, it found that it reported an error after selecting the material: user exit unexpected error (1), from the QT_EU.Create structure tree. This form interface is customized, and the error comes from querying existing information. Analysis problem: then inquire about the available quantity of the material.

  2022-06-01 08:42:00 Views: 280
• 

  Record the processing process of a bad block in the database caused by a storage failure

  Note that a storage failure leads to a bad block processing process of the database online architecture description: IBM DS4800 stores a set of P560 minicomputer HA architecture, a set of two database resource groups usually run in any one of the HA architecture, resource groups all use shared storage

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

  Control file backup of Oracle RMAN backup

  Enter the RMAN interface rman target / RMAN > modify the backup mode of control files: automatic backup RMAN > configure controlfile autobackup on; to check whether the backup of control files is automatic backup R

  2022-06-01 08:41:59 Views: 279
• 

  Mysql database basic command-simultaneous operation of multiple data

  Add primary key mysql > alter table info add primary key (id); Query OK, 0 rows affected (0.07 sec) Records: 0 Dupl

  2022-06-01 08:41:47 Views: 283
• 

  Centos7 initializes the MySQL5.7 database

  Centos7 initializes the MySQL5.7 database because the previous article on how to install MySQL5.7 under Centos7 did not specifically cover an important step before starting to use the database, which is to initialize the database. So today I will fill in this specific operation for you.

  2022-06-01 08:41:47 Views: 291
• 

  Solution to the inconsistency between postgresql server version and psql version

  $psql-U peimsmdata-h 127.0.0.1 peimsmcould not change directory to "/ root" Password for user peims

  2022-06-01 08:41:43 Views: 218
• 

  Mongodbdb enables wiredTiger engine and zlib compression

  Public static void main (String [] args) {MongoClientOptions.Builder build = new MongoClientOptions.Bu

  2022-06-01 08:41:43 Views: 270
• 

  MongoDB 3.2.4 configuration referenc

  [mongo@vq12stmsg01 / app/mongo] $toptop-13:00:41 up 2 days, 21:35, 3 users, load average: 0.31,0.23

  2022-06-01 08:41:43 Views: 211
• 

  2. Basic operation of database

  MySQL commands are mainly divided into the following categories: DML:Data Manapulate Language: data manipulation language (manipulating data in table) INSERT, REPLACE, UPDATE, DELETEDDL:Data

  2022-06-01 08:41:40 Views: 263