Database Administrator

After firebird and flamerobin are installed in linux, I am very excited to use create database .. after creating my first FB database file in Linux, I opened flamerobin and planned to do something on it, connect to my database, or check the firebird

In practical applications, for paging or query performance requirements, we often need to query records with a fixed number of rows from the database. Different databases have different SQL statements. In Oracle databases, we can use the following

To learn about Oracle, we 'd better first understand the Oracle framework. In this way, we have an overall understanding of Oracle, which has the role of creating a high-level architecture.1. Physical Structure(Composed of control files, data files,

1. For a dual-host system, the code is installed on the local disk, and the database device is mounted on the array.By default, Sybase code is installed under/opt/sybase-12.5　　Under the/opt directory, create the sybase-12.5 directory　　# Mkdir sybase-

1. Go to mysql and create a new user, xuys: Format: grant permission on database name. Table name user @ login host identified by "User Password "; Grant select, update, insert, delete on *. * to xuys@192.168.88.234 identified by "xuys1234 ";

To understand the Oracle architecture, you must first understand two basic concepts: databases and instances.1. DatabaseA database is a collection of data.Whether the database adopts a relational structure or an object-oriented structure, the oracle

It is relatively simple to uninstall the Oracle software in linux. You can simply delete the relevant directories and then clean up the oracle-related files in/etc. But it is still necessary to know how to uninstall it through tools. 1. Configure

1. Download the MySQL Linux Installation File To install MySQL in Linux, the following two files are required: MySQL-server-5.1.7-0.i386.rpm To download the above two RPM files, locate the "Server" and "Client programs" items and find the items

I installed MySQL in Linux yesterday and made a note. # Wget http://mysql.ntu.edu.tw/Downloads/MySQL-5.0/mysql-5.0.45.tar.gzBytesInstall# Tar zxvf mysql-5.0.45.tar.gz# Cd mysql-5.0.45#./Configure -- prefix =/usr/ali/mysql --

Environment: Operating System: SUSE Linux9 Database: Oracle10gR2 1. Change host [Root @ www ~] # Hostname Linux [Root @ www ~] # Hostname test11 [Root @ www ~] # Hostname Test11 [Root @ www ~] # 2: Try to restart the listener Oracle @ linux:/>

1> check the database and view the control file storage pathSQL> startupOracle instance started. Total System Global Area 230686720 bytesFixed Size 1218676 bytesVariable Size 71305100 bytesDatabase Buffers 155189248 bytesRedo Buffers 2973696

Oracle DBLINK Role: the oracle database logic of servers in different locations is regarded as a database, that is, objects in another remote database can be operated in one database. Syntax:CREATE [PUBLIC] database link dblink connect to user

Hello everyone! Today, I sorted out the steps for creating a physical volume uard for Oracle10g according to the official documents: 1.1 enable force logging Mode Use the following statement to enable the force logging mode for the master database

In Oracle, sequence is the so-called serial number, which is automatically increased every time it is obtained. It is generally used in places where the sequence numbers need to be sorted. 1. Create SequenceFirst, you must have the create sequence

Today, another colleague encountered an Oracle database bug: -- This problem exists on all platforms in Oracle 10.1 OR 10.2. This error occurs when you perform complex multi-table join queries.ORA-00600: Internal error code, parameter: [19004], [], [

In Oracle9i, Oracle provides an internal event to force refresh the Buffer Cache. Its syntax is: Alter session set events 'immediate trace name flush_cache level 1 '; Or: Alter session set events = 'immediate trace name flush_cache '; Similarly, you

1. rawtohex, hextoraw Rawtohex indicates to convert raw data to a hexadecimal string (nvarchar type, Typ = 1), and hextoraw indicates to convert a hexadecimal string to the raw type.Note: If the hextoraw parameter is a string, it will be treated as

When it comes to tracking SQL statements, some people may ask about this function. Some may think of using the audit function. To track SQL statements and enable the audit function, it will become a waste, maybe the user just wants to track all the

Oracle temporary table-ON COMMIT PRESERVE ROWS Temporary tables: they are structured like normal tables, but managed differently. Temporary tables store intermediate result sets of transactions or sessions, the data saved in the temporary table is

Hive external HBase table CREATE [EXTERNAL] TABLE [if not exists] table_name[(Col_name data_type [COMMENT col_comment],...)][COMMENT table_comment][Partitioned by (col_name data_type[COMMENT col_comment],...)][Clustered by (col_name, col_name ,...)[