NAV: SLTechnology News&Howtos > Database >

• 

  Oracle 12.2 uses manual creation and registration of dependent objects to perform online redefinition

  The following example uses the method of manually creating and registering dependent objects to perform online redefinition operations. The original table is created as follows: SQL > create table jy.t1 (C1 number); Table createdSQL > create

  2022-06-01 06:33:43 Views: 204
• 

  Construction of Oracle 11g RAC cluster

  Oracle 11g RAC cluster building (two nodes) 1. Environment preparation 1. Installation Planning 1.1 hardware requirements: two servers, CPU 8C, 16G memory, 500G local hard disk, two 1000Mbps network cards (one Public Nic, one

  2022-06-01 06:33:43 Views: 246
• 

  Gridea+GitHub sets up a personal blog

  Wow, this building process is too easy, it is much easier than Hexo blog building, and there is a background management client.

  2022-06-01 06:33:42 Views: 251
• 

  Replace the execution plan with sql baseline

  1. Click (here) to collapse or open SQL1:select / * www1*/ / * + full (LOGIN_LOG) * / IP_ADDRESS from LOGIN_LOG where ses by performing the following SQL, respectively

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

  Be careful to avoid the pit: the problem of data duplication in MySQL paging

  Full-text link: https://www.modb.pro/db/232010 problem description in MySQL we usually use limit to flip the page for query, such as limit (0mem10) to list 10 pieces of data on the first page, limit

  2022-06-01 06:33:42 Views: 232
• 

  How Oracle 11g RAC turns physical DG into a read-only library

  Execute SQL > select database_role from vested database on DG: DATABASEPHYSICAL STANDBY physical backup library. S

  2022-06-01 06:33:41 Views: 229
• 

  Introduction of Oracle 20C Multi-tenant _ 1.2 Database and examples

  1.2 Database and instance Oracle database server consists of a database and at least one database instance, usually referred to as an instance for short. Because an instance and a database are so closely linked, the term Oracle database sometimes refers to an instance at the same time

  2022-06-01 06:33:27 Views: 201
• 

  The latest ranking of domestic databases

  This month, Mo Tianlun released the latest real-time database rankings and added a voting function. In this ranking, there are not only foreign well-known databases such as Oracle, MySQL, SQL Server, but also domestic databases such as DM, GaussDB, TiDB, etc. Rank

  2022-06-01 06:33:23 Views: 281
• 

  GBase8s HAC cluster configuration method

  GBase8s intra-city disaster recovery high availability cluster configuration method Tips: there can be at most one intra-city disaster recovery node in a GBase8s inter-city disaster recovery high availability cluster. The replication technology between nodes is based on logical logs, so the database needs to turn on log mode. Cluster building

  2022-06-01 06:33:23 Views: 235
• 

  MySQL subquery

  SELECTSUBSTRING (REPLACE (do,'B',''),'.','0'),'_','1'),'-','1'), 1pjm32), B.idPerceB.d

  2022-06-01 06:33:23 Views: 248
• 

  MySQL Innodb tablespace unload and migration case

  Requirements: both server A (192.168.1.1) and server B (192.168.1.2) data directories are: / usr/local/mysql/data now wants to put server An on / usr/local/mysql/data

  2022-06-01 06:33:22 Views: 233
• 

  Check the existence of public synonyms Remove the public synonyms

  Encountered a Check the existence of public synonyms, Remove the public synonyms error while installing 12c Cloud Control, due to a previous installation

  2022-06-01 06:33:22 Views: 243
• 

  In-depth understanding of transaction isolation of oracle

  Http://www.bkjia.com/oracle/925189.html has an in-depth understanding of oracle transaction isolation in Oracle relational databases, let's first look at the following problem: a transaction: select from

  2022-06-01 06:33:22 Views: 255
• 

  Teal Orange Luts Pack vol 1 for Mac (orange tone lut preset)

  Teal Orange Luts Pack vol 1 is a LUT Pack for video and photo color grading. Our turquoise and orange LUT are carefully designed to create a stylish look for your visual effects, and are especially suitable for including blue and orange

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

  MySQL execution statement report Incorrect key file for table & # 039 *

  MySQL execution statement reported Incorrect key file for table'/ tmp/#sql_4c80_0.MYI'; try to repair it error reason: the temporary directory of the database tmpdir is full

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

  Installation and configuration of Oracle 11g database

  Oracle 11g configuration 1. Creating an instance is a part of the computer memory and auxiliary processing background processes needed to access the Oracle database, which is a collection of processes and the memory (SGA) used by these processes. A database can have multiple instances. Create step Or

  2022-06-01 06:32:58 Views: 228
• 

  Oracle starts archive mode

  When using RMAN to back up the whole database, it is required to be in archive mode. 1. If the database is in the startup state, you must first shut down: shutdown immediate;2, start the database to mount status: startup mount;3, open

  2022-06-01 06:32:57 Views: 286
• 

  & # 039 _ mysql.columnkeeper stats _ blank _ 039; doesn't exist and Table & # 039 _ mysql.indexkeeper stats _ blank _ blank 039; doesn'

  Modify the field type in the production library MariabDB, prompting the following error: Table 'mysql.column_stats' doesn't existTable' mysql.index_stats' doesn't

  2022-06-01 06:32:57 Views: 204
• 

  SQL Profile of type Manual

  Purpose: Manual type stable execution plan, more stable than AUTOMATIC type key words: dbms_stats.gather_table_stats, DBMS_SQLTUNE.DROP_SQL_PROFIL

  2022-06-01 06:32:55 Views: 254
• 

  View and set the MySQL database character set

  View and set MySQL database character set Liunx modify MySQL character set: 1. Find the location of MySQL's cnf file find /-iname'* .cnf'- print/usr/share/mysql/my-i

  2022-06-01 06:32:54 Views: 281