Database Administrator

Restrictions on InnoDB table objects Restrictions on InnoDB table objects: Maximum and minimum InnoDB log files cannot exceed 512 GB InnoDB system tablespace requires at least 10 MB Space The default data page size in the database is 16 kb.

Oracle instance hang is occupied by NFS mount points disconnected on AIX. Oracle instance hang is occupied by NFS mount points disconnected on AIX.From mos: Disconnected NFS Mount Point Causes Instance to Hang on AIX (Document ID

New Features of Oracle 11gR2 relink New Features of Oracle 11gR2 relink Source:Oracle 11gR2 Relink New Feature (Document ID 883299.1) Applicable:Oracle Database-Enterprise Edition-Version 11.2.0.0 to 11.2.0.0 [Release 11.2]Generic UNIX Solution:I)

Trace in SQL Server Preface When talking about tracking, many people think of scenes in the Police film. Similarly, "tracking" is everywhere in our SQL Server database. If we make good use of tracking techniques, in this way, you can perform

32-bit and 64-bit Oracle 10 Gb downloads on multiple platforms Some time ago, Oracle removed the 10g download from the official website, and many children's shoes did not know about Oracle 10g. Here I have attached the Oracle 10g download link for

Oracle 11.2.0.4 alert started by db instance of a single instance Oracle 11.2.0.4 alert started by db instance of a single instance Fri Jan 09 03:11:17 2015DIAG started with pid = 19, OS id = 6031Dumping diagnostic data in directory = [cdmp_201501090

Describe the MISSING keyword in datafile name Source:Explanation of MISSING keyword in datafile name (Document ID 1050268.1)Applicable:Oracle Server-Enterprise Edition-Version 7.3.4.0 to 11.2.0.1.0 [Release 7.3.4 to 11.2]Information in this

Start the SQL Server service with bat I declare that this SQL Server Service script was not written by me. I forgot where I saw it. I will share it with you here, because in my understanding, the technology is used for sharing, don't mind if the

Table aliases are not supported when the MySQL database deletes data. An error occurred while executing a deleted SQL statement. The SQL statement is as follows: Delete from LEAD_SYSTEM_MENU_ORG_REF as t WHERE t. resourceid = '4028812348f28b890148

SQL Server Remote Backup Database Regular backup of SQL Server databases is often required. It is quite easy to back up data to the local machine on a regular basis and the task can be completed. However, if the entire machine crashes, it makes no

How to purge objects that have been dropped How to purge objects that have been dropped Log on to sqlplus as the user of the drop object Then show recyclebin; F: \ Oracle \ product \ 10.2.0 \ db_1 \ BIN> sqlplus/as sysdba SQL * Plus: Release 10.2.0.4

A ORA-03262 is reported when an empty datafile is deleted from tablespace Reference: Cannot Drop Empty Datafile From Tablespace ORA-03262 (Document ID 1353029.1) Applicable: Oracle Server-Enterprise Edition-Version: 11.2.0.2 and later [Release: 11.2

SQLCookbook sorting of study notes and impression notesSelect name from emp order by salary;BY default, order by is arranged in ascending ORDER. To do so in descending ORDER, use ordel BY salary DESC.Order by does not have to be based on the column

ORACLE 10G Official documentation Demonstration: Search for manual database creation statements, oracle database creation Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when

ORACLE 10G manual database creation, oracle10 G manual database creation Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held

[Translated from mos] How to obtain the growth information of datafile backup, mosdatafile How to obtain the growth information of datafile backup? Source:HOWTO get information about the growth of the datafile backup (Document ID

Import External SQL Server data from MySQL, mysqlsql In the previous blog "MySQL 5.6.22 installation tutorial", we introduced MySQL installation. Today, we will mainly explain how to import External SQL Server data in MySQL. In short, it is how to

Oracle Storage Structure and oracle Storage StructureOracle Storage StructureStorage Structure-Table Storage StructureTable space: A table space is composed of one or more files. The space capacity of a table space is the total size of multiple

Know the file # Of datafile and find out which backuppiece the datafile belongs, F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 23 09:41:48 2015Copyright (c) 1982, 2007, Oracle. All Rights

Know the archived log sequence # And find out which backuppiece the archived log belongs ., F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 23 08:41:41 2015Copyright (c) 1982, 2007, Oracle.