NAV: SLTechnology News&Howtos > Database >

• 

  ORA-12170: TNS:Connect timeout occurred ORA-06512: at & quot;SYS.DBMS_SNAPSHOT"

  Oracle job cannot automatically run the following large number of errors Errors in file / oracle/admin/orcl/bdump/orcl_j000_2158798.trc:ORA-12012: er

  2022-06-01 18:18:32 Views: 287
• 

  Centos7 lamp (moudle)

  CentOS 7, lamp (module) requirements: (1) the three are separated from two hosts; (2) one virtual host is used to provide phpMyAdmin; and the other virtual host is used to provide wordpress; (3) xcache (4)

  2022-06-01 18:18:31 Views: 202
• 

  MongoDB Note 6-Delete Operation

  1. Delete all the data in the list db.person.remove () the index still exists after deletion, only the data is deleted, delete according to conditions 3, tip if you want to clear a very large data set, delete the set directly and re-index the method than

  2022-06-01 18:18:30 Views: 232
• 

  Oracle! You have to know, Knowledge points.

  What is a subquery when the constraints in a query need to be provided by another query, we can nest the two query statements and provide the conditional query as a subquery. A subquery, also known as an internal query, is executed before the main query, and the results of the subquery are used for the main query. The sub-query is divided into single-line subsets.

  2022-06-01 18:18:23 Views: 299
• 

  PGSQL connection error / var/run/postgresql/.s.PGSQL.5432

  Error message: psql: could not connect to server: Connection refusedIs the server running locally and acceptin

  2022-06-01 18:18:22 Views: 250
• 

  The difference between select statements selecting common columns in join and on statements

  When join multiple tables, in the select statement, if you use the using statement, the column selected in the using statement cannot specify a qualifier in the select statement, otherwise it will be reported to ORA-25154 to view the emp table SQL > select *

  2022-06-01 18:18:22 Views: 222
• 

  CDB or PDB Open Archive

  As long as 11g opens the archive, multi-tenants just open the archive. APPLIES TO:Oracle Database-Enterprise Edition-Version 12.1.0.1 and later

  2022-06-01 18:18:13 Views: 260
• 

  MySQL master-slave replication operation

  Upfront preparation: two servers with Mysql installed, or two Mysql instances deployed on one server. To avoid unnecessary errors, it is best to keep the Mysql version consistent. +

  2022-06-01 18:18:13 Views: 234
• 

  Redis database-python interaction

  -installation-- installation package ① enters the virtual environment py2_db, networking installation package redispip install redis ② Chinese official website (http://redis.cn/clients.html) download redis source code installation unzi

  2022-06-01 18:18:13 Views: 200
• 

  Job in oracle

  Oracle knowledge points-job in joboracle is similar to crontab in Linux and is used to perform certain operations on a regular basis. View: dba_jobs,user_jobs,all_jobs,dba_jobs_run

  2022-06-01 18:18:13 Views: 217
• 

  Content interpretation and replacement method of Database config.php File

  Many of the programs we download on the Internet do not have installed programs, but require us to manually modify the database configuration files. Some of them also need website paths such as domain names. The following is explained by charm Network

  2022-06-01 18:18:12 Views: 274
• 

  Oracle Notes (IX), triggers

  1. Triggers will take effect as soon as they are created, and sometimes you may need to disable them temporarily. The most common reason is that data loading is involved. ALTER TRIGGER trigger_name [ENABLE | DISABLE]; 2. Oracle

  2022-06-01 18:18:12 Views: 244
• 

  Sharing mysql Database with nfs

  Install mysql/mariadb and nfs on both machines, close selinux, and cancel the firewall nfs server export / mydata/ directory; centos7192.158.1.14nfs client mount / m

  2022-06-01 18:18:12 Views: 265
• 

  ORACLE DATAGUARD monitoring script

  Use perl to monitor the ORACLE DATAGUARD script #! / usr/bin/perluse strict;use warnings;use DBI; # Load the DBI modulem

  2022-06-01 18:18:12 Views: 302
• 

  Select in sort mysql select in (array) order by array

  1. Substring_index (inaccurate): SELECT * FROM `tvmars_ Channel` WHERE `name` IN ('Zhang Yimou', '1080p movie', 'Hollywood','Xi Xi'

  2022-06-01 18:18:11 Views: 243
• 

  Unable to export the solution to the empty table

  ORACLE 11G is being used recently. A problem was found when exporting and importing data: oracle does not export empty tables with no data. According to the data, it is found that this situation only occurs in Oracle 11g, and the treatment method is as follows: sqlcommand

  2022-06-01 18:18:08 Views: 263
• 

  Redis5.x Cluster deployment practice

  Experimental environment hostname IP address Redis port division remarks node171172.20.20.17116001,16002node172172.20.20.17216001,16002node173172.20.20

  2022-06-01 18:18:08 Views: 270
• 

  Oracle tree structure

  The hierarchical relationship of the tree structure is the father-son relationship, which is similar to the departmental organizational structure tree in a company, in which the general manager is the largest parent node, and below there are assistant, marketing, administrative office, R & D and other child nodes, while the R & D department is subdivided into R & D 1 and R & D 2; for example, empl in hr user table employees

  2022-06-01 18:18:08 Views: 201
• 

  Theoretical basis of Mysql database II

  Introduction to the theoretical basis of Mysql database developed by MySQL AB, it is the most popular open source SQL database management system. Its main features are as follows: 1. It is a database management system. 2. It is an associated database management system. 3. It is an open source software with a large number of available.

  2022-06-01 18:18:07 Views: 274
• 

  Oracle generates users and permissions to copy

  Generate a script to create a user, set pagesize 0set escape onselect 'create user' U.username 'identified' DECODE (password,NUL

  2022-06-01 18:18:07 Views: 270