Oracle

Starting from 10 Gb, oracle began to provide Shrink commands. If our tablespace supports automatic segment space management (ASSM), we can use this feature to narrow down the segment, that is, reduce the HWM. Here we need to emphasize that this new 1

Handle bare devices on Unix systems: 1. What is a bare device? A bare device, also called a raw partition, is a special character device that is not formatted and not read by Unix through a file system. It is read and written by the application. It

This article describes how to install patches using the oracle opatch tool, and describes the general steps to confirm the BUG: analyze and troubleshoot relevant error information, compare the environment, and final confirmation.Keywords: ORACLE,

Create a dblink in oracle9i or 10g to point to an oracle11g database. After the user name and password are configured, the test will throw the following error code: ORA-01017: invalid username/password; logon deniedORA-02063: preceding line from

Dblink between database versionsServer VersionClient 11.1.0 10.2.0 10.1.0 9.2.0 9.0.1 8.1.7 8.1.6 8.1.5 8.0.6 8.0.5 7.3.411.1.0 Yes #6 Yes #6 ES #5 No #3 No #3 No #3 No #3 No #3 No #310.2.0 Yes #6 Yes ES #5 No Was No #3 No #3 No #3 No #3 No #310.1.0

[Oracle]-[synonym]-public and non-public synonyms [Symptom]: The Sys account creates a public synonym for the t_emp table of the bisal account. The bisal user can access t_emp_syn, but the scott account cannot query, select... t_emp_syn indicates

"Oracle Universal Installer has detected that there are processes running solve today's case: When AIX6 upgrades 10.2.0.5 at 10.2.0.1, the oracle Universal Installer has detected that there are processes running in the currently seleted oracle Home.

All about Oracle User-Managed Database Backups The V $ BACKUP view is most useful when the database is open. it is also useful immediately after an instance failure because it shows the backup status of the files at the time of the failure. use this

PL/SQL "ORA-14551: cannot perform DML operations in queries" solved the environment Oracle 11.2.0 + SQL Plus problem by writing a function according to the following requirements. in the emp table, the total number of employees whose salaries are

Oracle Data Guard (RAC + DG) archive deletion policy 1. Data Guard master database archive deletion policy: When we set: RMAN> configure archivelog deletion policy to applied on standby; in Maximum Availability and Maximum Performance, when RMAN

Use PLSQL Developer to remotely log on to oracle, and web management to log on to PLSQL Developer only after installation, you can access the local oracle, but there are some problems in accessing the remote server oracle or the oracle of the

Oracle operating system identity authentication using lelogin Database Remote Login authenticationossqlnet. authentication_services = (CNT), in $ ORACLE_HOME/network/admin/sqlnet. in ora, the operating system is windows or all. operating system

Here we only talk about hints-Based oracle Optimization solutions. In fact, Oracle optimizer has two Optimization methods Based on Rules (Rule-Based Optimization, RBO for short) cost-Based Optimization (CBO) Hints is a mechanism provided by oracle

This article will introduce you to your experience. When using ipve, rac hang is suspended due to the mistaken killing process, next, I will analyze the cause and provide a reference for the solution. If the customer feedback system hang is in place

When importing data using impdp today (converting schema in the same database ),ORA-39083: Object type TYPE failed to create with error:ORA-02304: invalid object identifier literalThe specific error SQL statement is CREATE TYPE "xx". "xxxxx" OID '1j3

The Oracle optimizer evaluates the expression whenever possible and converts a specific syntax structure to an equivalent structure. The reason for doing this is: · Either the result expression can be faster than the source expression. · Either the

Recently, when Browsing BBS, we often see "in a hurry! How to start OMS ?" To address these problems, I want to share some of my experiences with you. To enable OEM or OMS properly, there are two key points: 1. Whether the Oracle system service is

Anyone who has used Oracle databases knows that the speed and efficiency of Oracle databases are among the best among similar databases, especially when accessing a large amount of data. So what is Oracle Database implemented? I will use a series of

☆Retrieve all table names and column names of the databaseSelect name from sysobjects where xtype = 'U'Select name from syscolumns where id = (select max (id) from sysobjects where xtype = 'U' and name = 'table name ')☆Recursive Data QueryRecursive

I. Preface:After a period of storage process development, I wrote some summary and experiences during development and shared them with you, hoping to help you.Ii. target readers:Database developers, who have a large amount of data in the database,