Database Administrator

Oracle GoldenGate causes imp to have a ORA-32588 Error The customer said that the following error was reported when importing data to the source database after GG was implemented: From this error, we can see that adding logs of all column type to

MySQL Character Set knowledge Summary Character Set & character encoding Character set is a collection of multiple characters. There are many types of Character sets. Each Character set contains different numbers of characters. The characters here

Oracle RMAN backup and Restoration RMAN supports Incremental Backup: databases, tablespaces, and data files. Only used blocks can be backed up as backup set Ing between tablespaces and data files: dba_data_files/v $ datafile_header In noarchivelog

Oracle queries the first 10 records and paging queries (5th to 10th records), and oracle queries the first 10 records If you want to know the actual application solutions of the first 10 records in Oracle query, you can click the following article

ORA-28001: the password has expired solution, ora-28001expired Oracle prompt error message ORA-28001: the password has expired, due to new features of Oracle11G, the default password expiration limit for Oracle11G User Creation is 180 days (6

Oracle -- Windows cannot start OracleDBConsoleorcl on the local computer. Error Code 1, oracledbconsoleorcl   After the database is installed, it can be started. After the computer is restarted, an error will be reported when it is manually started.

MySQL5.6 backup and recovery command, mysql5.6 backup and recoveryBackup Mysqldump-P 3010-h 130.51.2.24-uroot-proot zplatdb> backup. SQL Restore Recover to my local machine, because I have not set a password for this machine, the password is

SQL string to Int type, SQL string int In general, SQL statements can be implicitly converted without strong conversion. It is really necessary to replace it with int type. Convert (int, @ str) Today we are talking about another situation,First

Mybatis level 1 and level 2 cache, and mybatis Level 2 CacheLevel 1 Cache First, perform a test to create a mapper configuration file and mapper interface. Here I use the simplest query for demonstration. SELECT * FROM user public

Redis persistence, redis Web programmer blog: http://blog.csdn.net/thinkercode Redis persistence Mechanism Redis is a memory database that supports persistence. That is to say, redis often needs to synchronize data in the memory to the disk to

ORA-01591: Lock pending Distributed Transaction Processing Solution, ora-01591 Transaction Processing On-site report has a function can not go on, background log error: java. SQL. SQLException: ORA-01591: Lock is pending Distributed Transaction

MySql Performance Tuning (4) Quick table structure modification and mysql Tuning 1. Modify the varchar type To meet your needs, change varchar (6) To varchar (8). A better method is not to use altertable modify, but to use the following

Restrictions on the length of an oracle table name, field name, and other objects Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be

The Excel file at the end of the SSIS export date, And the excel file at the end of the ssis Export When you use the ETL Tool to regularly export data documents in Excel format, it is sometimes required that the exported file name end with the date

Database Tuning tutorial (4) Explain performance analysis command, tuning explain In the previous chapter, we learned how to find slow queries and record statements into logs. How can we know where statement problems occur after slow queries are

Greenplum + Hadoop learning notes-11-distributed database storage and query processing, hadoop-11- 3. 1. Distributed Storage Greenplum is a distributed database system. Therefore, all its business data is physically stored in the database of all

Mysql timeout and mysqltimeoutMysql timeout ------ By bibimbap1. How much does the timeout variable know? Open mysql and useshow variables like '%timeout%'The command looks like I don't know, but I was shocked. The result is shown below. With so

Install mongodb in linux universal Binary Package, mongodblinuxMonfoDB is an open-source document database that provides common performance, high availability, and automatic scaling. The record in MongoDB is a document, which is a structure

By re-generating the execution plan, the execution plan deviation of Bound variables will be solved, resulting in the SQL Execution time being too long. The execution plan SQLSome SQL statements in the 11G environment of the Basic Elements (time,

How to completely uninstall the oracle 11g Client 1. Disable oracle service: Go to computer management. In the service, find all services starting with oracle, right-click and choose stop. 2. In the Start Menu, find the Universal Installer, run