NAV: SLTechnology News&Howtos > Database >

• 

  What are the permissions of the default roles CONNECT and RESOURCE

  For ordinary people, we grant them CONNECT,RESOURCE permissions after they are created, but generally speaking, it is enough to have these permissions, but do you know what specific permissions these two permissions have? the default permission of 1.CONNECT: ALTER

  2022-06-01 09:47:33 Views: 224
• 

  Modify the data type of a column with data in Oracle

  Because yesterday I went to another company to maintain the data, and after importing the data, I found that the column of the elements in the table was empty. At first, I thought there was something wrong with the data, but later I found that the type of the data in the table was CLOB, and if the data in the EXCLE did not match directly, then

  2022-06-01 09:47:33 Views: 257
• 

  Linux package Management-- rpm Command Management

  1. Overview of API:Application Program InterfaceABI:Application Binary Interface Unix-like ElF win

  2022-06-01 09:47:33 Views: 263
• 

  Install the latest version of the binary database mariadb in Centos 7

  1: experimental background; when Ma GE Education learns the chapter of MYSQL, experiment 2: experiment preparation for homework exercises; 1. First check whether there is mariadb on the virtual machine: rpm-qa mariadb*, if so, uninstall it; 2. Through yum info

  2022-06-01 09:47:29 Views: 269
• 

  Mysql study notes

  MySQL: relational database (Relational Database ManagementSystem), the so-called "relational" can be understood as the concept of "table". A relational database consists of one or more tables. Header (head

  2022-06-01 09:47:22 Views: 245
• 

  Where filtering and operators based on SQL (5)

  Use the WHERE clause to filter out rows that do not meet the criteria: considerations for WHERE filtering: the WHERE clause follows the FROM clause. The WHERE clause is followed by conditional expression column name, expression, constant comparison operator: =, < =, BETWEEN, IN

  2022-06-01 09:47:22 Views: 223
• 

  New slave library for MySQL

  Project background description: only one MySQL instance is running at the beginning of the project, and a slave library needs to be added to this instance later because of security, stress, backup and other reasons. Analysis: MySQL master and slave is based on binlog logs, so the master server is required to open bi

  2022-06-01 09:47:21 Views: 258
• 

  Mysql double host

  Master01 [client] port = 3306socket = / home/mysql/socket/mysql.sock#default-character-set=utf8 [mysqld]

  2022-06-01 09:47:18 Views: 230
• 

  Orace expdp filesize compression

  Environment description: today from the 4A remote computer copy dmp file, due to the file is too large, copy action can not be completed, so filesize specify the output file size, and then compress. [oracle@mobile61 dpdump] $expd

  2022-06-01 09:47:15 Views: 292
• 

  Oracle DataBase single instance using ASM case (3)-- Oracle 10g Application

  Oracle DataBase single instance using ASM case (3)-- Oracle 10g Application system Environment: operating system: RedHat EL5 (64) Oracle Software: Oracle 10gR2 single in Oracle 10g

  2022-06-01 09:47:15 Views: 257
• 

  How to solve the error of MariaDB server when backing up data in MySQL Workbench

  The server is running on MariaDB 10.2.There is an error in using MySQL Workbench: mysqldump: Couldn't execute 'SELECT COLUMN_NAME, J

  2022-06-01 09:47:11 Views: 299
• 

  LAMP compilation and installation + wordpress+discuz

  # Software download # Open Source blog Wordpress download address: https://cn.wordpress.org/wordpress-4.7.4-zh_CN.tar.gz#PHP 7 download address: http://cn2

  2022-06-01 09:46:41 Views: 273
• 

  Storage network

  ① LOCAL DISK local disk ② DAS (Decimal Adjust for Subtraction or Direct-Attached Storage), that is, direct-attached storage of an open system, which mainly depends on the server host

  2022-06-01 09:46:41 Views: 285
• 

  SqlServer series notes-variables

  1. Local variables: local variables must be prefixed with the tag @, such as @ Age int local variables: declare first, and then assign DECLARE @ variable name data type DECLARE @ bookName varchar (20) SET @ book

  2022-06-01 09:46:26 Views: 298
• 

  MySQL 5.7.15 installation (binary version)

  0. Create mysql user and group information [root@gxoradb1 ~] # groupadd mysql [root@gxoradb1 ~] # useradd-r-g mysql-s / bin/false

  2022-06-01 09:46:26 Views: 276
• 

  How to manage archive files and archive directories

  If we only have one archive log file, what if the archive log file is corrupted or the disk on which the log file is located is damaged? At this time, our archived log files are lost, and the data must not be fully recovered. At this point, we can set up multiple different filing places in Oracle.

  2022-06-01 09:46:26 Views: 219
• 

  Installation of Oracle 11g detailed tutorial based on RHEL 6.5 (5) & mdash;— installation of Oracle

  5 install Oracle [root @ oracle ~] # cd / temp/ [root@oracle temp] # lslinux.x64_11gR2_database_1of2.zip lost+fou

  2022-06-01 09:45:55 Views: 294
• 

  Deploy Physical Dataguard and two-node Oracle RAC environment

  For more information about oracle rac deployment, please visit the http://worms.blog.51cto.com/969144/1416975 system information here: RAC PrimaryRACDG1 (host) RAC

  2022-06-01 09:45:35 Views: 263
• 

  Software installation and Management under Linux system

  Software installation and management under Linux system 1. Overview of RPM packages 1. Components of binary packages: binaries, library files, configuration files, help files [root@dayi123 ~] # rpm-qpl/mnt/cdrom

  2022-06-01 09:45:32 Views: 225
• 

  Mha related Settings

  / etc/my.cnfread_only=on startup entry added-- relay-log-purge=off/etc/systemd/system/mysql.service# Simple MySQL sy

  2022-06-01 09:45:20 Views: 212