Database Administrator

RMAN cross-minor version cross-platform and byte sequence transmission tablespace Transmit the tspitr and test tablespaces in the source database on the Linux platform to the AIX platform. Use the directory/u02/transport on the source host to store

Users who query database objects in Oracle Users who query database objects in Oracle -- Query tables and views of a userSELECT TABLE_NAME, OWNER, TABLE_TYPE FROM ALL_TAB_COMMENTS where owner = 'vass '; -- Query views of a userSELECT VIEW_NAME,

H2 database functions and data types I. Common H2 Database Data Types INT type: corresponding to java. lang. Integer REAL Type: corresponding to java. lang. Float DOUBLE Type: corresponding to java. lang. Double DECIMAL type: corresponding to java.

Simulate rm for cold backup and rm for cold backupBackup recovery has always been a major concern for all relational databases. The following describes the Cold Standby database, simulates and destroys data files to restore the database, and

Mysql study Note 3 (INDEX), mysql study note IndexIndex Database Object Index: A combination of data. By indexing objects, you can quickly query specific records in the database object table. It is the most common way to improve performance. An

Simple import of SQLite data into Mysql database, sqlite data into mysql Recently, I was working on a laboratory equipment management system. I used SQLite databases. Because they are online, I changed them to Mysql databases. It is too slow to

SQL is required. Note chapter 21st uses the cursor. SQL is required.21.1 cursor An SQL search operation returns a group of rows called result sets. The Rows returned in this group are all rows that match the SQL statement.Result setSome options and

Install MongoDB in Linux and set auto-start.1. Download mongodb linux version (note the difference between 32-bit and 64-bit),: http://www.mongodb.org/downloads2.place the downloaded mongodbinstallation file mongodb-linux-x86_64-2.6.7.gz

Linux C language database, linuxc language database MySQL is an open-source free database widely used in Linux, and is the first choice for storing data in Linux applications. To install MySQL in Ubuntu, run the following command at a terminal

How can I request re-issuance of OCP paper certificates if I cannot receive them? Copyright Disclaimer: During reprinting, please use hyperlinks to indicate the original source and author information of the article and this statementHttp://blog.csdn.

MySQL database optimization summary, mysql database Summary I. Considerations for MySQL database Optimization 1. Database Design (rational table design) Three Paradigm (Standard Model) The three paradigms include: Paradigm 1: 1NF is a constraint on

Exadata (ilom) exercises, exadatailom exercisesOracle (R) Integrated Lights Out ManagerVersion 3.0.16.10 r65138Copyright (c) 2011, Oracle and/or its affiliates. All rights reserved.-> Show/Targets:HOSTSTORAGESYSSPProperties:Commands:CdShow->

Create a log file in oracle and an oracle Log File The syntax for creating a log file is as follows: Alter database database_name add logfile [group group_number](File_name [, file_name [,...]) [SIZE number] [reuse]; The syntax is described as

Batch Processing bat file solution mongodb detailed error: 10061 unable to connect because the target computer is actively rejected, mongodb10061 I am not really good at solving this problem in the form of batch processing files, thanks to Uncle

Path to mathematics-python Data Processing (2)-python Data Processing Insert column #-*-Coding: UTF-8 -*- """ Created on Mon Mar 09 11:21:02 2015 @ Author: myhaspl@myhaspl.com """ Print u "python data analysis \ n" Import pandas as pd Import numpy

Oracle asm alias file alias, asmalias Today, I saw a friend on the Internet asking: Why did I set log_archive_dest_1 In the ASM storage management mode to specify the archiving path, but I found two archived log files in ASM? (Not flashing back)

Mysql decimal and numeric data types, decimalnumericDECIMAL (M, D) Example: salary DECIMAL (5, 2)In this example, 5 (precision) represents the number of important decimal digits, and 2 (data range (scale) represents the number of digits after the

Configure listening _ 1521 port occupation, and listening _ 1521 port occupation Statement:Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the

Detailed explanation of System Change number (SCN) and change number scnDetailed description of oracle026 System Change number (SCN) the SCN System Change number is to generate a certain number of time through some functions; ensure the consistency

When an empty datafile is deleted from tablespace, The ora-03262, tablespacedatafile Reference: Cannot Drop Empty Datafile From Tablespace ORA-03262 (Document ID 1353029.1) Applicable: Oracle Server-Enterprise Edition-Version: 11.2.0.2 and later