Database Administrator

The problem in the previous log "Oracle clause group by cube" (SEE) is slightly changed. Now each field has three states. How can I write SQL statements? At this time, the CUBE mechanism may not be able to form 3 of the eight power line data, you

Stored Procedures in Oracle: /* Create a storage function and return the name, salary, and annual income of the specified employee. */ Create or replace function queryEmp2 (eno in number, empname out VARCHAR2, empsal out NUMBER) -- Returns the

Oracle 11g (11.2.0.1.0) has a bug. When the table has no data, no segment is assigned. Solution: 1. insert a row and then roll back to generate a segment. This method inserts data into an empty table and then deletes it, resulting in a segment. An

Cursor Concept A cursor is a memory Workspace of SQL, which is defined by the system or user as a variable. A cursor is used to temporarily store data blocks extracted from the database. Why use a cursor? The data in the database is stored in the

ADADMIN usage ADADMIN is used to maintain the Oracle Apps file system and database. It is a common tool for Apps DBAs. (The ADADMIN execution file is located under $ AD_TOP/bin) Usage Oracle@www.bkjia.com ~ $Adadmin If the ADADMIN command cannot be

I have previously written an article about Oracle Apps patch using the hotpatch mode: Oracle EBS patch using the adpatch tool (hotpatch mode) [see ], today, we will record how to use Maintainance Mode to Patch Oracle EBS. 1. Check whether the system

I have studied several free database software to reduce the license fee. Here are some personal tokens for reference only. The first research is the well-known DB2, a database software that I have never been familiar with in my mind. It is said

Adjust the Byte of the CHAR/VARCHAR2 field of the table to CHAR Use the following SQL script: SetServeroutputOn DECLARE Sqlstr varchar2 (4000 ); CursorSqlcursIs SelectOwner, table_name, column_name, data_type,

#/Etc/init. d/mysqld startStart MySQLIf you use this command for the first time, your/var/lib/mysql database will be created. # Mysql-u rootYou do not need to enter a password for the first time.It is better to add a password to prevent intrusion.

Two features of Oracle role 1) role DelayDelayed How to enable the role to take effect immediately:Set role name;For example:Set role resource;Delay recoveryThe following experiment demonstrates the delay recovery:Session (1) scott:Sys @ ORCL> conn

I.Library Cache Lock     Library cacheHandle stores the lock and pin information. In addition, both the Library cache handle and child cursor have lock and pin. These are called library cache lock and library cache pin. Library cachelock/pin is

Using MySQL dual master + keepalived is a very good solution. In the MySQL-HA environment, MySQL is mutually master-slave, which ensures data consistency between the two MySQL databases, then, use keepalived to implement virtual IP addresses, and

Today, when the company changed tomcat, the connection to the database failed. In the beginning, the password expired. Later, the password was changed from Oracle. When trying to connect, an error was reported that the password was locked, check the

Srvctl is a command line tool provided by Oracle to manage the RAC environment of Oracle. Srvctl is introduced in Oracle 9i. Oracle10g and 11g greatly improve its functions. The following describes the simple usage of this command. 1. view the

Recently, due to the need to migrate the Oracle database, UTL_FILE_DIR settings (oracle11g, linux) are involved ). It is mainly used to output logs for executing stored procedures. At that time, the following operations were done: Create directory

Cause: The union all operation is required in the query, and the operation cannot be completed because the LONG type field exists in the table. Modify the LONG type field to the CLOB type according to the specific business scenario. After the

Step 1: view the Oracle tablespace usage: Select dbf. tablespace_name, Dbf. totalspace "Total (M )", Dbf. Total number of totalblocks as blocks, Dfs. freespace "total remaining amount (M )", Dfs. freeblocks "remaining blocks ", (Dfs.

The solution for forgetting the MySQL root Password in Linux is based on Ubuntu 12.04 LTS. Forget the mysql password. The solution found on the internet is recorded here. Edit the mysql configuration file/etc/mysql/my. cnf and add a line "skip-grant-

Fault symptom: In Linux, where all Chinese characters appear in Oracle? Alternative, or directly garbled. Sometimes the error message is garbled. Solution: I. temporary solution Switch to the Oracle user and run [SQL] view plaincopyprint?

When the tablespace is expanded in the field, the environment is: solaris 10 cluster 3.2 + Oracle 10g RAC after expansion, execute sqlplus/as sysdba and then query the table space: SQL> select file_name from dba_data_files; The following error