NAV: SLTechnology News&Howtos > Database >

• 

  How to migrate Dameng database instance from Windows to Linux system

  The phenomenon describes how to migrate Dameng database instances from Windows to Linux system. Sometimes we have this real need, especially when the amount of data is large, by creating a new database on linux, and then through the migration tool, or by logical backup (d

  2022-06-01 07:42:10 Views: 299
• 

  ORACLE sql merge into update where conditional location and performance consumption

  Environment: operating system version: linux redhat 6.6Database version: oracle 11.2.0.4 problem description: today, implementation colleagues reported a very strange problem, that is, the sql merge usage of oracle database, upd

  2022-06-01 07:42:04 Views: 283
• 

  IA Writer for Mac (Writing Software) v5.5.3 Chinese version

  Which is better for text writing software? IA Writer is an excellent Markdown text writing tool on Mac. IA Writer is simple and easy to use, supports Markdown syntax, supports conversion between DOCX format and Markdown documents, and has a design

  2022-06-01 07:41:57 Views: 208
• 

  Oracle vs PostgreSQL Develop (16)-Prepared Statement

  For the same SQL statements except binding variables, PostgreSQL provides Prepared Statement for caching Plan to achieve the purpose of cursor_sharing=force in Oracle. PSQL through p

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

  Co-PLAN- Collaborative Planning Portal erection platform

  Co-PLAN (Collaborative Planning platform), under the guidance of advanced project management and target performance management, is oriented to manufacturing enterprises, closely integrates project management, monthly target management and performance appraisal management, standardizes project management process, and assists in project establishment, planning, execution, monitoring and conclusion.

  2022-06-01 07:41:30 Views: 234
• 

  Capacity expansion of ASM disk Group in Oracle RAC Environment

  The following parameters should be adjusted in the production environment for expanding the capacity of ASM disk groups in Oracle RAC environment: +

  2022-06-01 07:41:27 Views: 295
• 

  File Cabinet Pro for Mac (file management software) 7.9.5 Activation-free version

  File Cabinet Pro for Mac is a very easy-to-use file management software applied on Mac, which can quickly navigate, support menu bar opening, moving, renaming, compression, marking, trash can, copying and pasting files, rotating images, cropping images, etc.

  2022-06-01 07:41:27 Views: 285
• 

  Mongo creates user-built hash partition for indexing

  1. Set Databasesh.enableSharding ("database_name"); 2. Create a Collectionuse database_namedb.createCollection (

  2022-06-01 07:41:26 Views: 237
• 

  Summary of Sqlserver's use of TDE transparent data encryption

  Official document https://docs.microsoft.com/zh-cn/sql/t-sql/statements/create-certificate-transact-sql?view=sql-s

  2022-06-01 07:41:26 Views: 204
• 

  Multiple mysql databases are installed on the same server

  [preface] multiple mysql databases are often needed to simulate various environments and scenarios in the test environment. Because the resources in the test environment are generally limited, it is necessary to build multiple mysql databases on one server to complete the testing requirements. This document is described in Cent

  2022-06-01 07:41:26 Views: 290
• 

  PostgreSQL DBA (44)-Privileges & User Management-What You Should Know

  This article briefly introduces the permissions of PostgreSQL and the basic knowledge of user management. For more information, please see PostgreSQL Privileges & User Management-What You Should Know.

  2022-06-01 07:41:25 Views: 285
• 

  The function and use of OPTIMIZE TABLE in MySQL

  Take a look at the description of OPTIMIZE in the manual: OPTIMIZE [LOCAL | NO_WRITE_TO_BINLOG] TABLE tbl_name [, tbl_name]. If you have deleted

  2022-06-01 07:41:25 Views: 213
• 

  Oracle instance name query, instance status query, etc.

  1. View instance name, table, etc. [oracle@shoubashou.com ~] $sqlplus scott/tiger@orclSQL > show user;USER is "SCOTT" SQL > sele

  2022-06-01 07:41:22 Views: 234
• 

  Practical Guide to Anti-deletion Library | just one step to quickly recall tables that have been mistakenly deleted

  Author Huang Zhong, Aliyun database technology expert database has some very good enterprise functions, such as the Recycle Bin (Recycle Bin) function in Oracle 10g, which can play the function of special forces under special circumstances, such as when you delete it.

  2022-06-01 07:41:22 Views: 255
• 

  Redo log is corrupted

  First, the redo log damage 1.1 archive mode that is not in use, is not currently in the log corruption, database open mode. Simulated damage: SQL > archive log list;Database log mode Archive

  2022-06-01 07:41:21 Views: 208
• 

  Oracle's temp table space is full

  Two days ago, the operation and maintenance staff suddenly sent me a novel report of ORA-06512 error. The error is as follows, indicating that temp cannot be expanded: ERR_1000001: unknown system error (ORA-01652: unable to extend temp seg)

  2022-06-01 07:41:21 Views: 214
• 

  Oracle character function

  1. Intercept the select substr ('abcdef',1,3) from dual2, find the substring position select instr (' abcfdgfdhd','fd') from dual3, and concatenate the string

  2022-06-01 07:41:21 Views: 279
• 

  Large amount of data in ORACLE Database the influence of TRUNCATE and DELETE operations on tablespaces

  -- 1. Create a test table create table cux.cux_test_data asselect * from GL_JE_HEADERS;--2, and view the number of data items select count (1) from

  2022-06-01 07:41:17 Views: 206
• 

  Memory structure of Oracle architecture (SGA, PGA)

  Memory structure of Oracle architecture (SGA, PGA) 1. Memory structure SGA (System Global Area): shared by all service processes and background processes; PGA (Program Global Area): by each

  2022-06-01 07:41:00 Views: 246
• 

  ACID mode of MySQL

  InnoDB engine follows the principle of ACID. ACID mainly refers to:? A: atomicity. Atomicity? C: consistency consistency? I: isolation. Isolation? D: durability.

  2022-06-01 07:40:56 Views: 288