NAV: SLTechnology News&Howtos > Database >

• 

  The custom function dblink is listed in select in sql

  The original way of extraction is that the b library oci packages the data and puts it on the local disk of the middleware, and then loads it into library a by sqlldr. Sql is as follows: select column_name1,function_name (column_name

  2022-06-01 05:07:32 Views: 260
• 

  Technical interpretation of POLARDB v2.0

  Recall that major improvements to POLARDB 1.0POLARDB 1.0 include the adoption of a computing storage separation architecture, full compatibility with MYSQL, and six times the performance of native MySQL. A user cluster can be flexibly expanded to 16 computing nodes at the minute level, which is fully transparent to the business.

  2022-06-01 05:07:32 Views: 277
• 

  The method of ASP connecting to MySQL Database (to be transferred)

  The method for ASP to connect to MySQL database (turn) [@ more@] <% 'Test to read the contents of MySql database strconnection= "driver= {mysql odbc 3.51 driver}; database

  2022-06-01 05:07:31 Views: 286
• 

  Redis Sentinel sentinel

  # Sentinel sentinel is configured with 3 redis (1 master and 2 slaves) and 1 sentinel. The steps are as follows: cp redis.conf redis1.confcp redis.conf redis2.confcp red

  2022-06-01 05:07:31 Views: 286
• 

  The solution of missing core/Common.php File in error display of main Page of Heavenly Rabbit Database Monitoring system

  Follow the steps to configure the Sky Rabbit database monitoring system and report an error when you open the web page: A PHP Error was encounteredSeverity: NoticeMessage: Only variable refe

  2022-06-01 05:07:31 Views: 216
• 

  My tomcat-mysql data source configuration

  Step: 1. Download apache-tomcat-5.5.17.zip and apache-tomcat-5.5.17-admin.zip, respectively, uninstall the server and management tools from 5.05.5 to the tomcat5.5 directory.

  2022-06-01 05:07:31 Views: 260
• 

  PostgreSQL DBA (3)-introduction to the log analysis tool pgbadger

  PgBadger report: Event Details IV, references pgbadger official website pgbadger on GitHub:pgbadger

  2022-06-01 05:07:28 Views: 262
• 

  Oracle configures multiple listeners for one instance

  To configure multiple listeners for an Oracle instance, you must first define multiple listeners. Because there are multiple listeners, there must be some listeners whose ports are not 1521. Now the following listeners are defined in the server's listener.ora file: [oracle@wang ad

  2022-06-01 05:07:27 Views: 288
• 

  Direct Path Reads

  Oracle Database SQL Tuning Guide---8 Optimizer Access PathsDirect Path ReadsIn a direct path read, t

  2022-06-01 05:07:26 Views: 256
• 

  Dataguard lost ORA-16016 in the library archive due to no archive deletion policy configured for the main database parameters.

  Dataguard Archive lost due to no archive deletion policy configured in the main database parameters. Today, during the inspection of the library, it was found that the standby database was not started, and the monitoring agent was also turned off. Start manually to open the standby database (read_only) in accordance with the log convention, but it is displayed during the open process.

  2022-06-01 05:07:26 Views: 245
• 

  (part 7) A flexible, easy-to-use and easy-to-maintain hadoop data warehouse tool-- Hive

  Hivehive is a data warehouse tool based on Hadoop, which can map structured data files to a database table and provide complete sql query functions. Hive defines a simple SQL-like query language, called HQL, which allows you to be familiar with SQL

  2022-06-01 05:07:22 Views: 297
• 

  Six steps to light up the data.

  "large area, cool dynamic effect, rich color", the big screen is easy to leave a deep impression on the impression, it is easy to create a certain atmosphere and create a sense of ritual. For example, large-scale e-commerce activities such as double 11, Tmall, Taobao, etc., take advantage of the characteristics of a large visual screen to create a strong festive atmosphere.

  2022-06-01 05:07:18 Views: 275
• 

  Db_file_name_convert order problem

  In duplicate, if there is not enough space for a remote directory, you can split the file into two directories. Using db_file_name_convert, db_file_name_convert does not convert the directory name, but the file name.

  2022-06-01 05:07:18 Views: 254
• 

  [in-depth tutorial] how to make the grouping panel? Make the visualization feel layered.

  ↓ ↓ first finds the "tabs" and "grouping panels" in the component library. Click the tabs in the component library-- select the tabs in the list of layers-- click the grouping panel to edit the grouping panel properties to change the selected and unselected font colors and selections.

  2022-06-01 05:07:10 Views: 240
• 

  Pgloader2.3.2 usage

  Mount the system image yum install pgloader-2.3.2-1.rhel6.x86_64.rpm configuration file conf.pgsql] host=192.168.245.132port=543

  2022-06-01 05:07:09 Views: 257
• 

  Using Python+Redis to realize distributed Lock

  Using Python+Redis to implement distributed locks welcome communication technology: one person can go fast, but a group of people can go further. Common relational databases (Oracle+MySQL+PG+GP) + highly available enterprise solutions + distributed lock usage scenarios:

  2022-06-01 05:07:09 Views: 275
• 

  Guide for beginners to use MYSQL-(reposted by MYSQL.CN)

  MYSQL beginner's Guide has many friends who have installed mysql but don't know how to use it. In this article, we will learn some common mysql commands from connecting to mysql, changing passwords, adding users, and so on. First, connect mysql. Format: my

  2022-06-01 05:07:09 Views: 285
• 

  Completely uninstall oracle11g

  Win7 64-bit operating system, after installing oracle11g, found it difficult to install visual management tools. So uninstall, after the method uninstall, you can reinstall 32-bit oracle11g. Feel free to use it. Steps to completely uninstall oracle11g: 1. Start-

  2022-06-01 05:07:09 Views: 276
• 

  Oracle backup and recovery (5)

  Backup: definition: the process of copying a database to a dump device. Dump device: a tape or disk on which a copy of the database is placed. Backup of the original database: a copy of the database stored in the dump device. Classification: physical and logical point of view: physical backup: physical files (data files, control files) to the database

  2022-06-01 05:07:08 Views: 281
• 

  Summary of several reasons why the listener of oracle cannot be started

  1) Firewall is not off. 2) there is a problem with etc/hosts configuration. The default record of 127.0.0.1 may be deleted by mistake, and the default record [root@rac02 ~] # cat / etc/hosts127.0.0.1 localhost is added.

  2022-06-01 05:07:08 Views: 238