Oracle

  Software environment: 1. Windows 2003 Server + ORACLE9i 2. ORACLE installation path: C: \ ORACLE   Implementation Method: 1. Start-> Settings-> Control Panel-> management tools-> services Stop all Oracle services. 2. Start-> Program->

    Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up oracle data. The exp command can export data from the remote database server to the local dmp file, and the imp command can import the dmp file from the local

  Brief Introduction Two days ago, a servlet-based file upload page was developed for the project. Oracle Jserv was used on the front-end to process the servlet page on the Apache server. The file upload function was implemented based on

  In Oracle databases, the Database Control File maintains the global physical structure of the database to support successful database startup and operation. When creating a database, the corresponding database control file is also provided. During

Multiple ORA-01650 errors are reported when the Oracle temporary table cursor is not released, resulting in insufficient rollback segment space, causing the database to fail. This article mainly introduces the solution to this problem. Next let's

In Oracle Database Operations, if the remark01 field is added to the original table TB_HXL_USER, the default value is 'A'. However, because the data volume of the table is large, fields are directly added to the original table, the execution takes a

When you use win7 to install oracle10g, it is likely that the related oraparam is displayed. if you are unable to install oracle10g due to an ini-related exception, follow these steps. 1. First, find and open the "\ oracle 10g \ stage \ prereq \ db \

DML performance is low. One of the most serious causes is the existence of useless indexes. All SQL insert, update, and delete operations will become slower when they need to modify a large number of indexes when each row of data is changed.Many

1. syntax for creating a partition: Create table table_name (......) Partition by range (column_list) ( PARTITION partition_name values less than (values_list) TABLESPACE tablespace_name, ...... ) Table_name: Table name; Column_list: List of

Run the exp and imp commands to back up 11 GB of data. When importing 10 Gb of data, an error is thrown: the exported file is not valid, and the header verification fails. The import is not terminated successfully. Today, I encountered this

Create a temporary table: XXX_TEMP_FILESThe table creation statement is:Create table XXX_TEMP_FILES (FILE_ID NUMBER,Seq number,TEXT VARCHAR2 (2000 ),CREATION_DATE DATE)The purpose of creating this table is to extract the data from the file_data

I. IntroductionMaterialized View, as its name implies, is a physical view that is actually stored on the hard disk. query performance is better than normal views. Ii. materialized view principle:1. generate dataTwo major options: build immediate

I have prepared an article about using database cold backup to create physical standby. The cold backup of the database needs to be stopped, and it is not practical in the production environment, this section describes how to use rman for Hot

Redogap is generated when the redo transmission is interrupted.Generally, when the redo transmission service is restored, oracle automatically checks the gap and solves it by itself. The time required to fix the gap depends on the gap size and the

Archive log is fullORA-00257: How to Handle archiver error. Connect internal only, until freed error1. Log On with the sys userSqlplus sys/pass @ tt as sysdba2. Check the location of the archiv log.SQL> show parameter log_archive_dest;NAME TYPE

Common Oracle tablespace operations -- Create a tablespace create tablespace test datafile 'e: \ test2_data.dbf 'SIZE 20 M autoextendon next 5 Mmaxsize 5000 M; -- View tablespace Information select tablespace_name, file_name FROM dba_data_files

Small and Medium databases rman catalog Backup recovery solution (1) Oracle databases are usually the first choice for large databases and large enterprises for database stability, high availability, cross-platform and massive database processing.

[Oracle]-[Create index]-How to create an index and some experiences 1. Read the data of the index key to the cache. If the data is not read to the database Cache, there may be a DB file scatter read write wait event. 2. Sort the data of the index

Sqlplus hidden key combination SQLPlus at the SQL * Plus command line prompt on UNIX/Linux platforms, If you mistakenly press the key combination: Ctrl + S, the session will be locked, no command is displayed. Unlock the combination key: Ctrl + Q

Oracle function development 1. syntax for creating a FUNCTION: CREATE [or replace] FUNCTION name [(arg1 [mode] datatype [, ......])] -- When the parameter data type is specified, its length cannot be specified. Mode Value: IN, OUT, and in out. If