Database Administrator

MySQL batch processing SQL statement MySQL supports batch processing to execute a batch of SQL statements. The following example shows how MySQL executes SQL statements in windows batch processing. Create table test (id int, name varchar (20

SPFILE causes Oracle Database startup failure After the server is powered off and restarted, it is reported that Oracle Database Service cannot be started, on the server to use as sysdba login to connect to a null instance, use startup times 'ora-24

How to log on to and connect to the target database using RMAN How to log on to and connect to the target database using RMAN I. Method 1: A) [Oracle @ odd-oelr4u8 ~] $ Rman target sys/oracle @ PROD1521 catalog catalog_admin/catalog_admin @ PROD21521

After MySQL is installed, only the following hosts are recognized: localhost and 127.0.0.1. The only hosts recognized after MySQL is installed are localhost and 127.0.0.1. If you want to allow the IP address on your machine to log on normally, there

Oracle uses with as and hint materialize to optimize SQL to solve low FILTER efficiency During project creation, a page uses SQL statements similar to the following to query data, I replaced the table name and field in the project with the system

Common Oracle system queries 1. query all objects in the system Select owner, OBJECT_NAME, OBJECT_TYPE, CREATED, LAST_DDL_TIME, TIMESTAMP, STATUS FROM DBA_OBJECTS where owner = UPPER ('Scott ') 2. view all tables in the system Select owner,

Adjusting the size of Oracle sga causes ORA-00851 and ORA-00844 errors Today, I adjusted the size of Oracle sga. the following error is returned when I restart the database.SQL> alter system set sga_max_size = 1024 M scope = spfile;SQL> shutdown

Detailed description of the installation process of Oracle 11g Database in Linux Oracle11g database installation specification in LinuxI. Instructions on downloading Database Installation Software (including patches) How to install software in

How to query the values of Oracle hidden Parameters What are hidden parameters? Is used in the system, but Oracle does not officially announce the parameters, these parameters may be those that are not yet mature or used in system development. Log

Error Log enabling in insert and Analysis In normal work, sometimes a batch of data needs to be inserted, which may be temporary tables, external tables, common tables, subqueries, and other forms, similar to the following formatInsert into xxxx

Oracle exp imp backup and recovery of table space data Oracle backup is divided into logical backup and physical backup. Logical backup is exp/imp; physical backup includes cold backup, hot backup, and RMAN backup. Exp/imp has three modes: Table

Oracle online redefinition table based on dbms_redefinition Oracle supports online redefinition of tables. That is to say, we can perform related DQL and DML operations while modifying the table structure (DDL), so that the front-end DML does not

Solution to TNS-01190 errors Because the listener originally uses port 1532 and is now changed to 1521, the listener cannot be started and is started. Therefore, an error is reported when the listener is stopped.The TNS-01190: the user is not

Oracle current_date and sysdate time are inconsistent Some time ago, it was found that the operating system time of a newly loaded Rac database was incorrect. When dbtimezone was queried, it was found to be-, indicating that the time zone was

[Translated from mos] explanation of the account_status column in The dba_users view, dbausers Description of the account_status column in The dba_users View Reference Original:How to Interpret the ACCOUNT_STATUS Column in DBA_USERS (Doc ID 260111.1)

After running utlpwdmg. SQL, ORA-28003, ORA-20001, ORA-20002, ORA-20003 error, ora20002 ORA-28003, ORA-20001, ORA-20002, ORA-20003, ORA-20004 error reported after running utlpwdmg. SQL. Applicable:Oracle Server-Enterprise Edition-Version 8.1.7.0 and

Enq: SQ, enqsq -- Execution per minuteSQL> select SQL _id, mi, count (mi)2 from (select event, SQL _id, to_char (sample_time, 'yyyymmdd hh24mi ') mi --,3 -- session_id4 from dba_hist_active_sess_history5 where SQL _id = '7wxfw53bsmgpq'6 and

ORA-19527 and ORA-00312 error resolution examples for 10g DG, ora-19527ora-00312 In the past few days, we have set up a 10g DG Windows 2008 R2 testing environment, mainly to re-build a production database DG for a customer tomorrow. Some problems

Oracle GoldenGate (hereinafter referred to as ogg) synchronizes data between databases of the same type on Heterogeneous OS ., Goldengateogg Oracle GoldenGate (hereinafter referred to as ogg) synchronizes data between databases of the same type on

Common Oracle modification statements and oracle modification statementsI. Table Test Table: MY_TEST_TABLE -- Create tablecreate table MY_TEST_TABLE( A VARCHAR2(30), B NUMBER(10) default 1, C DATE)tablespace BOSSWG_CFG pctfree 10 initrans 1