Database Administrator

Oracle 11g tablespace dbf File migration When the disk space of the Oracle data file is insufficient or the dbf file needs to be migrated to another location in other cases, the procedure is as follows: 1. sqlplus sys/sys as sysdba 2. shutdown

Install and test Hive based on MySQL metadata Introduction: Hive is a powerful data warehouse Query Language, similar to SQL. This article describes how to build a Hive development and testing environment. 1. What is Hive? Hive is a Hadoop-based

Hive optimization tips-How to Write HQL I. Hive join Optimization 1. try to place the small table on the left of join. The hive-0.12.0 we use here is automatically converted. This means that the small table is automatically loaded into the memory

ORA-28000: the account is locked user locking troubleshooting Today, my colleague reflected a problem, a test database modified the password, and changed the password used by the relevant application, still appear after a while the account is locked,

Oracle non-archive mode Media Recovery error-ORA-26040 System Environment: Operating System: Linux RH55 Oracle: Oracle 11gR2 Simulation case: 1. view the database mode 18:12:36 SYS @ prod> archive log list; Database log mode No Archive

Configuration of the SQL Server database connected to the LAN, sqlserver First, make sure that the two machines are located in the same LAN, and then enable the configuration tool → SQL Server Configuration Manager to configure the TCP/IP IP (IP1,

Start Oracle11g service, oracle11g Service When running oracle, It is very resource-consuming and affects the speed of the machine. Therefore, I usually stop its services when I don't need oracle, but what services do we need to start and what do we

In DBMS_METADATA, use SESSION_TRANSFORM to filter DDL and dbmsmetadata. When dbms_metadata.get_ddl is used to obtain the object ddl, other additional information is sometimes obtained. For example, when you want to obtain the table creation

Chapter 1 Securing Your Server and Network (14): restricted functions-xp_mongoshell and OPENROWSET, openrowsetSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I

Mysql decompression and authorization, mysql authorizationDecompress mysql compressed version to a root directory Note the content configuration of the INI File Basedir = D: \ mysql-5.6.17-winx64Datadir = D: \ mysql-5.6.17-winx64Port = 3306Server_id

Only two fields use one SQL statement to query the name, score, and ranking of a student in the table. I encountered this problem when I went to the interview yesterday: There is a two-dimensional table with only two fields, name and score. How can

Oracle 11G direct path read is very beautiful and hurtful, oracle11gDirect path read In 11g, full table scan may use direct path read to bypass the buffer cache. Such full table scan is physical read. In 10 Gbit/s, it is read through gc buffer, so

Database partition: oracle database partitionDatabase partition:Concept:Take mysql as an example. The data in the mysql database isExist on disk as a fileBy default, it is placed under/mysql/data (you can use my. in cnf), a table corresponds to

Mysql database copy, mysql databaseWe often have this requirement to copy the mysql database on a server to another machine, such as database migration. To do this, use the ready-made mysql tool mysqldump. When using mysqldump, you must specify the

[Translated from mos] maximum data capacity limit of oracle Database and maximum data capacity limit of tablespace, mosoracleMaximum data capacity limit for oracle databases and maximum data capacity limit for tablespacesReference Original:What Is

Blue growth notes-Chase DBA (2): Install! Install! Long-lost memories have aroused my new awareness of DBAs.Blue growth notes-Chase DBA (2): Install! Install! Long-lost memories have aroused my new awareness of DBAs. ********************************

The idea sky of Oracle GoldenGate-understanding the essence of OGG, goldengateogg This article is an original article. For more information, see the source. Oracle GoldenGate's thought sky-understanding the essence of OGG The title of this article

CentOS6.5 Oracle11G-R2 installation, uninstall, linuxoracle11gr2 CentOS6.5 Oracle11G-R2 installation, uninstallResources (including all my installation processes, system backup files): http://download.csdn.net/detail/attagain/7700437 I. Hardware

An error is reported when an expression is inserted into mysql. mysql inserts table information. Today, I made a function to get fans and found that an error is returned when I insert a nickname into the database. The length must be

Pay attention to designing system updates and patches.We usually develop a system that must be upgraded frequently. Upgrading means modifying the code or data structure. Of course, you should try to modify the data structure as little as possible in