NAV: SLTechnology News&Howtos > Database >

• 

  Oracle 11g R2 user and Mode (schema)

  Syntax for creating a user: Create user username, identified by password, default tablespace tablespace, quota size, on tablespace; note: when creating a user, although the user name is written in lowercase

  2022-06-01 12:41:31 Views: 258
• 

  Yum installation method of mysql

  Install mysql1,wget https://dev.mysql.com/get/mysql57-community-release-fc26-10.noarch.rpm using yum, or directly in mys

  2022-06-01 12:41:30 Views: 261
• 

  MySQL notes are free of charge

  I don't know if you often write documents and take notes when you are working or studying. ~ the author suggests that we try to write more documents and take more notes. Write down all the problems and solutions you encounter in your work and study, and you can keep the good articles written by others. In the long run, you will find

  2022-06-01 12:41:30 Views: 215
• 

  Why precompilation can prevent sql injection

  Why does precompilation prevent sql injection? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way. The reason why precompilation can prevent sql injection: after precompilation, sql

  2022-06-01 12:41:30 Views: 203
• 

  Construction of Lepus3.8- Heavenly Rabbit mysql Database Monitoring system

  Lepus3.8- Heavenly Rabbit mysql database monitoring system lepus is an open source database monitoring software that can monitor a variety of database status in detail, such as mysql slow query and master-slave status. This is the web monitoring page: build (CentOS 6.7 system in this article)

  2022-06-01 12:41:21 Views: 258
• 

  Zabbix 3.2compiler installation

  Install the platform centos 6.8 2.6.32-642.el6.x86_64 to turn off the firewall and selinux software version apr-1.5.2 apr-util-1.5.4 pcre-8.39 httpd-2.4.

  2022-06-01 12:41:15 Views: 217
• 

  MySQL testing tool sysbench

  1. Configure epel source, install sysbenchyum install-y sysbench2, initialize data sysbench/ usr/share/sysbench/tests/include/oltp_

  2022-06-01 12:41:12 Views: 241
• 

  Query whether the tablespace is set to augment

  After logging in to the database table, enter select TABLESPACE_NAME. The field in AUTOEXTENSIBLE from dba_data_files;AUT shows YES, which indicates that the tablespace sets the self-increment policy, while the display NO says

  2022-06-01 12:41:12 Views: 290
• 

  Error ORA-01102: how to handle cannot mount database in EXCLUSIVE mode

  Problem description: in RAC environment, if you want to enable archive logs, use SQL > alter system set cluster_database=false scope=spfile;-- > to modify the cluster to a single instance and then modify the master.

  2022-06-01 12:41:11 Views: 290
• 

  010-stored procedures and functions

  one。 The attitude towards stored procedures and functions should be minimized in practical projects for the following reasons: 1. Poor portability, stored procedures in MySQL may not be available when transplanted to sqlsever. two。 Debug trouble, report an error in db and in the application layer

  2022-06-01 12:41:11 Views: 251
• 

  Install Oracle12c under CentOS7

  Complete installation of Oracle 12cOracle under CentOS7 introduces Oracle Database, also known as Oracle RDBMS, or Oracle for short. It is a relational database management system of Oracle. It's in the database field.

  2022-06-01 12:41:05 Views: 300
• 

  Function Learning and transaction of Oracle

  Oracle function Learning 1. Character function is the most commonly used function in oracle lower (char): convert a string to lowercase format upper (char): convert a string to uppercase format length (char): return the length of the string.

  2022-06-01 12:40:57 Views: 215
• 

  Mysql to create users and ssc website Construction

  There are three ways for mysql to create users: ssc website construction [enterprise E: 1793], INSERT USER table method, CREATE USER method, GRANT method. 1. Through the CREATE USER command

  2022-06-01 12:40:57 Views: 222
• 

  Oracle 11g production environment cleanup archive log script

  Recently, several customer production environments have encountered some failures, due to the opening of archiving, no deployment of delete archiving scheduled tasks, the following you can refer to, after my test, normal operation in the production environment. * * roidba delete archive log script * * 1. Archiving based on RHEL6 server

  2022-06-01 12:40:57 Views: 268
• 

  The aggregator assists in cross-summarization of MongoDB calculations

  It is difficult to implement cross-summarization in MongoDB, and it is also quite complicated to take out the data and summarize them in high-level languages such as Java. Therefore, you can consider using the aggregator esProc to assist MongoDB to complete cross-summarization. Let's take a look at the specific approach through an example.

  2022-06-01 12:40:57 Views: 259
• 

  Oracle additional logs (supplemental log)

  Additional logs (supplemental log) instruct the database to add additional information to the log stream to support log-based tools such as logical standby, streams, GoldenGate, LogMiner. Can be found in the data

  2022-06-01 12:40:56 Views: 240
• 

  Construction of PXC three-node cluster system

  1. Concept: Percona Xtradb Cluster, abbreviated as PXC. Is a MySQL cluster based on the Galera plug-in. For detailed principles, please move to my other article: understanding the principle of PXC Cluster 2. Building: official manual address: https://www

  2022-06-01 12:40:38 Views: 262
• 

  Rlwrap cannot be used after installation

  After installing the rlwrap package, change the alias of the sqlplus command [oracle@up ~] $vim .bashrcalias sqlplus='rlwrap sqlplus'alias sql='rlwr

  2022-06-01 12:40:08 Views: 247
• 

  MongoDB Advanced Syntax

  And operation: implicit and operation: db.getCollection ("the_table"). Find ({"age": {"$gt": 20}, "sex": "male"}) / / A pair of query conditions for age and sex fields are required

  2022-06-01 12:40:08 Views: 206
• 

  Oracle Grid Infrastructure Install or Upgrade Fails With INS-20802

  RAC on Windows: Oracle Grid Infrastructure Install or Upgrade Fails With Error INS-20802 if Microsof

  2022-06-01 12:40:04 Views: 273