Oracle

Oracle Database lock tables and unlock processes in Oracle Database Operations, we sometimes use lock table queries, unlock and kill processes, and so on. How can these operations be implemented? This article mainly introduces this part. The lock

Oracle violation protocol OALL8 is inconsistent Cause Analysis ERROR-util.JDBCExceptionReporter>: Violation protocol ERROR-util.JDBCExceptionReporter>: OALL8 is inconsistent! I have been entangled in this problem for a long time recently. Yesterday

Table A modifies table B's data function. Today, the calculation data error is caused by the problem of the original project method. Now, you need to change the previous data. The table to be changed is as follows: table A (trainee training info

Create a new user simple edition for the database in Suse Linux. first, you need the root permission to log on to the database, sqlplus sys/sys @ oracle_ip 2. create user username identified by password. now, log out of the root user and use sqlplus

The question mark is displayed in SQLPLUS. in linux, the question mark is displayed in sqlplus, as shown below: [oracle @ why-server ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.1.0 Production on Wed May 15 16:20:03 2013 Copyright (c) 1982,200 9

To completely delete oracle11g, follow these steps: 1. Start> set> Control Panel> Administrative Tools> stop all Oracle services. 2. Start-> Program-> Oracle-OraHome81-> Oracle Installation Products-> Universal Installer, and click "Uninstall

About the migration of ocr votedisk environment in rac: hpunixoracle rac 11.2.0.3 Problem description: Due to user error operations, put ocr and votedisk in + GRID. Now we need to migrate it to + OCR_VOTE: solution: the specific operation is as

In the Product detail split project, the Schema and User in Oracle need to split the original Product table into two tables: Product and Product_detail. The database creates a Schema named alibaba1949. I do not know about the schema, but I have also

SQL converts datetime to a string and truncates the string select sr_child as 'child name', sr_parents as 'parent name', ss_updatetime as 'allocation time', left (ss_updatetime, CHARINDEX ('', ss_updatetime)-1), SUBSTRING (CONVERT (CHAR (19),

Let us clean and thoroughly uninstall Oracle is divided into three steps 1. uninstall the main program 2. deletion of residual files 3. registry cleanup 1. to uninstall the main program, you only need to run Oracle OraDB11g_home1 --> Oracle

Oracle initialization or shutdown in progress solution this year has been testing server migration issues, constantly creating tablespaces, creating databases, and creating users. After that, I thought that creating so many things would take up too

Oracle interview Summary 1. The relational tablespace describing tablespace and datafile is a logical component of the database. Physically, the database data is stored in the data file. Logically, the database is stored in the tablespace, which is

SQL code select SPEC_CODE, item_number, self_item_code, MASTER_FLG, update_date from writable where user_cd = '20170101' and xfimconv (self_item_code) = xfimconv ('a999 ') order by update_date desc; execution result: SQL code SPEC_CODE ITEM_NUMBER

Introduction to various background processes in oracle background processes are used to execute the actual maintenance tasks required to ensure database operation. For example, a background process maintains the buffer cache and writes blocks to

Weka connects to the Oracle database Weka to provide the function of connecting to the database. This article only illustrates how to set up the connection to Oracle. 1. Download the Oracle database driver jar package, usually ojdbc14.jar or oracle-1

Summary of oracle beginner knowledge points 1. dba, sysdba, and sysoper are different roles. roles can include system permissions, object permissions, and roles. dba does not include sysdba and sysoper permissions. sysdba and sysoper are two types

ORA-55622: DML, ALTER and create unique index operations are not allowed on table execute statement: delete tablespace reports error, drop tablespace name error symptom: ORA-55622: DML, ALTER and create unique index operations are not allowed on

Oracle physical and logical structure overview statement: Version 11gR2, CentOS5.81 physical structure (File) main performance impact on IO (1) controlfile [SQL] select * from v $ controlfile (2) datafile [SQL] select * from dba_data_files (3) redo (

Files managed by OMF will be automatically deleted by experienced DBAs. When you drop tablespace, data files will not be deleted without the words including contents and datafiles, during the demonstration on Sunday last week, when you drop

Solution to Oracle failure of conditional check during installation [java] installation environment: Win7-64bit Professional Edition, 6 GB memory, enough disk space to install version: Oracle Database 11G Release 2 (11.2.0.1.0) for Microsoft Windows