Database Administrator

ORA-600 [41XX] This error is basically related to UNDO. For more information about ORA-600 parameters, refer to my Blog: ORA-600 parameters description ORA-600 [4193] This error is also related to the UNDO, MOS has a few related articles. I. MOS

Microsoft SQL ServerMicrosoft SQL Server JDBC Driver (usually used to connect to SQLServer 2000) Driver package name: msbase. jar mssqlserver. jar msutil. jar Driver Class Name: com. microsoft. jdbc. sqlserver. SQLServerDriver Jdbc url: jdbc:

1. User-related processes User-related processes include user processes and server processes. A user process can be connected to only one server process However, in some Oracle configurations, multiple user processes can share the same server

1Create original table and Data SQL> create table t1 (id number, name varchar2 (20 )); Table created SQL> insert into t1 values (1, 'A '); 1 row inserted SQL> insert into t1 values (1, 'B '); 1 row inserted SQL> insert into t1 values (2, 'C '); 1

Create table test1 (id number, name varchar2 (20 ));Create table test2 (id number, name varchar2 (20 ));Create table test3 (id number, name varchar2 (20 )); 1. No commit is displayed in t1; Create or replace procedure t1AsBeginFor I in 1 .. 10000

Oracle SQL * plus is a client tool that interacts with oracle. In SQL * plus, you can run the SQL * plus command and the SQL * plus statement.The DML, DDL, and DCL statements we usually call are SQL * plus statements. After they are executed, they

1. Use rman to back up Oracle Data in the open state Rman backup must be in archive Mode Check whether the archive mode is used. SQL> archivelog list; Change to archive Mode Shutdown immediate Startup mount Alter database archivelog; (alter database

Oracle archive logs are certainly not unfamiliar to everyone. The following describes how to modify the size of Oracle archive logs, hoping to help you learn about Oracle archive logs. Method: Add a new large log file and delete the old small log

Prerequisites: You are advised to install the following software when installing Linux. Otherwise, you cannot pass the prerequisite check during Oracle installation. (The missing software can also be installed after the test, but the dependency

DSG RealSync database real-time replication software A new generation of real-time heterogeneous heat disaster recovery-Oracle Database IT systems have been running for a long time. On the one hand, their functions are getting greater and greater,

Set synonyms for ease of useSelect * from emp; and so on are used for select * from abc;Create a common synonymIf the user's level is not enough to establish a public synonym, You can authorize it under system:Grant create any synonym to scott;Grant

Try installing MongoDB on Ubuntu. Fortunately, you can use apt-get on Ubuntu. However, it is not the latest version! Sudo apt-get update Sudo apt-get install mongodb After the installation is complete, the Mongodb configuration file is placed

Oracle Forms provides six special system variables: $ DATE $ $ TIME $ $ DATETIME $ $ DBDATE $ $ DBTIME $ $ DBDATETIME $ Among them, $ DATE $, $ TIME $, $ DATETIME $ three system variables can be used to get users Client Operating SystemThe

I had to learn mysql for a month in my last job, and soon I forgot a lot of things. Now I want to learn more about sqlite because of my work,Data Types supported by Sqlite3 NULL,INTEGER,REAL,TEXT,BLOB And:Smallint is an integer of 16 bits.An integer

The mofei theorem verifies everything that exists, so the Oracle 11g installed on RedHat is hit. I was careful when installing the machine and did not dare to restart the machine (because it was my first installation, so I was particularly worried).

Oracle databases have three standard backup methods: Export/Import (EXP/IMP), hot backup, and cold backup. Exporting spare parts is a logical backup, while cold backup and hot backup are physical backup.1. Export/Import (Export/Import)The Export can

Oracle Database backup script under RedHat Linux 5 #! /Bin/shExport ORACLE_HOME =/app/oracle/product/10.2.0/db_1;Export ORACLE_SID = orcl;Export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.UTF8 ";Export F = $ (date + % y % m % d % H % M % S); # Use the

OracleOfSEssionsAndProcessesOfLink is Sessions = 1.1 * processes + 5 ----- Experiment part ---- Microsoft Windows [version 5.2.3790](C) Copyright 1985-2003 Microsoft Corp. C: \ Documents ents and Settings \ Administrator> sqlplus/nolog SQL * Plus:

1. Redis storage mechanism Redis storage mechanisms are divided into two types: Snapshot and AOF. Regardless of the Mechanism, Redis stores data in the memory. How Snapshot works: It stores data in the memory first, and then triggers a DUMP

Question: Collect Oracle knowledge points that are commonly used at work, constantly update and accumulate, and use them as your own notebook. Some keywords 1Is not null. Check whether the field is null. Select*FromT_user