Database Administrator

CommandDescription /Run SQL Buffer ? [Keywords]SQL help for keywords @ [@] [File name] [parameter list]Run the specified command file with the specified parameter ACC [EPT] variable [DEF [AULT] value] [PROMPT text | NOPR [OMPT]Allow users to enter

1) Q: the following error is reported when you telnet to a SUN machine: No utmpx entry. You must exec "login" from the lowest level "shell ". After I have done the following: Cd/var/adm Mv utmpx utmpxbak Touch utmpx Telnet returns to normal. When

Create test tableSQL> create table a (a date ); The table has been created. Create a custom ProcessSQL> create or replace procedure test2 begin3 insert into a values (sysdate );4 end;5/ The process has been created. Create a JOBSQL> variable job1

1. First, add the scheduled task to the list. The system scans the task list every minute to check whether the task is to be executed at the current time. /etc/crontab:  # m h dom mon dow user    command    0 1  *   *  *   root    /home/fzw/

The control file in Oracle is very important, which specifies some important parameters for starting and disabling Oracle databases, such as the number and location of log files and data files, therefore, multiplex multiplexing is usually used for

Binutils-2.17.50.0.6Compat-libstdc ++-33-3.2.3Compat-libstdc ++-33-3.2.3 (32 bit)Elfutils-libelf-0.125Elfutils-libelf-devel-0.125Gcc-4.1.2Gcc-c ++-4.1.2Glibc-2.5-24Glibc-2.5-24 (32 bits)Glibc-common-2.5Glibc-devel-2.5 Glibc-devel-2.5 (32

Rownum is an ending field appended to each table by Oracle. It records the row number of each row. One drawback of Oracle is that rownum can only be used with ' Top 5 with the highest salary Select ename, salFrom (select ename, salFrom empOrder by

Using the flash back table feature in Oracle Database 10 Gb, you can easily restore accidentally deleted tables. The following is a situation that should not happen frequently: the user deleted a very important table-of course, accidentally

Oracle How does one use free space in the database? Below is Oracle Structure of data blocks in: Data block is Oracle The smallest storage unit in the storage system. However, you can set the storage parameters to be clear. Oracle How to use the

The MEMORY_TARGET parameter was introduced in Oracle 11g, mainly used to control Oracle's use of system memory. For the first time, the SGA and PGA were integrated for automatic management. Once the MEMORY_TARGET parameter value is set, Oracle will

When catalog is not used, all configuration information in rman is recorded in the control file. Dump information in the control file: **************************************** ***********************************RMAN CONFIGURATION RECORDS*************

Backup:Back up a database (execute in shell, the same below ):Mysqldump-uusername-ppassword-hhostname -- databases db_name>/path/db_name. SQL Back up multiple databasesMysqldump-uusername-hhostname-ppassword -- databases db1_name db2_name

When installing Oracle in Linux, swap is insufficient. solution: Root User 1. Add a file system (The following is an example of adding a file system of MB) Dd if =/dev/zero of =/home/oracle/myswaps/swapfile1 bs = 1 M count = 512 Note: The path

Client configuration and error: [Oracle @ bys3 admin] $ cat tnsnames. oraBysrac =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.228) (PORT = 1521) -- the ip address here is the scanip address of RAC.(CONNECT_DATA =(SERVER =

Environment: CentOS6 + Oracle11g   In Linux, When you confirm input of rman, execute the bash Find/-name rman (file with the rman name in the root directory) Su-oracle Echo $ PATH Vi./. bash_profile (adjusted to PATH = $ PATH: $ HOME/bin)   Confirm

SQL> alter database open read only;Alter database open read only*ERROR at line 1:ORA-10458: standby database requires recoveryORA-01152: file 1 was not restored from a sufficiently old backupORA-01110: data file 1: '/Oracle/oradata/BSTYLE/system.309.

1. Create a databaseMysql> create database if not exists tongcheng;Query OK, 1 row affected (0.01 sec)Mysql> 2. view the options when creating a databaseMysql> show create database tongcheng;+ ----------- + -------------------------------------------

Oracle uses ASM for storage. By default, there is only one control file for database creation. To add more control files, you must manually add them. The following are the specific steps: 1. view the current control file [Oracle @ Oracle-LAB dbs] $

Environment: DB: Oracle 11.2.0.2 Operating System: OEL Linux (OEL) 5.6   Symptom: Change hostnamenjdyw-> route 07   After the server is restarted, the crs service cannot be started. [Oracle @ nvi07 diag] $ crs_stat-t CRS-0184: unable to communicate

1. MySQL statement for copying table structures and table data: completes simultaneous replication of table structures and table data (creating tables and copying data) Mysql> create table tmp_table SELECT * FROM dede_news;Query OK, 628 rows