Database Administrator

ORA-08102 troubleshooting Two ORA-08102 errors today When deleting table data When the following statement is executed: Delete from tb_ware w where w. issue like '% 100 '; The following error occurs; ORA-08102: index key not found, obj #57848, file 6

SQL data types in Oracle Data types are the basis of data storage for each programming language. They are also a benchmark for the implementation of programming languages. Some programming languages may have a wide range of data types, such as java,

Analysis of ORA-04030 in alert logs Yesterday I went to a customer to do inspection, encountered a classic ora-04030 error, alert Log is as follows: Tue Oct 28 09:57:46 2014Errors in

New Features of Oracle 11g virtual column partitioning There is a need: a document table should be partitioned by month. If it is on Oracle 10 Gb, only one field can be added. It will be different after the Oracle 11g. You can use virtual column

Oracle Index instance description-Basics An Oracle Index is an object in a relational database used to store each record location in a table. It aims to speed up Data Reading and integrity checks. Indexing is a highly technical task. Generally, we

How to install mysql using yum in linuxMy blog previous (http://blog.csdn.net/tjcyjd/article/details/41646889) has talked about the yum source configuration, with yum then install mysql will be very simple, specific as follows:1. Install the client

MySQL SQL Mode and MySQLSQLModeThe MySQL server can work in different SQL modes and apply these modes to different clients in different ways. In this way, applications can customize server operations to meet their own needs. This mode defines the

Database Connection Failed Communications link failure due to underlying exception !, Underlying (1) I encountered this problem today: When I use the DB Browser in Myeclipse to connect to mysql, communication link failure due to underlying

Conversion between SQL statements and SQL statements ----- Binary Conversion decimal --------------- select sum (data1) from (select substring ('20170101', number, 1) * power (2, len ('20170101')-number) data1 from (select number from master. dbo.

SQL generates 1000 million data and SQL generates million data Declare @ d datetimeset @ d = getdate () select * from dbo. chunkSegmentMappingselect [statement execution time (MS)] = datediff (MS, @ d, getdate () USE tempdbGOCREATE TABLE tb (id

Implicit parameter for automatic HASH processing when oracle reads data: _ gby_hash_aggregation_enabled,1. History of this parameter: _ gby_hash_aggregation_enabled Oracle 11.1.0: Parameter Name: _ Gby_hash_aggregation_enabled

"Mysql service cannot be started, system error 1067" solution, mysql1067 Port the local Apache + MySQL + PHP environment to another user's computer. data in mysql is not copied, as a result, when another computer runs mysql, the error "mysql

Oracle Character Set modification (ORA-29275), oracleora-29275 Today, a friend of the database ORA-29275 part of the multi-byte characters, the corresponding field can only use to_char to query the normal, it is a character set problem. You have

SQL _wm_concat function experiment: implement field merging, SQL _wm_concat Field Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be

Be careful when using with in Oracle -- predicate cannot be promoted, oracle Predicate Today, we can see that a SQL statement uses with in large quantities. For logic clarity, developers cache some result sets first with, and there are many places

MYSQL installation error "conflicts with file from package mysql-libs-*" solution, mysqllibs When installing MYSQL: Error: [root@localhost opt]# rpm -ivh MySQL-server-5.5.32-1.el6.x86_64.rpm Preparing... #############################

Oracle not exists equivalent statement, oracleexists Not exists can be changed to left join + is null. It can be seen that the execution plan is the same before and after rewriting, and the resource consumption is the same, which means it is

PHP installation of Redis extension tutorial, phpredis tutorialInstall redisDownload package phpredis https://github.com/nicolasff/phpredisuzip master # decompress get phpredis-mastercd phpredis-master # enter the installation

Latency index and paging Optimization for Mysql optimization; latency index Paging for mysql What is delayed indexing? Use the index to query the data, and then connect the query results to the data in the same table to improve the query

Relational database integrity 1. Relationship: D1 × D2 ×... * The subset of Dn is called in the domain D1, D2 ,... The relationship on the Dn, expressed as R (D1, D2 ,... Dn), R indicates the name of the link, and n indicates the link ContentsOr