NAV: SLTechnology News&Howtos > Database >

• 

  MS-SQL CLR reads and writes files directly. It feels like flying.

  A CLR extension DLL is written, which reads and writes the file extension function directly in SQL. Read and write data variables directly to the file. The program is written in VS2010 and the language Vb.net. Includes four scalar functions: GetFile_Str16 (@ PathFile)

  2022-06-01 10:06:46 Views: 207
• 

  Overview of nodes in mongodb replication set

  Default: the primary node is responsible for data reading and writing, and the secondary node backs up the data on the primary node, but the arbiter node does not synchronize the data arbiter function from the primary node: when the primary node fails, it can

  2022-06-01 10:06:46 Views: 261
• 

  Oracle memory structure and process structure

  Memory structure in the Oracle database system, the memory structure is mainly divided into the system global area (SGA) and the program global area (PGA). SGA applies to the operating system to allocate a memory structure with the startup of the database instance, and with the closure and release of the database instance, each Oracle

  2022-06-01 10:06:46 Views: 252
• 

  Function-based index

  The following is an excerpt from Chapter 12.4.2 of Oracle SQL Advanced programming-function-based indexes [where the code is partially modified, please refer to the book] if a predicate applies a function to an index column, the optimizer does not select the index on that column. For example, for the predicate t

  2022-06-01 10:06:40 Views: 236
• 

  Resolve errors in oracle temporary tablespace

  Error message: [HY000] (1652) [Oracle] [ODBC] [Ora] ORA-01652: unable to extend temp segment through 128 (in tablespace TEMP) cause analysis: oracle temporary tablespace is insufficient

  2022-06-01 10:06:37 Views: 232
• 

  The writing of stored procedures

  The method of assigning query results to variables in Mysql stored procedures has been reporting errors today; the reason is that select results cannot be assigned directly to variables. Referenced https://www.cnblogs.com/vincentvoid/p/643

  2022-06-01 10:06:36 Views: 297
• 

  Oracle Subarea Exchange

  Starting from Oracle8, it provides the function of exchanging from partition, such as the exchange of one partition or sub-partition with a non-partition table, the exchange of hash sub-partition between a hash partition and another table, and so on. For more information, please refer to the official documentation. Basic syntax: ALTER TABLE

  2022-06-01 10:06:36 Views: 286
• 

  Install mysql database records on Mac

  Download mysql for mac: https://downloads.mysql.com/archives/community/ Note: I downloaded the community version, and the mysql version should be consistent with your MAC version. That's for sure

  2022-06-01 10:06:36 Views: 294
• 

  Oracle notes (VI), table management (constraints, indexes, locks, table partitions)

  Table integrity and constraint entity integrity: primary key bundle domain integrity reference integrity: foreign key constraints SELECT constraint_name, constraint_type FROM user_constriants WHERE

  2022-06-01 10:06:15 Views: 216
• 

  Redis data structure and memory Management Strategy (part I)

  Redis data structure and memory Management Strategy label: Redis Redis data structure Redis memory management strategy Redis data type Redis type mapping Redis data type characteristics and usage scenarios String, List,

  2022-06-01 10:06:15 Views: 220
• 

  ORA-02270: some ideas that the unique keywords or primary keys of this column list do not match

  Look at the structure of the two tables SQL > describe student;Name Type Nullable Default Comments

  2022-06-01 10:06:14 Views: 258
• 

  ORA-00130: invalid listener address

  1. Environment description suse 11 Enterprise Edition SP3, Oracle 11gR2 single instance 2. After the problem modifies the hostname, the database cannot be started. 3. Problem handling 1. Phenomenon mmpt-site:~ # su-oracleoracle@m

  2022-06-01 10:06:14 Views: 225
• 

  PostgreSQL compilation and installation

  PostgreSQL compilation and installation 1. Introduction to PostgreSQL PostgreSQL is currently the most powerful open source database, supporting rich data types and custom types, and it provides rich interfaces that can easily expand its functions. Compared with other databases

  2022-06-01 10:06:08 Views: 278
• 

  Recommended patches and actions for Oracle database version 12.1.0.1d11.2.0.3 and earlier

  Recommended patches and operations for Oracle database version 12.1.0.1 Magi 11.2.0.3 and earlier-by June 2019 (document ID 2335265.1) purpose scope details in this file 1. What is the recommended patch set / P

  2022-06-01 10:06:05 Views: 252
• 

  Expdb operating method

  Expdp system/oracle directory=DB_BAK dumpfile=zhzy.dmp schemas=zhzyexpdp system/SYSTEM directory=DB_

  2022-06-01 10:06:05 Views: 300
• 

  Oracle Import and Export Command

  The use of EXP and IMP exp username / password @ database connection address file= export file path imp user name / password @ database connection address file= import file path ignore=y for example: imp scott/abcd@127

  2022-06-01 10:06:05 Views: 203
• 

  Analysis and solution of logical errors in ORA600 [13011] Table and Index data

  1. Overview of problems 1. Database environment: Oracle Database 11.2.0.3.0 for Oracle Linux Server release 6.4, virtual machine 2, found a database alert during inspection

  2022-06-01 10:06:05 Views: 244
• 

  Redhat5.5 installation oracle 11g

  First upload the oracle installation file to linux server 1. Decompress zipunzip linux.x64_11gR2_database_1of2.zipunzip linux.x64_11gR2_database_

  2022-06-01 10:06:04 Views: 278
• 

  Recovery after Oracle online redo log file is lost

  Today, a development library can not start, send an error to see that the log file is corrupted (see figure below), and then talk about the causes and consequences. It is said that the server was powered off a year ago, and then it never started again. It was only when someone used it today that they thought of dealing with it. Let's talk about the general idea first, if the damaged redo

  2022-06-01 10:06:01 Views: 268
• 

  Oracle startup error message-caused by hostname

  # Log in directly to root users at the beginning. In the etc directory, change to oracle, and enter lsnrctl start to prompt "lsnrctl: command not found" [root@loveyao_] when starting oracle

  2022-06-01 10:06:01 Views: 254