Database Administrator

After mysql is installed, login finds that there are only two databases:Mysql> show databases;+ -------------------- +| Database |+ -------------------- +| Information_schema || Test |+ -------------------- +,Mysql> use mysqlERROR 1044 (42000):

ORA-01031: insufficient privileges solution ################################### ############ NAME: troubleshoot connect internal.txt## DESCRIPTION:# Connect internal# Connect/as sysdbaPassword problems: # Refer (METALINK, OracleDOC ),# Metalink

# CentOS 4.7 Oracle 10.2.0.1 # Scp user @ host 10201_database_linux_x86_64.cpio/local Decompress the package to/home/oracle/database. # Cpio-ivmd ####################### # System Environment Settings ####################### 1) view the kernel

I have never been familiar with Oracle databases before, and I have been using MSSQL. Speaking of the SQL statements of these two databases, there are many differences. I cannot tell the specifics, daniel knows better than me. Here I just want to

There are three installation methods for mysql in Linux: 1. yum/rpm 2. Source Code installation 3. Binary Installation The first installation method is not mentioned here. The upgrade method is mainly binary installation, which is very

-- Book tableCreate table book (Book_id VARCHAR2 (20 ),Book_name VARCHAR2 (100 ),Book_publish VARCHAR2 (100)); -- In indicates the input parameter. The default value is in.-- Out indicates the output parameter.Create or replace procedure sp_pro7

1. Clone Process Oracle@www.bkjia.com ~ $ Dbca 1. After running DBCA, select "manage template ". 2. Select "create from existing database (structure and data" 3. Select the name of the instance to be cloned. 4. Enter the Template Name and

Data Block overview Oracle manages the storage space in the database data file. The unit is data block ). A data block is the smallest (logical) data unit in a database. The minimum physical storage unit of all data at the operating system level is

Stored procedures are commonly used in programs, and I often write some in projects. But I make a mistake: I always write the SQL statement process into a long string of SQL statements, run the SQL statement normally. As a result, the code is too

Some colleagues asked a few MySQL parameter settings. Here is a simple record: Innodb_thread_concurrency, used to limit the number of threads that can enter the innodb Layer When read_row/write_row/update_row/delete_row is called at the innodb layer,

The ebs form cannot export Master-slave relationship (Master Detail) data to EXCEL.The following describes how to solve the problem that the EBS standard export function cannot export master-slave relationship data. Solution: 1. Add an export button

In an External table file, if the fields in the file are separated by ctrl + F, the ctrl + F separator cannot be recognized after the Chinese characters, causing an error in External table import, the solution is to add the following content when

Restore archived logs: select * from v $ log_history t where t. THREAD # = '1'Order by t. FIRST_TIME descInstance 1: Restore an archived log:Run {Allocate channel 'dev _ 0' type 'sbt _ tape'Parms 'sbt _ LIBRARY

I. Preparations before installationDownload Mysql source package: Recommended official site http://www.mysql.com/Configure the Ubuntu EnvironmentAdd a mysql user group and user:Groupadd mysqlUseradd-g mysqlCreate the directory required for

1. Create a stored procedure1. Basic Syntax:Create procedure sp_name ()Begin.........End2. parameter transferIi. Call the Stored Procedure1. Basic Syntax: call sp_name ()Note: The stored procedure name must be enclosed in parentheses, even if the

Rollback segment Overview: Rollback segments are used to store values before data modification (including locations and values before data modification ). A transaction can use only one rollback segment to store its rollback information, while a

There are some differences between multi-master-slave mutual backup and master-slave replication, because the multi-master can have write permissions on the server, so it is designed to repeat the problem from self-growth. Problem (Multiple Primary

Export: Release 10.2.0.1.0-Production on Thursday, 22 August 22, 2011 11:08:48 Copyright (c) 2003,200 5, Oracle. All rights reserved. The data pump export utility provides a mechanism for transferring data objects between Oracle databases. The

Several Propagation Features of transactions1. PROPAGATION_REQUIRED: if a transaction exists, the current transaction is supported. Enable if no transaction exists2. PROPAGATION_SUPPORTS: if a transaction exists, the current transaction is supported.

After the server receives the SQL statement, perform the following steps: Parse (resolution)-> Bind (binding)-> Execute (execution ). A flowchart clearly shows these processes: The following describes the specific execution details: 1 Select