Database Administrator

Oracle enhanced date functions -- Change the database time zone to UTC + 8 Alter database set TIME_ZONE = '+ 08:00 '; /* An error may occur during the modification: ORA-30079: the database time zone cannot be changed when the database has a

EXP-00091: Exporting questionable statistics Sometimes many EXP-00091: Exporting questionable statistics errors are reported when you use EXP tools to export or migrate data,The processing method is as follows: 1. symptom[Oracle @ node1] $ exp

Servlet update execution error ORA-12518 ORA-12518: TNS: listener cocould not hand off client connection This error is generally tested for database concurrency by multiple users, The backend executes an update using the servlet method, but the

MySQL master-slave Replication The principle of MySQL master-slave replication is the same as that of MySQL master-slave replication, but slave databases cannot be used for write operations, therefore, some parameter configurations may be different

Use mysqldump to export a database Mysqldump is a client program used by mysql to store databases. It mainly produces a series of SQL statements that can be encapsulated into a file. This package contains all the SQL commands required to reconstruct

MySQL5.7 online Innodb_Buffer_Pool_size adjustment without restarting the mysql process In earlier versions, it is much easier to adjust the Innodb_Buffer_Pool_size to take effect only after the mysql process is restarted. Application scenarios of

Report software companies offer a high price reward for bugs. I am really drunk on 100 pieces, and I am bug100 pieces. I have been using FineReport, The FineReport report software of fansoft, for a long time, and have been paying attention to the

BI Financial DBDIFF Analysis Issue, Core formula: DB --> ETL --> DW vs REF file   Cause of error: 1. DB/DW Connection Issue 2. SQL Issue 3. Product Bug 4, REF file not updated   Physical requirement analysis: 1. Source DB: EBS, PSFT, Fusion... DB

Database practical Script 1 --- query the table names with data in the database and the number of rows in the table, 1 --- number of rows Create table # Temp(Name varchar (30 ),Num int) Declare @ Name varchar (30)Declare @ SQL varchar (1000)

Colored SQL -- How to force the AWR to capture a specified SQL even if it is not the top one, SQL -- howawrThis new feature doesn' t paint the SQL statement in color; rather, it sort of marks it as "important ."Suppose you are troubleshooting a

ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [1498], [18713], [18720], internalerrorDatabase Server appears ORA-00600 [kcratr_nab_less_than_odr], cannot open database 1. open DATABASE reports ORA-00600 [kcratr_nab_less_

About mysql stored procedure creation dynamic table name and parameter processing, mysql Stored ProcedureReprinted please indicate the source: curtain roll west wind column (http://blog.csdn.net/ljxfblog) Recently, the game started its second

Use of sqlite3 script and sqlite3 script I wanted to find a database-specific tool. Later I found that the script was very simple and I used the script directly. The sqlite3 script allows you to conveniently view the content in the current

XML parsing --- dom parsing and sax parsing, xml --- domsax Parsing Currently, two methods are used for XML parsing: 1. dom parsing: (Document Object Model, that is, Document Object Model) is a method recommended by W3C for parsing XML. Use dom to

Difference between % TYPE and % ROWTYPE in PL/SQL, % type % rowtype % TYPE: Defines a variable. Its data type is the same as that of a defined data variable or the data type of a column in a database table.In this case, % TYPE can be used.The

Network problems occurred during rac_grid self-check. rac_grid self-check Network 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

Oracle Technical Summary, oracle Summary Http://www.cnblogs.com/jimeper/ Http://blog.csdn.net/dragonxiangfu Http://www.boobooke.com/bbs/thread-272667-1-1.html Summarize the advantages and disadvantages of MySql, Mssql, and Oracle 1. The largest

Mysql installation on linux II (mysql source code installation), mysql source code1. Download the corresponding mysql installation source packageAddress: http://dev.mysql.com/downloads/mysql/5.1.html2. If you have previously installed mysql,

Resolution ORA-28000: the account is locked, ora-28000locked In oracle, if the account fails to log on for ten consecutive attempts, the account will be locked ). When you log on with a locked account, the system reports an error: ORA-28000: the

The error and solution after the sqlserver host name is changed. The sqlserver Host Name After changing the Host Name of the sqlserver server, you need to perform some operations. Otherwise, there will be problems with the maintenance plan and