Database Administrator

Procedure for configuring a Shared Server in Oracle Oracle configuration sharing Server:1. Configure the second listenerNetca/manualManual: listener. oraLSNR_2 =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = Demon) (PORT = 1526

Create and delete temporary tables in Oracle Create global temporary table tablename (COL1 VARCHAR2 (10 ),COL2 NUMBER) On commit preserve (DELETE) ROWS; -- On commit delete rows indicates that the temporary table is specified by a transaction. After

Oracle 11g change log group size Oracle 11g change log group size 1. Create a New log Group 1. alter database add logfile group 4 ('/u01/app/oracle/oradata/jian/redo04.log') size 1024 k; 2. alter database add logfile group 5

MySQL Condition Optimization example Some friends tried the following and asked questions: Merge having conditions into where conditionsAdvantages:It facilitates unified and centralized resolution of condition clauses, saving time for multiple

Java code to import backup database files to the Oracle database Today, we will paste an Oracle database backup feature that has been implemented very early. This feature was designed at the university stage: Import java. io. IOException; /*** Java

Oracle OWB introduces series 1 introduction and use process OWB, Oracle Warehouse Builder, is a tool for oracle to implement data warehouses. To put it bluntly, it is to clean and convert data from many other databases and load it into a data

Use SPFILE to reset the configured initialization parameters to the default values of the system.Start with SPFILE. If you want to restore the initialization parameter to the default value, use a statement like this:Alter system reset db_create_file_

Use Mybatis to pass multiple parameters (three solutions) and mybatis Solution There are three methods to transmit multiple parameters that I have come into contact. Solution 1 DAO layer Function Method Public User selectUser(String name,String

Mysql batch deletes table prefixes or suffixes, and mysql batch deletes tables Oracl has the usage of drop table like, but mysql does not. You can write scripts (not to repeat them) or assemble SQL statements. Note: My database name is test and

Database Design-multi-value Storage The problem of storing multiple values is a common problem in database design. I think it is necessary to come up with it if many developers suffer losses. Business scenario: A business document with multiple

How to handle ins_emdb.mk error during oracle Installation, oracleins_emdb.mk **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog". You are welcome to repost

Upgrade the data dictionary to solve the ORA-01092: ORACLE instance terminated. Disconnection forced problem, oracleinstance When the oracle instance is shut down, the existing database also needs to be upgraded after the Oracle software is upgraded

Check the empty rows in the kettle data stream.Zookeeper Check for empty rows in the kettle data stream   During ETL processing, sometimes data needs to be generated but data is not input, which may cause some problems. Therefore, ETL data streams

Automatically generate a Model that complies with Sqlachemy: How to Use sqlautocode. How to Use codeblocks The call format is as follows: sqlautocode [options, ] Database_url is the database url we configured when using SQLAlchemy. Some people are

IReport + jasperreport: how to create a sub-table (1), ireportjasperSubtables are essential in the process of creating reports. Today I have studied several ways to create subtables. 1. Create a sub-table by connecting to the database Take MySQL as

Use an SQL statement that has been running for a long time in the mail, and send an SQL statement in the mail ALTER proc [dbo].[usp_EmailLongRunningSQL]asbegindeclare@LongRunningQueries AS TABLE( lrqId int IDENTITY(1,1) PRIMARY KEY, spid int NULL,

Database Connection sorting and database sorting Connections can be divided into internal connections, external connections, cross connections, and self-connections.1. Cross join 1) supported databases: ORACLE, MYSQL, SQL Server, and DB2. 2)

SetParameter and setParameterList in hibernate pre-compiled SQL statements, and hibernate pre-compiled Use pre-compiled SQL statements and placeholder parameters (which is in jdbc ?), This avoids the complexity of concatenating SQL statements with

SQL has one table but not the data in another table. SQL is not Select. id,. OA code,. custid,. custname,. xsz,. salename,. communicationtheme,. communicationproperty,. communicationtime,. productmanager, ''creator,. creator oaCreator,. createdate,

Install MySQL in linux source code Recently, MySQL Fabric needs to be used. This product is a utility generated after MySQL5.6.10. MySQL5.1 is installed on the machine at hand. Therefore, you need to upgrade the old MySQL version to MySQL 5.6 first.