Oracle recycle bin recyclebin

Oracle recycle bin recyclebin Racle10g Recycle Bin 1> what is Recycle Bin? In fact, Recycle Bin is only a data dictionary table that stores the drop object. Therefore, you can use the following statement to query information in the recycle

PostgreSQL module-pg_stat_statements detailed explanation and installation test

PostgreSQL module-pg_stat_statements detailed explanation and installation test In fact, it is very simple. Recently, postgresql may need to be monitored, so I have been exposed to many related monitoring commands and tools. This article mainly

Oracle case study ORA-01722 troubleshooting

Oracle case study ORA-01722 troubleshooting 1.1. ORA-01722 Date: Environment: test environment [Scenario description] During Database Upgrade, execute SQL> @? /Rdbms/admin/catupgrd. SQL script reports an error and exits. Install Oracle 11gR2 (x64)

Non-Oralce user environment variable configuration

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

DB2 database backup script in Linux

DB2 database backup script in Linux DB2 database backup script in Linux The script runs under the root user: The content of backupDB2Task. sh is as follows: Datedir = 'date + % Y-% m-% d'Delete_date = 'date + % Y-% m-% d -- date = '7 days

How to Create a tablespace in Oracle

How to Create a tablespace in Oracle Create a tablespace in Oracle CREATE [UNDO] TABLESPACE tablespace_name[DATAFILE datefile_spec1 [, datefile_spec2] ......[{Mininum extent integer [k | m]| BLOCKSIZE integer [k]| Logging clause | FORCE LOGGING|

INSTR and SUBSTR functions in Oracle

INSTR and SUBSTR functions in Oracle 1. INSTR Functions Syntax:Instr (string1, string2 [, start_position [, nth_appearance])Parameters:String1: Source string to be searched in this string.String2: string to be searched in string1.Start_position:

Oracle index Suppression

Oracle index Suppression Preface: in many cases of Oracle Database optimization, you can increase the database performance by adding indexes. However, in some cases, DBA cannot do anything about it, because all the indexes have been created, but the

Oracle 11gR2 RAC node crash Fault Analysis

Oracle 11gR2 RAC node crash Fault Analysis Environment: AIX 7100Oracle 11gR2 RACDetailed version: 11.2.0.4 Symptom:Node 2 crs hang is down. The CRSCTL command does not respond at all. After the CRS process host is restarted, the VIP is not migrated

Detailed description of ROWID in Oracle 10g

Detailed description of ROWID in Oracle 10g First use select * from v $ version; to query the current version of the Oracle database SQL> select * from v $ version; BANNER----------------------------------------------------------------Oracle

Dataguard primary database reported ORA-16146 error Solution

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:

Use adrci in Oracle 11g to view alert logs

Use adrci in Oracle 11g to view alert logs 1. Know adrci This command can view error messages and logs, which are provided to us along with the change of the 11g trace directory location. This tool can not only edit logs like vi. You can also view

Reconstruction after physical DG slave database corruption

Reconstruction after physical DG slave database corruption Because the data is rebuilt, the data files, log files, and dump files in the physical slave database that were rebuilt in the original DG Environment can be deleted. Remember that the

Handle irregular Oracle listening exceptions

Handle irregular Oracle listening exceptions Environment:Operating System: SunOS 5.10Database Version: Oracle RAC 11.2.0.3.0There are two databases on the host, with node 1 of a RAC located on the host, and another database. The reason why the

Enable audit for a table in Oracle (audit)

Enable audit for a table in Oracle (audit) Oracle databases enable standard auditing using the audit_trail Parameter Its Parameters include the following: NONE: Audit disabled OS: The audit information is summarized in the system. For Linux, the

Solution to Oracle 11g ORA-00119 ORA-00132

Solution to Oracle 11g ORA-00119 ORA-00132 When Oracle 11g is started in Linux, the following error is reported: ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00130: invalid listener address XIANGDE_LISTENER There are

Change the Oracle database connection Port

Change the Oracle database connection Port The default database listening and connection ports of Oracle databases are 1521, but sometimes the default ports need to be changed in the project. In this way, the customer requirements are usually based

In-depth Oracle RMAN backup analysis-online backup

In-depth Oracle RMAN backup analysis-online backup RMAN> backup database plus archivelog; This command will trigger the following operations: 1. The process uses the alter system archivelog current command to complete log switching. 2. The process

SQL Syntax of SQLite

SQL Syntax of SQLite The SQLite library can parse most standard SQL languages. However, it also saves some features and adds some new features. This document attempts to describe the SQL syntax that SQLite supports/does not support. View the keyword

Query and delete sessions in Oracle

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 #-------------------------------------------------

Total Pages: 1013 1 .... 473 474 475 476 477 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.