Database Administrator

Oracle Database Architecture Analysis Shows the Oracle database architecture, We can see that the Oracle database server is roughly divided into two main parts: 1. Oracle instance (upper part of the database instance) 2. database (lower part of the

ORA-24324 & ORA-01041 reboot Database Error Yesterday, when the Oracle database was restarted, an error was reported, ORA-24324 and ORA-01041 error, the following restore the error process and the process of solving the problem. 1. Prepare the

Relationship between Oracle database view and base table I. What is a view first? A view is actually a query SQL statement used to display relevant data in one or more tables or other views. A view uses the results of a query as a table. Therefore,

PostgreSQL recursive query for tree structure query and postgresql Recursion A very interesting feature found during Postgresql's use is that recursive queries can be used for results that require a tree-like structure. For example, the data

MongoDB learning-Continuous updates and continuous mongodb Learning Refer to the MongoDB authoritative guide for more information and updates in this article. Advantages of MongoDB MongoDB has rich data models and is a

Mysql exports csv files separated by commas (,) and mysql exports csv files by commas (,). In actual work, CleverCode often needs to export some reports or log data. If you directly create a page, if the number of times is not large, the

Some changes need to be made when Oracle Client 10g is installed on Windows 7, oracle10g The new notebook, Windows 7 Pro, needs to install the Oracle Client, the colleague gave a 10G version. Prompt during installation: "Checking operating system

New feature 3 of Oracle12c-enhanced management functions and new features of oracle12c 1. Online renaming and migration of data files In Oracle12cR1, migration or renaming of data files does not require a series of steps. For example, you need to

MySQL technology insider-InnoDB Storage engine-Reading Notes (2), mysql-innodbMySQL technology insider-InnoDB Storage engine-Reading Notes (2) Mysql is always indispensable for php development. Series blog link

HBase learning Summary (1): HBase download and installation, hbase Summary (HBase is a type of Database: Hadoop database, which is a NoSQL storage system designed to quickly read and write large-scale data at random. This article introduces the

Expdp when encountering ORA-39097 & ORA-39065 & ORA-39079 & ORA-06512 & ORA-24033, expdpora-39097Expdp ORA-39097 & ORA-39065 & ORA-39079 & ORA-06512 & ORA-24033In expdp, various errors are reported. I am also drunk. The version is 11.2.0.1, And the

MongoDB introduction and installation, MongoDB introduction and Installation Mongo DB is a non-relational database (NoSql) that is very popular in the IT industry, and is favored by IT practitioners with flexible data storage methods. Now, we will

Convert the PostgreSQL data table to excel and postgresqlexcel COPYExchange data between PostgreSQL tables and standard file system files.COPYTOCopy all contents of a tableToOne file, whileCOPYFROMSlaveCopy data from a file to a table (attach the

Aerospike C client manual --- key-value storage-read records, aerospike ClientRead records The Aerospike C client AP provides four operations to read a record from the database: aerospike_key_get()-Read all bin data of a record.

MongoDB step by step (2) mongodb compared with T-SQL, mongodbt-SQL SQL Terms/Concepts MongoDB Terms/Concepts Database Database Table Collection) Row Document) Column Key) Value

Install mysql glibc package in linux and mysqlglibc Download mysql: Http://downloads.mysql.com/archives.php If you select a mysql version, you must be optimistic about it later. Such as: mysql-5.0.90-linux-i686-glibc23.tar.gz This example is

How to use SQL server for the first time-writing to a newbie and SQL server to a newbie 1. Put the DATA table given by the instructor in the directory [C: \ Program Files \ Microsoft SQL Server \ MSSQL10_50.MSSQLSERVER \ MSSQL \ DATA. 2. enable

[Mysql] Change the root password and create an account with the same permissions as root, mysqlroot You may need to change the root password because it must work with the Mysql database password on the server. You cannot always use Ctrl + H to

Oracle log file location, oracle Log FileOracle log files include warning logs, trace logs, audit logs, redo logs, and archive logs.Warning log: the alert log, which corresponds to the background_dump_dest set in the system initialization parameter

Principles of SQL injection and SQL Injection After successful SQL injection, you may obtain all the information of the target database! First, find the target URL to test the vulnerability. Search in google: inurl: news. php? Id = 2 Enter a URL at