Oracle

According to Oracle's documentation, the data pump in different ways to export imports, performance can be significantly different, this time just have the opportunity to test, migration table space, direct path, external table, and database chain

In the document, the partition's locking operation is performed before performing some operations on the interval partition. Unlike other types of partitioned tables, the partition of the interval partition table does not necessarily exist, and

Prior to Oracle 11g, the database needed to be in the Mount state when the physical repository (physical Standby) applied Redo. Starting from 11g, when applying redo, physical repositories can be in read-only mode, which is called Active Data Guard,

1. Simulate generating data source --Create a script Emp.sql "many of these formats will change, and then remember to execute another script to restore the original On.sql" [Oracle@work sqlldr]$ more Emp.sql Set Heading off Set Feedback off Set

ODBC or PowerBuilder's own DB profile or private interface to the database, but there are still many users who are unable to connect to the database by this method, which may be the cause of PowerBuilder itself, For example, the option to install

Recently used Statspack on a customer's 8i production library and found an error in alert: Mon June 16 13:17:52 2014 Errors in FILE/ORACLE/8.1.7/ADMIN/PROD/BDUMP/SNP0_96626_PROD.TRC: Ora-12012:error on Auto execute of Job 304 Ora-01631:max #

High water level concept: All Oracle segments (segments, here, in order to understand the convenience, it is recommended that segment as a synonym for the table) has a cap to accommodate the data in the paragraph, we call this cap "high water mark"

1. Table structure Sql> desc v$sort_usage is the name empty? Type ----------------------------------------- -------- ---------------------------- USERNAME VARCHAR2 (30) USER VARCHAR2 (30) Session_addr RAW (8) Session_num number Sqladdr RAW (8

Select E.tsname, substr (E.filename, 1,) filename, E.PHYRDS-NVL (b.phyrds, 0) reads, (e.phy RDS-NVL (b.phyrds, 0))/(SELECT EXTRACT (Day from E.end_interval_time-b.end_interval_time) * 86400 + EXTRACT (HOUR from E.end_interval_time-b.

-----The growth of the database in the last seven days, this is only an estimate. Select SUM (space_used_total)/1024/1024/1024 "Last 7 days DB increase-g" From Dba_hist_seg_stat S, Dba_hist_seg_stat_obj O, Dba_hist_snapshot SN where s.obj# =

Oracle 9i can configure a number of parameters such as channels, backup retention policies, and so on, can be used more than once, and the information in the settings does not affect the reset in the script. RMAN default configuration parameters,

Yesterday a friend asked me how to monitor the operation of a pl/sql, here is a brief introduction to several methods. Introduce a professional Dbms_application_info package. The previous article introduced a solution through inserts and

Today a storage program complains sql*loader-00510 physical record in data file (string) is longer than the maximum (number) It was obviously caused by Sqlloader. The Official document explains the following Cause:the DataFile has a physical

Today, the test found a stored procedure executing the report ORA-01745: Invalid host/bound variable name error The error statement is the delete tbl_temp_01system where writetime >: sysdate The reason for this error is: sysdate This binding

Related commands The main use of the article three commands, here to introduce a separate: Export: Back up the data in the database into a binary system file, it has three modes: User mode, table mode, entire database schema. can also be divided

Objective The growing demand for distributed applications requires a better distributed software environment, which drives the development of distributed technology. Oracle data replication is a technology for implementing distributed data

(1) Write hot backup script (double spool) Set feedback off pagesize 0 heading off verify off Linesize-Trimspool on echo off Define bakdir= '/disk1/backup/anny/hot_bak ' Define bakscp= '/disk1/backup/anny/hot_cmd.sql ' Define spo= '

Oracle's BLOB field type can be used to hold long 2 of data. But the code that reads and writes the BLOB field data is usually verbose, and it's easy to make mistakes when it's not carefully coded. I integrate this feature into my OCI packaging

First, the preparation before installation:First here to give my Baidu network disk link: Http://pan.baidu.com/s/1c1WF1PQ; fast speed of the small partners suggested to the official website: http://www.oracle.com/technetwork/database/

Ylbtech-oracle:oracle simple backup and restore-import and export Oracle is safe to operate without a good backup and recovery mechanism because we are not DBAs. So we don't talk too much about DBAs ' backup and recovery. As programmer