Database Administrator

Korean encoding can be stored using UTF-8 or dedicated euc-kr encoding. In today's work, we need to transfer data from a Korean website to a local device for testing, Then it is transferred to the database of another server. The mysql import and

SQL>SelectTo_char (hire_date, "Color: # ff0000 ;">'Yyyy-MM-dd')FromEmployeesWhereRownum TO_CHAR (HI ---------- 2017-06-21 2000-01-13 1987-09-17 1996-02-17 1997-0 1994-06-07 1994-06-07 1994-06-07 1994-06-07 "Font-family: Arial;

When a table needs to be flashed back to a long time ago, the following error is reported (the black font is a variable, which may be different each time) ORA-0155: Snapshot old: rollback field number10(Name: "_ SYSSMU10$ ")Too small Solution:

Analysis on Oracle Parameter Modification SCOPE = SPFILEThe change is applied in the server parameter file only. The effect is as follows:For dynamic parameters, the change is valid at the next startup and is persistent.For static parameters, the

Oracle processes can be divided into three types. User Process, Server Process, and Background Process. User Process runs on the client and is not on the database server. Of course, if you run the client on the server, it runs on the server. For

DBMS_OUTPUT has the upper limit of the cache. The default value is 10000 bytes. When the value exceeds 10000, an exception "buffer overflow, limit of 10000 bytes" is thrown. Test the stored procedure as follows: Create or replace procedure

ORA-01280: Fatal LogMiner Error. Logminer is easy to use. follow the steps below. 1. InstallRun the following two scripts in Oracle10g:L $ ORACLE_HOME/rdbms/admin/dbmslm. SQL2 $ ORACLE_HOME/rdbms/admin/dbmslmd. SQL. These two scripts are used to

From mysql 5.5, mysql source code installation began to use cmake, and compilation and installation were a little different from previous versions. 1. installation steps: 1. Preparations before installation A. Download the mysql Source Code package.

How does an Oracle service process user process requests? The server process mainly completes the following seven tasks in the process of completing the user process request: 0. SQL statement Parsing1. Read data blocks into db buffer2. log recording3

This chapter describes how to configure and manage the Oracle EBS warning system. It is convenient and timely for users or the system to operate databases. Next we will talk about the procedure: 1. Manage the alert system --> System --> OptionThe

In this DocumentGoalSolution Applies: Oracle Server-Enterprise Edition-Version: 9.2.0.6.0Information in this document applies to any platform. Goal In this note, we will help Database Administrators with answers to two common questions:How can I

There are two methods to create a database in Oracle. The first is to use Oracle database builder and DBCA, which is a graphical interface and easy to understand because of its friendly and beautiful interface and complete prompts. In Windows, this

This article discusses the situations where the index should have been established due to negligence or Incomplete consideration. Select distinct sp. OBJECT_NAME, round (ds. bytes/1024/1024, 2) MB, num_rows, last_analyzedFrom v $ SQL _plan sp, v $

PO --> supply source --> approved supplier list Find the supplier corresponding to the material "105010000056"-> click "properties" to enter the "supplier material properties" form, When "inventory" is set, "supplier delegate" cannot be selected,

1. concurrent to no-concurrent, and importvg through exportvg, which cannot be solved; It should be: Host: Varyonvg-f dbvg // activated in no-concurrent Mode Chvg-l dbvg // forcibly convert to no-concurrent; Varyoffvg dbvg On the slave server:

Use the cursor and temporary table in the MySQL stored procedure: BEGIN DECLAREC_egidINTEGER; DECLAREDoneINT DEFAULT0; DECLAREMy_testCursorCURSOR FOR (SELECTCp. tb_electricGroup_idFROMTb_chargingPoleASCpWHERECp. tb_chargeStation_id = 12 );

When I started the Oracle service today, I found that listener was unavailable. Use lsnrctl LSNRCTL> start Start tnslsnr: Please wait... TNSLSNR for 32-bit Windows: Version 11.1.0.6.0-Production The system parameter file is d: \ app \ qiao \

1. Glossary and conventions Table space: Provides the logical structure of the space used by the database. Its physical structure is a data file. A table space can contain multiple data files. Local table space management (LMT): a new table space

Question: Today, I receive a set of Database JOB exception alerts on the monitoring system. Here I will record the solution process and share it with you! Alert Log: Tue Dec 13 04:00:03 2011Errors in file/opt/Oracle/diag/rdbms/ndmcb/trace/ndmcb_j000_

1. Download tuxedo software tuxedo81_linux.bin. This software was initially installed on CentOS 5.5. Click here to enter the registration required for download. 1. Create a tuxedo user as the root user and log in as the tuxedo user. This user will