Database Administrator

Configure IP address access restrictions for Oracle 11g For data security considerations, make some restrictions on the IP address of the Oracle database. Only a fixed IP address can be accessed. Modify the $ JAVA_HOME/NETWORK/ADMIN/sqlnet. ora

Oracle | PL/SQL Check constraints usage 1. Objectives The instance explains how to use CHECK constraints (create, enable, disable, and delete) in Oracle) 2. What are Check constraints? The CHECK constraint adds additional constraints to the columns

Oracle Database ORA-00257 Solutions Today Oracle Database suddenly couldn't connect, reported ORA-00257 error (insufficient space error), by looking for information, the vast majority of said this is because Archivelog archiving log too much,

Manual EM configuration in Linux for Oracle 11g This article permanently updates the link address:Oracle installed with the OTK tool does not have EM configured by default. The configuration and startup process are recorded below! First create EM

RMAN-20505, ORA-0119, ORA-27400 encountered in RMAN recover This is a RAMN restoration task. The production end is Oracle 11.2.0.4 RAC and the data files are stored in the file system. The disaster recovery end stores data files in the Oracle11.2.0.4

MySQL database startup failure Solution After the server is restarted --> restart the Application Service (Confluence) --> An error is reported, indicating that the database connection fails (MySQL is set to boot automatically) --> View the MySQL

Simulate ORA-26040: Data block was loaded using the NOLOGGING option, ora-26040nologging We know that setting the nologging option can speed up the execution of some oracle operations, which is very useful when executing some maintenance tasks, but

How to: How to import UUID function into Postgre 9.3, uuidpostgre 1. Open a command console and go to the directory where you installed Postgre server. E.g. D: \ Program Files \ PostgreSQL \ 9.3 \ bin> 2. Drill down into BIN folder and issue

The definitions of SERVICE_NAME and SERVICE_NAMES and GLOBAL_DBNAME, globaldbnameSERVICE_NAME parameter value in the tnsnames. ora file -- this parameter has different values for Dynamic Registration and static registration.For Dynamic

How can I determine whether a keyword composed of multiple fields exists in another table? How can I determine whether a keyword composed of multiple fields exists in another table? Old Shuai (20141107) 1. First, it is easy to determine whether a

Change the Mysql root Password from null to 123456 and root123456 After using mysqladminmysqladmin-u root-p password mypasswd to enter this command, enter the original root password (empty) and change the root password to mypasswd. [Work @ master

MySQL database startup and shutdown, mysql database Shutdown MySQL database server usually refers to mysqld, while command line mysql is a mysql client program. These two concepts are often confusing. Generally, the mysql server is started to start

Simple ORACLE database operation function usage, simple oracle operation 1. DISTINCT usage: Select distinct a. NAME, A. STUDENT_ID, A. SEX FROM TABLE STUDENT This SQL statement queries the name, student ID, and gender from the student table, but the

Server Process, serverprocess 1. After the client performs the update operation, how does one collaborate with others? After the Client performs the update operation, the Server Process is actually completed. The steps are as follows: 1 ). the Data

Database Connection operations (1), database connection operations ( Connect to the Database Using JSP, including data query, deletion, and modification. add data to the database. The database is MySQL. The files include login. jsp, do_login.jsp

Partition Table, oracle Partition Table -- Delete partition truncate table partitionDeclare day number;BeginDay: = 20110901;LoopExecute immediate 'alter table lbidw. TB_DW_MGR_01_DAY truncate partition DATA _ '| day;Day: = day + 1;Exit when day> 2011

Dbms_stats, dbmsjob All function packages of dbms_stats are as follows: GATHER_INDEX_STATS: Analyze index information GATHER_TABLE_STATS: analysis table information. When cascade is set to true, the analysis table and column (INDEX)

Mysql1130 remote connection does not have permission solution, mysql1130 permission There are two reasons why the remote connection has no permissions: mysql and firewall. 1. Solve firewall restrictions: Shut down the firewall on the mysql

Ibatis: The ibatisquery method, which is not commonly used. 1. queryForObject /** * Executes a mapped SQL SELECT statement that returns data to populate * the supplied result object. * * The parameter object is generally used to supply

The use of rownum In the result set sorting in Oracle, using lerownumUse of rownum in Oracle for sorting in result setsFor the rownum problem in Oracle, many documents do not support>, >=, =, between... and. The preceding symbols can only be used (,>