NAV: SLTechnology News&Howtos > Database >

• 

  Oracle 11G undo tablespace error

  1. When opening the database, prompt that the undo tablespace does not exist SQL > alter database open;alter database open*ERROR at line 1:ORA-01092: ORACLE I

  2022-06-01 12:30:55 Views: 291
• 

  Impdp and expdp monitor the progress of data backup and recovery (EXPDP/IMPDP/RMAN)

  Check the progress of EXPDP/IMPDP 1 two views when you export, if the amount of data is relatively large, some people will be anxious, can not help but want to see how the progress is, you can use two views to see: SQL > select * from dba_datapu

  2022-06-01 12:30:47 Views: 214
• 

  Linux performance analysis

  Check the performance order: [cpu] mpstat-P ALL 1 100 (sar-uMagazine sar-p) [network] sar-n DEV [disk] sar-b Magazine sar-d [mem] sar-W

  2022-06-01 12:30:38 Views: 265
• 

  The difference between Union and Union All in Oracle

  [example] first, create two tables An and B. in order to facilitate understanding, both tables create only one field column, namely a_col and b_col, add table A data 1, 4, 5, 9, and table B data 2, 3, 4, 5. Enter the following sentence: select * from

  2022-06-01 12:30:38 Views: 300
• 

  Redis Notes-Hash data Type (3)

  Hash is a mapping table for field and value of type string. Its add and delete operations are both 0 (1) (average). Hash is particularly suitable for storing objects. Instead of saving each field of an object as a single string type, store an object

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

  Redis Notes-List data Type (4)

  List type and operation List is a linked list structure, the main functions are push, pop, getting all values in a range, and so on. Key is understood as the name of the linked list in the operation. The list type of Redis is actually a String type of every child element.

  2022-06-01 12:30:37 Views: 216
• 

  PXC cluster modifies service access port

  1. A 3-node PXC cluster is used in the production environment. The external access port is 3306 by default. You usually need to modify the port. We assume that port 3311 is the external access port. 2. Modify the PXC cluster application access port 3306 to 3311 during the operation process, and operate on the first node first.

  2022-06-01 12:30:07 Views: 240
• 

  Installation of vsphere update manager and precautions

  To facilitate patching of its products, vmware has launched a update manager tool. To use this tool, you must have a SQL database server (or you can choose to use an embedded database when installing update manager), and install it.

  2022-06-01 12:30:07 Views: 298
• 

  DBA_TAB_MODIFICATIONS view learning

  Learn the role of DBA_TAB_MODIFICATIONS views by testing DBA_TAB_MODIFICATIONS describes modifications to all tables in the

  2022-06-01 12:29:51 Views: 263
• 

  Customized application of Oracle EBS12.2 registration

  1. Basic information of Oracle APP and DB. 1. Application and database environment: Application Node in Linux7.3Database Node on Linux 7.32, Oracle EBS application

  2022-06-01 12:29:51 Views: 263
• 

  Install and compile mysql database with source code under Linux

  MySQL is an open source relational database management system (RDBMS). The MySQL database system uses the most commonly used database management language-structured query language (SQL) for database management. Here are the specific steps for installing the mysql database source code: environment

  2022-06-01 12:29:51 Views: 268
• 

  MySQL stored the usage of if statements

  MySQL has stored the usage of if statements, and MySQL IF statements allow you to execute a set of SQL statements based on a condition or value result of an expression. 1Perfect if structure IF expression THEN

  2022-06-01 12:29:51 Views: 290
• 

  A preliminary understanding of 4--Xtrabackup backup and restore of MariaDB

  Basic knowledge mysqldump is a single-threaded logical backup tool that comes with mysql. When the amount of data is large, it takes a very long time to use mysqldump backup, and it is impossible to do incremental backup. Xtrabackup is an open source backup based on underlying block replication.

  2022-06-01 12:29:36 Views: 245
• 

  Summary of primary key of relational database

  When designing based on relational database, it is usually necessary to specify a primary key for each table. The so-called primary key is the attribute or attribute group that can uniquely identify a row of records in the table. A table can have only one primary key, but can have multiple candidate indexes. Because the primary key uniquely identifies a row of records, you can ensure that

  2022-06-01 12:29:36 Views: 231
• 

  About creating a database server and mysql guide database

  1. Copy database files: scp glloans_haierdb_20170726.sql.gz root@10.164.197.245:/root2, decompress database gunzip glloans_haierdb

  2022-06-01 12:29:36 Views: 277
• 

  Connect to a remote oracle instance using PLSQL Developer

  Client: WIN10 server: Oracle server 1 installed in Linux, download plsqldeveloper11.zip, instantclient_11_2.rar and extract to the corresponding directory D:\ instantcl

  2022-06-01 12:29:30 Views: 268
• 

  MySQL basic exercise-detailed explanation of all kinds of backup and index

  During the operation of the backup MySQL service instance, there is an unexpected power outage, hard disk damage, misoperation, server downtime and so on. At this time, how to ensure that the database can be restored to the 'correct' state as much as possible? For database managers, the easiest way to prevent data loss is

  2022-06-01 12:29:29 Views: 209
• 

  Use logrotate to perform daily rotational backups of MySQL specified log files

  According to your own needs, you can dump the relevant log files of MySQL (error log, general query log file and slow query log file) on a daily basis, and keep only backup files for a specified number of days. Here is an example: 1), install crond service (if yum is not installed)

  2022-06-01 12:29:29 Views: 280
• 

  Theoretical basis, installation and basic operation of NoSQL

  30 minutes on distributed system theory: CAP: consistent availability, partition fault tolerance MongoDB: install crud index replica set fragmentation NoSQL: non-relational, distributed, do not provide ACID functional technical features: 1, simple data model 2, metadata and application data separation (

  2022-06-01 12:29:18 Views: 205
• 

  Some thoughts on the consistency and usability of CAP Theory and MongoDB

  About five or six years ago, I first came into contact with NoSql, which was already hot topic at that time. But at that time, I learned to use mysql,Nosql, which is still new to me. I didn't really use it. I just didn't understand it, but I thought it was awesome. But what is impressive is such a picture (

  2022-06-01 12:29:01 Views: 233