Database Administrator

ORA-01144: File size (string blocks) exceeds maximum of string blocks   Today, the company's Oracle Server suddenly stops working. I encountered this error when I expanded a tablespace on a bare device. I want to know the specific reason. SQL> alter

Use occi to connect to Oracle in Linux without installing a client1. Assume that you have successfully installed the oracle10g and Eclipse C ++ environments.2. Replace libocci. so.10.1 and libocci10.a in the "opt/.../db_1/lib" path. (First download

Clone an existing Oracle Home without the trouble of installing the new oracle10g software. If the original Oracle Home has installed a patch, you can skip patch. 1. Prepare for installation on the target host 172.19.111.371. Add a group and a user (

1. Download phpMyAdmin, copy it to/var/www/html, decompress it, and start using it. Http: // IP/phpMyAdmin Test Cp config. sample. inc. php config/config. inc. php Chmod o + w config/config. inc. php 2. Problem 1: phpMyAdmin cannot load MySql

I use Ubuntu 10.04 and install rlwrap using sudo apt-get install rlwrap. The usage is: rlwrap sqlplus. After entering, you can use the direction key. You do not need to enter rlwrap to modify your bashrc and add alias sqlplus = 'rlwrap sqlplus '.

Package com. Oracle. ConnTest;Import java. SQL. Connection;Import java. SQL. DriverManager;Import java. SQL. ResultSet;Import java. SQL. SQLException;Import java. SQL. Statement;/*** Oracle connected to the bridge* @ Author jll*/Public class ResConn

The Oracle OEM manager displays visualized logs. After we manually clear the files in the archive directory, these records are not cleared from the controlfile, that is, oracle does not know that these files no longer exist! In this case, if we want

1. Fedora 13: create users, groups, and directories required for Oracle Installation (1) Add groups and users: Groupadd oinstall Groupadd dba Groupadd rule Useradd-g oinstall-G dba oracle Passwd oracle (2) create an Oracle installation directory and

In the official Spring Security documents, only the security ACL hsql script is provided. However, spring does not explicitly provide the database creation script and configuration instructions when using the MySQL database, the following are the

1. Review In the previous article, we talked about the use of percona-xtrabackup software. This article describes how percona-xtrabackup achieves Incremental backup and recovery.2. Incremental Backup  How to Implement Incremental backup and recovery

If multiple instances are installed on an Oracle Server, which instance is connected when sqlplus/as sysdba is executed? In fact, when sqlplus/as sysdba is executed, the user name and password can be entered at will, or as it is now blank without

An import failure occurs when data is imported or exported locally. Oracle Reports that ora 12154 cannot parse the specified connection identifier. The Import Name is as follows: Imp crspuser/123456 @ crsp fromuser = crspfenlove touser = crspuser

Oracle substr function usage Obtain the string substr (string, start_position, [length]) with the specified start position and length in the string. Substr (string, truncation start position, truncation length) // return the truncated word; When

The previous article introduced how to extract the SCP transmission speed to the maximum extent. With this foundation, we can further use compression to accelerate the transmission speed. Only scp is used, and the transmission rate is about 90 MB at

Count DML statements in MySQL binlog MASTER @ root @ test 07:44:52> create table tab02 (id int (10) primary key, name varchar (20 ));Query OK, 0 rows affected (0.10 sec)MASTER @ root @ test 08:34:54>MASTER @ root @ test 08:34:54>MASTER @ root @ test

Oracle installation is accompanied by employees data for SQL exercises. MySQL also provides the employees database, but it is not installed with the database, and its download link is extremely hidden, which may cause many people to not notice. :

Write the master-slave monitoring plug-in:#! /Bin/bashMYSQL = "/usr/local/mysql/bin/mysql-uslave-pslave12345-h127.0.0.1-P"VAR_LOG =/tmp/check_mysql_status.log. $2 &> $ VAR_LOGFunction usage (){Cat 'Basename $ 0' need at least value: 'basename $

This section describes some precautions for online Oracle table space transfer. Examples are provided.Principle Analysis Use copy data file + import metadata to migrate data Table space can be transferred across platforms COLUMNPLATFORM_NAME FORMAT

I. Reminder: The following operations will delete the database. Please back up the database files on your own in advance. 2. Three files are required. The file names and content of the three files are as follows: File 1: Mysql_Drop_DataBase.txt.

Abstract: describes in detail the definition and use of cursors in Oracle databases. You can use instance operations to gain an in-depth understanding of the usage and usage of cursor.I. Related Concepts 1. concept When Oracle Database executes aSQL