Database Administrator

The file backup system does not guarantee data integrity, especially data errors caused by software problems, which cannot be identified by the backup system. In recent years, my important data has been well preserved, and in the past few years, a

SQL Server itself has data import operations. However, if you want to import data from a backup file, you need to perform other operations. The following is an example. There is already a DOE database on the SQL Server and there is a large amount

Copy command of SQL * Plus Copying data between data tables is one of the tasks that Oracle DBAs often face. Oracle provides a variety of solutions for this task. The SQL * Plus Copy command is one of them. The SQL * Plus Copy command uses SQL *

Method 1:Log on to the MySQL Server using the MySQL Adminstrator GUI Tool, but the Server returns the error message Host '60-248-32-13.hinet-ip.hinet.net 'is not allowed to connect to thisMySQL serverThis is because of permission issues. The

If you have any better requirements and suggestions, please leave a message.#! /Bin/bash# Mysql autobackup shell# Write by loulancn # 163.com# ------------------- User name and password related to the database, database name to be backed up, backup

Database Oracle10202, memory 4G, adjust the database sga_target, initially sga_target is 160 M, ready to adjust it to 2147483648, the results of the error ORA-27102, after multiple experiments, it is found that the database is started when

Solution 1:Log on to the MySQL Server using the MySQL Adminstrator GUI Tool, but the Server returns the error message Host '60-248-32-13.hinet-ip.hinet.net 'is not allowed to connect to thisMySQL serverThis is because of permission issues. The

Mysql dual-Machine backup method:In Unix, It is/etc/mysql/my. cnf or/MySQL user's home directory/my. cnf. In windows, it depends on the location of the my. ini file you called, and my location is under the mysql root directory. Setting method:Set

Many people know that the role permissions of users are not available in the stored procedure. Example: SQL> select * from dba_role_privs where grantee = 'suk '; GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE -----------------------------------------

How to modify the prompt in Oracle When sqlplus is started, it reads the glogin. SQL script and writes it in the $ Oracle_HOME/sqlplus/admin directory. Here is an example. [Php] -- -- Copyright (c) Oracle Corporation 1988,200 0. All Rights Reserved.

An Oracle trigger is a special type of stored procedure, which is different from the stored procedure. A trigger is executed when an event is triggered. trigger events can be divided into three categories: DML events, DDL events, and database events,

In Oracle development, the conditional expressions between if and then are full of "art" and require us to discover and appreciate them. Appreciation 1: Three-value Logic If an expression contains a null value, what is the final result of the

Oracle 10 Gb partition tables do not support automated management. Generally, you must manually create and delete partitions. Today, we have a script for automated table space management. This script consists of three parts: sys_ConfigTable. SQL,

Partition index summary: I. Partition indexes are divided into two types:1. global, it must be Prefix. Non-prefix does not exist2. local, which is further divided into two categories:2.1. prefix: the first column of the index is equal to the

Today, Oracle SQL plus performed the delete and query operations and then the query operations in PL/SQL. The results of the same statements were different, which made me feel quite depressed, later, I suddenly thought that the data on both sides

1. create necessary Directories D: \ app \ Administrator \ admin \ jxg12_20104350121 2. Create a database file storage directory under oradata D: \ app \ Administrator \ oradata 3. Create the initialization parameter file D: \ app \ Administrator \

Oracle backup, recovery of single or multi-table data steps, applicable to Oracle 8, 9, 10. * Back up single or multi-table data: Exp user/password @ server file = filefullpathname log = logfullpathname tables = (tablespacename. table1,

Oracle rac was installed on the VM a few days ago. After the node is started up today, it is found that rac is working abnormally [oracle @ node1 bin] $./crs_stat-tName Type Target State Host-----------------------------------------------------------

First look at a conversation: Cainiao asked: I set local_listener = 'listener1' In the parameter file, and an error is reported when the database is started. SQL> startup ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132:

Recently, the alter log contains the VKRM error message, so I learned how to query it. From Oracle 11g, each day has its own windows and each of it has been specified default resource plan. this is something new for me too. so, I think that wocould