Database Administrator

The following two system tables are used to query the table where a constraint is located. User_constraints constraints table, which records all constraints of the user. Such as non-null and index. User_cons_columns constraint field table, which

Summary: in Oracle, a user is granted the permission to access all tables of the user. For example, grant the query permission of all tables under the scott user to the T User. Create Or Replace ProcedureGrant_selectAll_ SQLAs The_c1Integer; The_

First, do you want to select Incremental backup? All incremental backups must first create level 0 backups. Level 0 backup is equivalent to full-database backup, but the two are not the same, because full-database backup does not contain Incremental

In daily work, synchronization errors are the most common problem. If you find that the problem has not been solved after the repair, the general method is to re-dump a copy on the Master, then restore the Server Load balancer instance on the server

For example, if you update the field tk_zyt_scenery_order in the table to t_advs_order, it is generally written as follows: UPDATE t_advs_order SET Attribute1 = (SELECT o. order_state FROM tk_zyt_scenery_order o WHERE o. order_id = 'on '),

Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include: 1. timeouts (timeout) 2. file Upload uption (the file is

I encountered a ORA-00257 error in the actual project (insufficient space error), by looking for information, the vast majority of said this is due to archiving too many logs, occupying all the hard disk space caused, you can simply delete logs or

After installing Oracle 11g rac. the scanip is configured in ora, but it cannot be accessed. The error is that the target host does not exist. It has been tossing for a long time and I have not figured it out. Later I found that local_listener is

Databases are not archivedActiveStatus log corruption SQL> select * from v $ Log;  GROUP # THREAD # SEQUENCE # bytes members arc status FIRST_CHANGE # FIRST_TIM -----------------------------------------------------------------------------------------

BackupUserTablespace SQL> alter tablespace users beginbackup;  Tablespace altered. SQL>! Cp/u01/tiger/oradata/orcl2/users01.dbf/bk  SQL> alter tablespace users end backup;  Tablespace altered Trade and destroyUserTablespace SQL>!

The archive path of rac is modified. If the archive path is not modified, an error is reported when the server is started today. ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated This error is caused by a problem

The following error occurs when an extract is started today: 22:41:02 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, e1_rks2. prm: cocould not find archived log for sequence 10770 thread 1 under default destinations SQL , error retrieving

Here we mainly verify the storage of null values of the number and varchar2 data types. First, we will introduce the structure of row piece. Reference A structure chart of the official document Generally, a rowpiece excluding (cluster table and

AutoMySQLBackup assists database administrators in backing up databases on a daily, weekly, and monthly basis.Installation and setting methods:1. download the latest version of Sourceforge (2.5.1-01)2. Add executable permissions $ Mv automysqlbackup-

1. Why dynamic hash? The common hash is mostly the following face: Figure 1 static hash structure This Hash maintains some buckets, that is, the left part of the graph. Each bucket contains data with the same hash value. These data with the same

In this article, Oralce horizontal table sharding finds that tables are stored in each partition table by year based on the above horizontal table sharding. Since the data volume is still large by year after the business promotion. So we can

Median refers to the data that is arranged in order of size to form a series that is located in the middle of the series. The median value is represented by Me. According to the definition of median, half of the data studied is smaller than the

1. Establish a link between PHP and mysql Php. ini load mysql components:Before extension = php_mysql.dll; removeExtension_dir = "" is the path correct? Link PHP to mysql Functions Mysql_connect: Enable the MySQL LinkMysql_select_db: open a database

How to generate mysql-bin.000001 file and its processing methodFiles such as mysql-bin.000001, mysql-bin.000002 are database operation logs, such as updating a table, or deleting some data, even if the statement does not match the data, the command

Name Role Server (RHEL6.0) Server 1. prerequisites (1) decompress the compressed file [root @ localhost ~] # Unzip linux_11gR2_database_1of2.zip //Decompress the ZIP file package [root @ localhost ~] # Unzip linux_11gr2_database2