NAV: SLTechnology News&Howtos > Database >

• 

  Oracle 12c creates pluggable database (PDB) and users

  Because oracle 12c uses the CDB-PDB architecture, similar to docker, multiple pluggable-db can be loaded within container-db, so additional configuration is required after installation. 1. Modify listener.ora

  2022-06-01 12:34:07 Views: 254
• 

  A preliminary study on Oracle query Transformation

  An overview of the role of the Oracle query converter is to rewrite the original sql into semantically identical statements in order to achieve a more efficient sql. There are four main technologies of query transformation: subquery expansion, view merging, predicate push, and star transformation. Understanding query transformation is the basis of mastering SQL optimization.

  2022-06-01 12:33:55 Views: 219
• 

  The function is in invalid state in oracle

  The compiled error message is pls-00103: the symbol "" appears at one of the following times: the reason for begin case declare is that there are illegal characters, such as full-width spaces.

  2022-06-01 12:33:51 Views: 280
• 

  Upgrade oralce 11g database to 12c

  Windows2012 installation 12c cdbSQL-confirm the current cdbSQL > select name,cdb from vested databasescarf name CDB--ORCL

  2022-06-01 12:33:47 Views: 241
• 

  Hadoop hive sqoop zookeeper hb

  6. Problem and solution 1. Problem description: WARN util.NativeCodeLoader: Unable to load native-hadoop library foryour platform …

  2022-06-01 12:33:43 Views: 244
• 

  Zabbix3.0+LNMP installation

  1. Zabbix3.0 Experimental Environment Nginx:1.10.2Mysql: 5.6.33PHP:5.6.12Zabbix:3.0.5Zabbix_server_IP: 192.168.10.150 (based on LN

  2022-06-01 12:33:37 Views: 239
• 

  Common 1062 and 1032 error handling methods in replication

  Error handling in replication traditional replication errors skip: stop slave sql_thread; set global slq_slave_skip_counter=1;start slave sql_thread; G

  2022-06-01 12:33:37 Views: 283
• 

  Docker uses supervisor to start MongoDB

  Docker in the study of continuous improvement, continuous learning, some of the original methods are optimized. Image download address: old solution address: if immature, no upload new solution address: https://github.com/aarongo/centos-m

  2022-06-01 12:33:37 Views: 218
• 

  MySQL data type-integer type

  1. Background * MySQL supports SQL standard integer types integer (or INT) and SMALLINT. As a standard extension, MySQL also supports integer types TINYINT, MEDIUMINT, and BIGINT2. Storage and value norms required for integer types

  2022-06-01 12:33:36 Views: 269
• 

  4 boutique WeChat Mini Programs recommended, after using it can not be separated!

  A lot of people started playing with WeChat Mini Programs. In fact, there are many practical Mini Program on Wechat. Today, the editor will recommend a few Mini Program that you may use on a daily basis. 1. NetEase youdao Dictionary NetEase youdao Dictionary Mini Program compared with APP, its function is limited to translation, but sometimes it is urgent.

  2022-06-01 12:33:36 Views: 292
• 

  Couchbase uses cbbackup to back up

  The cbbackup tool is a flexible backup command that allows you to back up different combinations of local and remote nodes and data involving your cluster: single node, single buckets, single node, all buckets, entire cluster, single buckets, entire cluster, all bu

  2022-06-01 12:33:36 Views: 295
• 

  Msyql database

  # forget password vim / etc/my.cf add skip-grant-tables to [mysqld] restart Mysql now you can directly enter mysql, change the root password and execute the following command USE mysql;UPD

  2022-06-01 12:33:35 Views: 289
• 

  Suse11sp3 executes root.sh failed bug processing

  When prompted to execute root.sh on node 1 and node 2, the error report is as follows: node1:/u01/app/11.2.0/grid #. / root.shPerforming root user operation for O

  2022-06-01 12:33:35 Views: 267
• 

  Mariadb master-slave server experiment hot standby 1

  Mariadb Master-Slave replication mariadb Master-Slave replication Overview: the basic problem solved by replication is to keep the data of one server synchronized with another server. A master server can connect to multiple slave servers, and the slave server can in turn act as the master server. Master server and slave service

  2022-06-01 12:33:06 Views: 211
• 

  Delete .adobe suffix ransomware (delete ransomware + restore data)

  The adobe ransomware is a file encryption virus classified as blackmail software. This malicious encryption malware virus has been programmed by malicious network swindlers to take advantage of your important files. The sole purpose of this dangerous threat is to force the victim to pay. This troublesome malware infection is usually in different ways.

  2022-06-01 12:33:05 Views: 229
• 

  Linux Learning Notes 2

  Compression and decompression format: gz bz2 xz zip z compression algorithm, different algorithms, different compression ratio compress: filename.Zuncompress: cannot compress a folder, it will compress the files in the folder individually, gzip:.

  2022-06-01 12:32:59 Views: 234
• 

  Mysql basic knowledge learning

  1 indicates that database commands are case-insensitive, for example, "CREATE DATABASE test" and "create database test" are equally valid. 2 connect to database 1) connect to the MYSQL connection database on this machine

  2022-06-01 12:32:59 Views: 288
• 

  MS SQL database cannot delete Job

  Write it down so as not to forget. Select * from dbo.syscollector_execution_log_internaldelete dbo.syscollector_execution_log_

  2022-06-01 12:32:59 Views: 211
• 

  Redis master-slave configuration

  The master-slave configuration of redis is so simple that it hurts. The ip:192.168.1.100 of the master redis modifies the configuration file / etc/redis/redis of the slave redis from the ip:192.168.1.101 of redis

  2022-06-01 12:32:55 Views: 223
• 

  Sqoop 1.4.6 installation

  Download the installation package http://archive.apache.org/dist/sqoop/1.4.6/sqoop-1.4.6.bin__hadoop-2.0.4-alpha.tar.gz. I installed it in hadoop.

  2022-06-01 12:32:45 Views: 301