Database Administrator

ORA-00942 tables or views encountered during storage do not exist Solution: Grant select, insert, update, delete on bookmarks. * to bm_user @ localhost identified by 'Password' Authorization statement: Grants the XXX select, insert, update, and

MySQL 5.5.x notes for source code compilation and Installation 1. Install cmakeMySQL 5.5 and later versions have been replaced by the cmake tool./configure compilation and configuration method.Therefore, we must first compile and install the cmake

Use shell scripts to view SQL statements with high resource consumption in Undo When undo usage is checked, when Undo_management is set to auto, it is often seen that undo is constantly scaling and adjusting itself. Sometimes we can see that Undo is

Simple MySQL database operations For children who want to engage in or love mysql-related work, it is necessary to implement some simple operations on mysql under the command line. This article describes how to log on to the mysql database server,

Use navicat to export the data table structure and insert statement, navicatinsert After using navicat for a while, it was found that navicat is indeed very convenient and supports multiple databases. I used to think that his SQL files are

Take kettle's Excel Writer as an example. kettlewriter Step for learning kettle in ExcelWriter   In the ExcelWriter step, you can enter content in an excel template file and write content to different sheets of the same file. This article provides

Beyond Compare 2 Comparison. mdb (ACCESS) database setting method, compare. mdb When Beyond Compare 2 is installed by default, the. mdb (ACCESS) database cannot be compared. You need to modify the settings before you can intuitively Compare the. mdb

WARNING OGG-00952 Purging log history from OGG. GGS_DDL_HIST, ogg-00952purging The following warning is often found during OGG log inspection:16:52:56 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr. prm: Purging log history from OGG.

Question 7: How to Determine the DBID and rmandbid of the database when RMAN is used Objective: To determine the DBID of a database when RMAN is used You can use the following methods to determine the DBID of the database: 1. If the database is

[Database Study Notes] (2) JDBC load and register the database driver and connect to the database, learning notes jdbc There are several methods for jdbc to load database drivers: Type 4: Local protocol driver Type 1: jdbc-odbc bridge

Oracle alter index disable/unusable, alterunusable Alter index index_name disable, enable for function indexes. SQL> create table test as select * from all_objects;SQL> create index ind_t_object_id on test (object_id) nologging; SQL> exec dbms_stats.

The run selected revisions of dbv does not respond. dbvrevisions When an SQL statement under revisions has an exception, such as deleting a column that does not exist, the foreground does not respond. In fact, there is a response, but the returned

Oracle SQL not in Multi-field comparison example, oraclesqlSelect * from (select t2.cadastralno parcelid, t1.pkid taxpayerid, t2.taxtype taxtype, t1.booktype taxpayertype,T2.cadastralno parcelCadastralno, t2.landuser parcelLanduser, t1.payername

New methods for configuring synchronous replication in mysql5.6 and solutions to common problems, new methods for mysql5.6 Mysql5.6 adds a method that does not need to set the log_bin file and log location. Before that, we need to view the master

WARNING: Heavy swapping observed on system in last 5 mins., swappingmins When I checked the alert Log today, I found the following error: Pct of memory swapped in [7.16%] pct of memory swapped out [0.56%].Please make sure there is no memory pressure

SQL checks whether Stored Procedures contain keywords. SQL stored procedures Select. name from sys. ALL_OBJECTS A, SYS. SQL _MODULES B WHERE. IS_MS_SHIPPED = 0 and. OBJECT_ID = B. OBJECT_ID and. [TYPE] IN ('P', 'V', 'af') AND [DEFINITION] LIKE '%' -

Software Engineering-design, software engineering design A large project must be designed first, but must be designed first. Before design, the requirement analysis is required. Requirement analysis is to understand what users "do". Requirement

Access from the SQL server is not allowed. access from the SQL Server I remember that I added sqlservr.exe to the internal access table of the firewall, and telnet can also be connected, However, SSMS cannot be connected, and the instance name is

MySQL lock Blocking analysis, mysql lock Blocking During routine maintenance, threads are often blocked, resulting in slow database response. Let's take a look at how to obtain which thread causes blocking. Blog: http://blog.csdn.net/hw_libo/article/

MHA + non-root user SSH equivalent configuration, mha non-rootssh Environment: CentOS5.8 MySQL5.5.17 Experiment: Set up the MHA high-availability architecture (non-root user SSH equivalent configuration) SSH equivalent user configuration: concert