Database Administrator

Oracle 9i reported ORA-01036: Invalid variable name/Number The The problem is the variable name. SQL method: @ username I use the Oracle database in the following way: username Just change to Oracle. Public StringInsertUser (UsersUser) { //

Steps for generating an Oracle AWR report Oracle AWR generates report data by comparing the statistical information collected by two snapshots. The generated report consists of multiple parts, which is similar to the report generated by Statspack.

Does Operations on blob fields in Oracle produce a large number of redo operations? Check whether the blob field produces a large number of redo operations. The answer is no. Here is an experiment to test whether the Oracle database version is 11.2.0

Non-Oralce user environment variable configuration In the project, you need to configure environment variables for web users of the same server to execute sqlldr of Oracle, and record the implementation steps and problems: (1) copy the settings of

Notes for handling ORA-4065 errors When receiving channel feedback, a user prompts when performing software operations'ORA-4065 not executed, stored procedure Zl_XXXX_Finish changed or deleted', The user tries to re-compile the process and can use

Dataguard primary database reported ORA-16146 error Solution Product Version 10.2.0.4Operating System Oracle Solaris on iSCSI (64-bit) 5.10 1. the alert Log is as follows:Master Database alert log---------------------Tue Mar 11 14:30:47 2014LNS:

An example of ORA-00257 archiver error. error Solution An Oracle vulnerability is found here. For example: DELETE JEW_LOG WHERE C_ID IN (SELECT C_ID FROM BAS_BATCHNO WHERE C_WARID = '028' AND C_BATCHNOTYPE = 'P ') The subquery in this DELETE

Query and delete sessions in Oracle Query and delete sessions in Oracle1. query the current session SQL> select username, sid, serial # from v $ session where username is not null;Username sid serial #-------------------------------------------------

DB2 SQL0902C solution instance On Sunday, when the development environment archives and deletes the database, after the database is restarted, the database cannot be opened, and the database will be restored in the future because it is the

DML operation DDL trigger Today, the application side told me that a DML operation caused the database to report an error, said "ORA-234567, do not allow development to execute DDL operations, please contact DBA" To ensure security, DBAs create

In-depth analysis of Oracle Library Cache In-depth analysis of Oracle Library Cache Each object in the database cache is divided into multiple parts in the database cache for storage. Oracle aims to achieve more flexible memory management, because

[Translated from mos] ABMR: A method to test the Recover feature of the Automatic Block in the asm environment, mosabmrABMR: how to test the Recover feature of the Automatic Block in the asm EnvironmentReference Original:ABMR: How to test Automatic

MySQL: on duplicate key update usage, mysqlduplicateYou can use this syntax to determine whether a record exists when inserting a record. If the record does not exist, insert the record. Otherwise, the record is updated, which is convenient and

Display the numbers in the database as text, and sort the numbers in the database We often have such a rule in the database: 1 indicates male and 0 indicates female. However, you cannot display 0 or 1 on the page. You must convert the gender

When querying users, you may also use a variety of query conditions, such as by employee ID, by name, by gender, or by education level. It is also possible to query by a combination of multiple conditions, such as checking the educational background

OS & MySQL version and Configuration: MySQL Version: 5.6.19Linux Version: Linux boston.oracle.com 2.6.18-164. el5 #1 SMP Thu Sep 3 02:16:47 EDT 2009 i686 i686 i386 GNU/Linux   1. To DOWNLOAD the MySQL Installation Software, go to www.oracle.com to

By default, MySQL installation on Linux is case sensitive to database tables. The modification is simple. You only need to modify the mysql configuration file. Mysql> show tables;+ -------------------------------------- +| Tables_in_cddl |+ ---------

No matter what the project is, you have to contact the time type. Currently, using timestamps to store date data (for integer storage) is already a common practice in the industry. Various online game companies and major open-source companies use

22. You need to create a table for a banking application. One of the columns in the table has the following requirements:1) You want a column in the table to store the duration of the credit period.2) The data in the column shoshould be stored in a

Drop procedure if exists P_SEQUENCE; /** temporarily omitting the package @ auto liangrui 2014/6/27 T_PRO_PRODUCT table sorting: sort the entire table by sequence number. Sort the sequence number by sequence number from the creation date of the