Database Administrator

Modify the Oracle listening address in Linux What if your server has changed its ip address?What if your server name is changed?What about old friends?What Should old customers do?It doesn't matter. You can easily modify the listening address!To

Two Methods for outputting Oracle character files Let's sum up a few simple and convenient experiences. A few days ago, a colleague worked with the author to discuss how to output the database search results for a project. In order to be simple and

Use the Flashback Transaction method to restore data in a data table Misoperations and recovery of fine-grained data are common scenarios in our actual work. Based on the Redo Log and Undo mechanisms, Oracle provides many branch technologies, such

Summary of basic SQL knowledge and summary of SQL 1. Main Types of SQL statements (1) DDL: Data Definition Languages, Data Definition Language. Common statement keywords mainly include create, drop, alter, etc; (2) DML: Data Manipulation Language,

SQL SERVER cannot modify the table structure or column type. When using table structure design in SQL SERVER: Note: you cannot save the changes. You must delete and recreate the following tables. You have made changes to tags that cannot be

Cross join usage in T-SQL (semi-translation), t-sqlcross Suddenly I found a very hanging link. Let's take a look at what the database should do. be timid and cautious: DBA work content !!!! Today I will translate an article on T-SQL, this article

PL/SQL Developer configuration instructions, pldeveloper PL/SQL Developer is an integrated development environment dedicated to the development of Oracle database storage program units. Nowadays, more and more business logic and application logic

Mysql13 Copy 2, mysql13 Copy 2Replication management monitoring Show master logs;Check the second-level logs of the master database. The logname is the input parameter of other commands, and the file_size is the offset and the input

MySQL trigger, mysql trigger instance Trigger: monitors a situation and triggers an operation. Four elements of trigger creation Syntax: 1. monitoring location (table) 2. monitoring event (insert/update/delete) 3. trigger time (after/before) 4.

NLS_LENGTH_SEMANTICS parameter extension problem, nlslengthsemantics Due to the particularity of a project, there are two sets of development database environments, and both sides may make some modifications to the table structure. Therefore, a tool

Spread knowledge, share happiness-MySQL database development and optimization video, share happiness-mysql Today is July 22, September 11, a memorable day, praying for innocent lives that have passed away! This year's 500 anniversary since the

[Translated from mos] mosrfs Trace the RFS process in physical dg Source:How To Trace The Remote File Server (RFS) Process In Physical Standby Database (Document ID 1481125.1) Applicable:Oracle Database-Enterprise Edition-Version 10.1.0.2 to 11.2.0.2

PLSQL automatically disconnects and loses connection.Problem Background: This is the case. Many developers work 8 hours on plsql. Sometimes, after they go out to smoke or finish lunch, they will return an error and report no response when they come

Common commands of mongodb Mongodb is written by C ++ and its name comes from huMongoIn the middle of the word "us", we can see from the name that its ambition lies in the processing of massive data. The simplest description of this database is

Mysql backup and Restoration1. mysqldump1.1. backup method: (1) Export the entire database and specify the character set (including data in the database) Mysqldump-u root-p -- default-character-set = utf8 dbname> storage path (2) Export the database

What is the difference between allocating undo rollback segments between mysql5.6 and mysql5.7? mysql5.6mysql5.7 1. mysql5.7 is divided into two types: Temporary tablespace rollback segments and common rollback segments. 2. mysql5.6 is not

Detailed notes on Hibernate and hibernate Add environment in the Hibernate configuration file. 1. jar package 2. configuration File hibernate. cfg. xml/xxx. hbm. xml3. use hibernate to add, delete, modify, and query Configuration cfg = new

Oracle 051 (oracle 11g), 05111g Oracle 051 questions (oracle 11g) 1. INTERVAL usage Select interval '000000' MONTH, INTERVAL '54-2 'year to month, INTERVAL '11: 12: 300 'hour to second from dual; The query result is: INTERVAL

Plsql Export and Import Export Steps: 1 tools-> export user object selection option to export the. SQL File 2 tools-> export tables-> Oracle Export select option to export the. dmp File Import steps: 1 tools-> import tables-> SQL Inserts import. SQL

Install_Oracle_Database_11g on RedHat 6.4-problems and solution, oracledatabase11g The installation process lasted for one month. At first, I installed Linux 6.4 without a virtual machine. I directly installed my Asus Notebook into a Linux server,