Oracle

Oracle's ALTER TABLE Drop COL is specifically internal to the data storage block operation, and if a tool such as Dul is recoverable after the drop COL, I will illustrate the problem with a specific test, combined with bbed,dump block. 1. Create a

In some cases, because it is the C/s architecture, from the previous stand-alone system to the current 11.2 of the RAC, if the client IP address to modify the workload is too large, but also unrealistic, generally recommended directly modify the

System environment: 1, operating system: Windows 2000 2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition 3, Installation path: c:oracle Access method: 1, connect into the Sql*plus Log in as a System/manager user, Sql> Conn

Sqlplus /as SYSDBA --View DBF storage locationSELECT * from Dba_data_files; --View File location SELECT * from Dba_directories;--New Table spaceCreate tablespace bp_oracle logging datafile '/u02/oradata/devdb/bp_oracle.dbf ' size 100m autoextend

Today, when you create a view of a table, users are prompted to ORA-01031 user rights, insufficient privileges. You still cannot create a view by using the system user to assign permissions such as DBA. Create a View The code is as

Oracle creates table spaces and users Oracle Learning for beginners like me, or to step by step, first of all to understand the basic concepts. I think Oracle learning can be divided into several parts:Basic system usageSystem tuningSQL statement

1, download Oracle 11g R2 for Windows version Download Address: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html This includes two compressed packages:

A stored procedureFirst, we set up a simple table for the test of stored procedures The code is as follows Copy Code CreateTableXuesheng (ID integer, xing_ming varchar2 (), Yu_wen number, shu_xue number);Insertinto

The customer's database has tools to log in to an Oracle database during transfers occasionally ORA-04031, after analysis because the tool needs to query v$session, which is identified as a bug 12808696–shared pool memory leak of " Hng:all Sessi

Recently a friend database abnormal, consulting me, through the analysis log found that the other people do not understand the bare devices in Aix and Oracle database and then directly use the OEM to create a new table space, resulting in database

A simple case expression that uses an expression to determine the return value. Grammar: The code is as follows Copy Code Case Search_expressionWhen Expression1 THEN RESULT1When Expression2 THEN result2...When

A, DELETE statement (1) Conditional deletion Syntax format: delete [from] table_name [where condition]; For example: Delete data from the users Table of UserID ' 001 ': Delete from users where userid= ' 001 '; (2) Unconditionally delete the

First, when using Oracle's to_date function to do date conversion, many Java programmers may directly use the format of "Yyyy-mm-dd HH:mm:ss" as a format for conversion, but will cause errors in Oracle: "ORA 01810 The format code appears two times.

Recover deleted data First, create the simulation environment The code is as follows Copy Code Sql> CREATE TABLE Hr.xifenfei (ID number,name varchar2) tablespace xff; Table created. sql> INSERT INTO Hr.xifenfei values (1

Customer feedback system Hang live, can not be archived, we need urgent intervention analysisNode 1st logRedo cannot be archived, redo logs have been filled, and the database has been manually executing alter SYSTEM ARCHIVE log current, but the

The exception is as follows: Java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDriverAt Java.net.urlclassloader$1.run (urlclassloader.java:200)At Java.security.AccessController.doPrivileged (Native method)At Java.net.URLClassLoader.findClass

Oracle does not support limit similar to MySQL. But you can still rownum to limit the number of rows returned by the result set. If you only want to return the first 10 lines of records, you can write this: SELECT * FROM table WHERE rownumBut the

Customer has a 11g active Dataguard library, the MRP process stopped, see Alertlog, you can see the error about Ora-7445[kdxlin]: Cat Alert*.log .... Exception [Type:sigseov,address not mapped to object] [ADDR:0XC] | Pc:0x96504c7,kdxlin () +415

Make a script sprpt_batch.sh:Read lineSnap_ I _id = $1End_snap = $2 Sqlplus-s/nolog Conn/as sysdba;Define begin_snap =$ {snap_ I _id };Define end_snap =$ {end_snap };Define report_name1_sprpt_batch_1_snap_ I _id1__1_end_snap1_.txtSet echo offSet

ASP (Active Server Pages) is one of Microsoft's tools for developing Internet applications. It is similar to HTML (HypertextMarkup Language (Hypertext Markup Language), Script and CGI (Common Gateway Interface Universal Gateway Interface)