Database Administrator

Prerequisites for restoring a tablespace without backup: 1. Data from the tablespace creation time to the deletion time period must be archived. 2. The reason for the control file is that the tablespace is not damaged. SQL> connect

1) Preparations* FTP client software* Xmanager* Pl/SQL dev* 10gr2_db_sol [1]. cpio, database installer, applicable to SUN Solaris (iSCSI), Database Version 10.2. 2) create user groups and users1) Add a user group:Groupadd oinstallGroupadd dba2) Add

Package com. Oracle. ConnTest;Import java. SQL. Connection;Import java. SQL. DriverManager;Import java. SQL. ResultSet;Import java. SQL. SQLException;Import java. SQL. Statement;/*** Oracle connected to the bridge* @ Author jll*/Public class ResConn

Table type variables, also known as index_by tables or PL/SQL tables, are different from data tables and are similar to the two column structures of the keys and values of arrays. The syntax is as follows: Type table type name is table of type index

Oracle10g. A table similar to BIN $ nJ5JuP9cQmqPaArFei384g ==$ 0 will appear after you select and delete it in pl/SQL. 1. view the recycle bin Select * from user_recyclebin; 2. Clear the recycle bin Purge recyclebin; 3. Clear a table in the recycle

In Oracle 11g, in addition to following the RMAN retention policy, you can also use RMAN to configure the deletion policy for archiving logs, that is, when archiving logs can be deleted. The archive log deletion policy applies to all archiving

Ora-01102 error occurred when starting after Oracle database is installed.Oracle@r05a11016.yh.com:/home/oracle> sqlplus "/as sysdba"SQL * Plus: Release 11.2.0.2.0 Production on Fri Apr 15 16:17:39 2011Copyright (c) 1982,201 0, Oracle. All rights

Environment: OS: rhel 6.3 _ 64bit DB: Oracle 10gR2 Level switching process: Master Database SQL> select protection_mode, protection_level from v $ database; PROTECTION_MODE PROTECTION_LEVEL----------------------------------------MAXIMUM

Early in the morning, I found that all mysql files in the Data Directory had disappeared, and a cold sweat occurred. What happened !!??? Was hacked, or was mysql Data loss caused by restarting the server two days ago ??? What is the problem? go

When analyzing the performance of some statements, we will analyze some information. Such as tables, columns, indexes, and histograms. This article mainly describes the collection and analysis of statistical information of tables and columns.I.

An error is reported for a standby database of the database: ORA-00600: Internal error code, parameter: [kdoilsn1], [], [], [], [], [], [], [], [], [], [], [] According to the trace file, the SQL statement that reports an error is: select * from

Oracle archive mode and non-archive mode switch 1. Check whether oracle is in archive Mode Arichive log list; Database Log mode non-archive ModeDisable automatic archivingArchiving end point USE_DB_RECOVERY_FILE_DESTThe earliest online log sequence 6

Today, my colleague reported that the installation of the Oracle 11g client on RedHat 5.5 has been unsuccessful. For the error, see: View the specific error information as follows: Information: Build a client shared libraryInformation: Build a

In Oracle, when executing expdp or impdp, sometimes an error occurs: ORA-39002: invalid operation. ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at "SYS. UTL_FILE", line 536 ORA-29283: invalid file

The TRUCK_GPS_TRANS table uses the interval patition function of Oracle11 to automatically create partitions by day. Now, you need to delete the partition data from the past 30 days on a regular basis to keep the business data in the table for only 3

UNDO tablespace description In the previous article (RMAN backup and recovery for the loss of offline data files), we talked about how to deal with the loss of offline data files. This article describes how to solve the loss of UNDO tablespace. The

The Oracle execution plan storage outline corresponds to the SQL statement one by one. Therefore, if we change the predicate condition in the SQL statement, the storage outline will be ineffective or we need to create a new storage outline to

Count DML statements in MySQL binlog MASTER @ root @ test 07:44:52> create table tab02 (id int (10) primary key, name varchar (20 ));Query OK, 0 rows affected (0.10 sec)MASTER @ root @ test 08:34:54>MASTER @ root @ test 08:34:54>MASTER @ root @ test

In March January 2014, the database needs to be moved from the original storage platform to the new storage platform due to changes in the hardware environment. That is, change the underlying storage medium of the database. The following describes

Abstract: It mainly records the knowledge about Oracle stored procedure, from definition to use. Start with the simplest example and go deeper. At the same time, the use of ref cursor is combined later. By the way, I added how to use it in java.I.