Database Administrator

Oracle Database transfer from server A to server B Sometimes we encounter such a situation where the existing database needs to be transferred from one machine to another. Generally, we use export and import. However, if the database contains a

Relationship between the server parameter file (spfile) in the Oracle 11g parameter file and instance startup When the database starts, it needs to read the parameter file to allocate the memory area and locate the location of the control file. The

Summary of Oracle rebuild table (rename) Considerations I. OverviewSome time ago, a DBA friend failed to run the business on the morning of the next day after he finished the rename operation and encountered the restriction and error that the data

Oracle Upgrade ORA-04063 DBMS_REGISTRY has error When upgrading the Oracle database from 11.2.0.1.0 to 11.2.0.2.8, the software upgrade is normal, the instance upgrade is normal, and the psu is upgraded.Run @? /Rdbms/admin/catbundle psu when

In-depth analysis of MySQL ERROR 1045 (28000) After a user is created in MySQL over the past few days, the access request is denied. The ERROR code is ERROR 1045 (28000 ). I searched the internet for a long time and found many solutions, but

[MySQL Case] mysql local logon-S is invalid, mysql-s 1.1.1. The-S parameter is invalid when mysql is logged on to the local machine. [Environment description] Mysql5.5.14 [Problem description] Multi-instance Configuration   Instance 1

Use of % TYPE and % ROWTYPE in ORACLE, % type % rowtype 1% TYPE description To make the data TYPE of a variable consistent with that of another defined variable (especially a column in a table), Oracle provides the % TYPE definition method. When

DDL (Data Definition definitions ages) and ddldefinition I haven't written any SQL statement for a long time. Let's review it. DDL defines different data segments, databases, tables, columns, indexes, and other database objects. Common DDL

Mutex (test), mutexHow to Use Mutex for cursor sharing Kks uses mutex to protect a series of operations based on parent cursor parent and child cursor For the parent cursor operation of the parent cursor: Different wait events are generated based

Cocould not find gem 'sqlite3 (> = 0) 'in any of the gem sources listed in you r Gemfile, sqlite3gemfileSolution: sudo gem install sqlite3-rubyERROR: cocould not find a valid gem 'rdiscount' (> = 0) in any repository This problem happened to me for

Set the maximum number of mysql connections in CentOS to 1040 too persistent connection and centosmysql.When the maximum number of connections is small, the error "1040 too connection" may occur.You can modify the configuration file to modify the

[Translated from mos] DBA_JOBS and DBA_JOBS_RUNNING explain different results, dbajobsrunningDifferent results of DBA_JOBS and DBA_JOBS_RUNNINGReference Original:Different Results from DBA_JOBS and DBA_JOBS_RUNNING (Doc ID 109725.1)Purpose:Explain

MySQL Regular Expression search, mysql Regular Expression The products table is as follows: 1. Basic Character matching The difference between regular expression and LIKE is that regular expression searches for the entire column, As long as prod_

Mysql fastest paging method, mysql Paging As we all know, mysql paging is written like this: select * from 'yourtable' limit start,rows A table in my database contains million pieces of data. The table name is tweet_data. select count(*) from

Java. SQL. SQLException: Column count doesn't match value count at row 1 1. Error description Java. SQL. SQLException: Column count doesn't match value count at row 1 2. Error cause When inserting data, the number of inserted fields is

1. The first type of repetition is easy to solve. The methods in different database environments are similar:Reference content is as follows:MysqlCreate table tmp select distinct * from tableName;Drop table tableName;Create table tableName select *

In the previous two blogs, we analyzed the functions and databases of the system. Today, we started to practice and further analyze the system. Our program design consists of two steps: interface design and code design. Today, let's take a look at

Paste Code directly /***** @ Param zkIp * @ param zkPort * @ param tablename * @ param startRow transfers null to scan the entire table * @ param stopRow ~ End with * @ throws Exception */public static void scanTable (String zkIp, String zkPort,

The problem was reported on the site recently. All electronic seal pages cannot be opened (in pdf format), and no errors were reported in background logs. The effect was blank: 1. First of all, I thought of the ocx control issue of the seal. I

Common Character sets include ASCII, GB2312, GBK, UTF-8, Unicode First, you must know ASCII code: One byte is used to identify 0-9 numbers, uppercase and lowercase letters, and some punctuation and invisible characters. 1 byte, 8 bits, can have 256