NAV: SLTechnology News&Howtos > Database >

• 

  Oracle11g backup Import oracle10g

  Oracle11g backup Import oracle10g backup expdp scott/tiger dumpfile=scott.dmp schemas=scott version=10. (ora in oracle11g

  2022-06-01 11:08:16 Views: 219
• 

  Upgrade from 11.2.0.3 to 11.2.0.4 error ORA-01157 ORA-01110

  Last night, the production library had to be upgraded from 11.2.0.3 to 11.2.0.4, but the database could not be startup upgrade because of the ORA-01157 ORA-01110 error. Environment: HP-UX B.11.31 / 11

  2022-06-01 11:08:15 Views: 235
• 

  Oracle 11g rman backup related

  1. Verify that the backup can be successfully restored, and full restore determines which backup sets and archive logs need to be applied. RMAN > restore database preview;Starting restore at 07-OCT-15usin

  2022-06-01 11:08:15 Views: 221
• 

  MySQL Stored Programs Summary

  Part 1. Classification Stored Programs- Stored Routines- Procedure- Function- Event Scheduler- TriggerPart 2. A summary of another

  2022-06-01 11:08:00 Views: 206
• 

  Concurrency example of Go language-Pool (2)

  For this resource pool management has been implemented step by step, and have done a detailed explanation, the following look at the entire sample code, easy to understand. Package commonimport ("errors"io"sync"

  2022-06-01 11:07:59 Views: 285
• 

  How to do SQL Server performance testing?

  As far as DBA is concerned, we all do performance tests on the new server. I will start with the benchmark test of TPC and use HammerDB to evaluate the overall performance (formerly HammerOra) and compare it with vendor data. Then use DiskSpd to specifically test disk IO performance.

  2022-06-01 11:07:59 Views: 291
• 

  Oracle password expires

  The determination is due to the default setting of "PASSWORD_LIFE_TIME= 180 days" in the default profile in oracle11g. Check which user's proifle is, usually default:sql > SELECT

  2022-06-01 11:07:56 Views: 231
• 

  Let pt-slave-restart support MariaDB

  The latest version of pt-slave-restart is 2.2.19, and you will get an error when you execute the following command to skip primary key conflicts. # pt-slave-restart-user=root-error-numbers=106

  2022-06-01 11:07:56 Views: 214
• 

  Build your own search and analysis engine with ElasticSearch

  Introduction: the retrieval function of Internet products can be seen everywhere. When the scale of your project is Baidu Dasou | ShangSou or Wechat official account search, it is very natural to develop a search engine and add a variety of customized requirements and optimization. But if it is only ordinary small and medium-sized projects or even creation

  2022-06-01 11:07:29 Views: 268
• 

  Zabbix monitors mongodb configuration

  This article mainly introduces the configuration of zabbix monitoring mongodb. Zabbix monitoring mongodb needs to be monitored by a custom script, which can pass in multiple parameters. Principle: filter out db.serverStatus through mongodb client connection command

  2022-06-01 11:07:08 Views: 200
• 

  The only conflict of sequence after logical migration of data pump

  The preface summarizes an old topic. When using the data pump to perform logical import, we often encounter the problem of unique conflict in sequence. This paper summarizes the reason why impdp imports sequence first in order (assuming that currval is 10 at this time).

  2022-06-01 11:07:08 Views: 231
• 

  MySQL5.7.18 for Linux7.2 source code installation

  It is troublesome to install MySQL in source code. You need to install the dependency package and then compile it for a long time. It is recommended to install binary MySQL for faster time. Package used: mysql-5.7.18.tar.gzboost_1_59_0.tar.gz1

  2022-06-01 11:07:08 Views: 268
• 

  Unable to load database driver in thinkphp

  Config.php configuration file / / database configuration information of Common\ Conf at the same level as Home 'DB_TYPE' = >' mysql', / / database type 'DB_HOST' = >' localhost'

  2022-06-01 11:07:07 Views: 217
• 

  Table & # 39 is marked as crashed and should be repaired solution

  Solution: find the bin/myisamchk tool in the mysql installation directory, type: myisamchk-c-r.. / data/mysql/user.MYI on the command line, and the myisamchk tool will help you recover

  2022-06-01 11:07:01 Views: 257
• 

  TRUNCATE TABLE understanding of SQL Server data recovery preparation

  When truncate table occurs, it is believed that most people will choose to restore the backup to truncate table, and then import the data back into the official table. So is it really the only way in SQL Server?

  2022-06-01 11:07:01 Views: 282
• 

  Case study 1 of MongoDB mapReduce

  Example 1: find out all the keys in the set and the number of times each key corresponds MongoDB has no pattern, so you don't know how many keys there are in each document. Usually the best way to find all the keys in a collection is to make use of MapReduce. All right, let's look at the examples. 1. First, through mo

  2022-06-01 11:06:47 Views: 296
• 

  There is no libmysql.dll in the above version of PHP5.3, and the trouble caused by it.

  When a friend downloaded the PHP5.3,PHP5.4 version and wanted to load mysql support, he found that he could not complete the mysql configuration without a libmysql.dll file. In fact, starting with the PHP5.3 version, he used the mysqlnd library instead of libmysq.

  2022-06-01 11:06:47 Views: 294
• 

  Damage treatment of 11gR2 dataguard Reserve Library File

  Environment simulation: main library: SQL > select DATABASE_ROLE,open_mode from vested database role OPEN_MODE-

  2022-06-01 11:06:46 Views: 223
• 

  Basic usage of SQL Server transaction processing

  @ @ ERROR tests every statement error in SQLServer. The correct time @ @ ERROR = = 0 otherwise an error code is returned. (1) the @ @ ERROR function = = 0 has no error, otherwise an error code is returned. (2) BEG

  2022-06-01 11:06:46 Views: 298
• 

  Process of logical backup mysqldump and physical backup xtrabackup

  The basic process of mysqldump backup principle backup is as follows: FLUSH TABLES function: close all open entries on the instance: prepare for the second step, in order to avoid FLUSH TABLES WITH READ L caused by long transaction operations

  2022-06-01 11:06:43 Views: 238