Database Administrator

How to Use RMAN to restore some tablespaces During the routine maintenance and use of the Oracle database, data may be accidentally deleted (drop, delete, truncate). When we use conventional means (flashback query, flashback drop, we can use the

How to Diagnose Oracle Data Pump-How to add diagnostic information to a Data Pump There are still many bugs in the 11g Data Pump (expdp/impdp), and we often encounter inexplicable card death, which makes people feel overwhelmed. I recently read an

Problems encountered during Sybase Restoration: 20141219, sybase20141219 1. Create a backup server: Click Start ----> sybase ------> sybase config -------> Create BackupServer 1.1 click "create BackupServer", name the backup server, click "network

Oracle Integer type/DBNull processing method, oracledbnull 1. I used to think that integer = number (10,126) -- 38 is the maximum precision of number integer is a super large data type, the maximum value can be expressed as power) -1 because one

Oracle nologging research, oraclenologging Anyone familiar with oracle knows that by setting oracle's nologging option, some operations can be completed quickly, and the risk is that database backup may fail. There are many nologging operations that

GPDB current transaction is aborted, gpdbaborted When you use Python to operate GPDB, the following error is reported: gpmg.manager_tabl1eerror 'ERROR: relation "gpmg.manager_tabl1e" does not exist' in 'select

SQL statement concise tutorial for linux --- ALTER TABLE, concise tutorial --- alter After a table is created in a database, we often find that the structure of the table needs to be changed. Common changes are as follows: Add a column Delete a

The batch query results of the database are updated. Batch update of databases. Business Requirements: The source_id of the data with type 1 in Table a needs to be updated to a new id. Because the previous id is stored in p_server, it is now

How to add redis extension to php on ubuntu system and ubuntu redis In a recent project, if you want to use redis as a database, php is not waiting for redis extension and must be installed. How can you install it? Many of the materials I found on

Oracle11g manual steps, oracle11g steps# Create oracle instance parameterVi initkevin. orDb_name = 'kevin'Memory_target = 0Sga_max_size = 5GSga_target = 3GPga_aggregate_target = 1gProcesses = 150Audit_file_dest =

SQL statements for linux --- ORDER BY, concise tutorial --- order So far, we have learned how to useSELECTAndWHEREThese two commands capture data from the table. However, we have not yet mentioned how to arrange these materials. This is actually a

Simple tutorial on SQL statements in linux-simple tutorial on functions and SQL Since there are a lot of data in the database that already has numbers, a very important purpose is to be able to perform some operations on these numbers, such as sum

Linux SQL statement concise tutorial --- Alias, concise tutorial --- alias Next, we will discuss the use of alias in SQL. The most common aliases are column aliases and table aliases. To put it simply, the column alias aims to make the SQL results

Linux SQL statement concise tutorial --- COUNT, concise tutorial --- count As mentioned on the previous page,COUNTIs one of the functions. It is widely used and we will discuss it here. Basically,COUNTThis allows us to count how many pieces of data

The first parameter of ORA-07445 is: kkqljppr, ora-07445kkqljpmprOn Version 11.2.0.1.0, executing an SQL statement in pl/SQL developer will cause connection interruption. To solve this error, locate the error log file in the trace directory and

MySQL read_log_event (): 'found invalid event in binary log', invalidbinary MySQL is known for its ease of use. It can install N different versions on the same server to facilitate testing and migration. In addition, mysql is integrated in most

[DB] [MySql] mysql @ IDENTITY Anyone who just switched from Oracle to MySql will be confused that MySql does not have Sequence in Oracle. MySql does not have Sequence. How can I achieve the best primary key of MySql? There are mainly the following

[Chapter 3. Detailed Configuration [section C],3.6. Routers The Route implementation provided in the current implementation includes: 1. Default Router: This Router sends all data to all nodes in the group to which the target node defined in the

Understanding the HDFS storage mechanism and HDFS storage mechanism Understanding the HDFS storage mechanism 1. HDFS pioneered the design of a file storage method, that is, separate file storage after splitting; 2. HDFS splits the large files to

Serious database deadlocks cause fault diagnosis when the middleware connection pool is full and the middleware pool is full1. Fault The foreground system application cannot log on. The running status of the weblogic Server application is overload,