Oracle

Today, a bug was found in the data pump import operation. Database version Oracle 10203 for Solaris RAC, performing import statistics in the processing table The times wrong, the error message is: ORA-39083 and ORA-917. After careful investigation,

One, the database Management Section 1. Database replay (DB replay) This feature captures the load of the entire data and passes it on to a test database created from a backup or standby database, and then repeats the load to test the effect of

Sqlloader export Excel data to Oracle 1. Create Sql*loader input data required by the file, are saved to C:\, edited in Notepad: Control file: Input.ctl, the contents are as follows: Load data--1, control file identification InFile ' Test.txt '--

1, the concept of SQL Loader Import external data (such as text) data into Oracle database. (For data import, different types of database data migrations) 2, Sqlloader Import data principle: In paragraph (segment table) Insert record 1) Normal:

What is CPU/PSU The full name of the Oracle CPU is critical Patch Update, where Oracle releases a security patch package for each quarter of its products, usually to fix security risks in the product. The full name of the Oracle PSU is patch Set

Introduced: For 10GR2, it can be divided into several categories: Range (range) partition Hash (hash) partition List (lists) partition and combined partitions: Range-hash,range-list. Preparation environment: --1, building three table spaces

RMAN replication and the same machine copy operation procedures are the same, the difference is that we need to copy the backup files to the secondary library Experimental platform: REDHAT Linux 4.7 + Oracle 10g Target Library Information: Oracle_

Prepare to work before using Autotrace Create role plustrace sql>        @?/sqlplus/admin/plustrce.sql Assign the Plustrace role to users who want to perform autotrace sql>        grant plustrace to SST; ------------------ ----------------------

Data pump includes export table, export scheme, export table space, export database 4 ways. 1, EXPDP command parameters and instructions (1) ATTACH This option is used to establish an association between a client session and an existing export

Most of the time, because ASM does not start properly, data loss is caused. Here are two ways to retrieve data files from ASM I. Using the AMDU tool Amdu is a free tool in Oracle 11g that analyzes the metadata of the ASM Disk group and extracts

I had an interesting question today. Oracle users can tnsping, ordinary users tnsping error When you tnsping a database with a regular user tns-03505:failed to resolve name and tnsping the database with an Oracle user, you can ping it. tnsping

Case 5: --New table space is not backed up, datafile is corrupted 1) test environment 07:52:16 sql> Create tablespace LX 07:52:24 2 datafile '/u01/app/oracle/oradata/prod/lx01.dbf ' size 10m; Tablespace created. 07:52:38 sql> Conn Scott/tiger

Case 3: --All of the table space data files are lost, restore data files (open) 1) test environment 07:37:23 sql> INSERT INTO scott.test values (6); 1 row created. 07:39:18 sql> INSERT INTO scott.test values (7); 1 row created. 07:39:20 sql>

A partitioned index is a separate index on all of the zones, which is automatically maintained, which does not affect the use of other partitioned indexes of the index when a drop or truncate a partition, that is, the index does not fail, is easier

1. What is Audit Auditing (Audit) is used to monitor database operations performed by a user, and an audit record can exist in a data dictionary table called an Audit record: The SYS stored in the system tablespace. aud$ table, available through

SH file for full backup: exp_comp.sh rq= ' date + '%m%d ' SU-ORACLE-C "Exp System/manager full=y inctype=complete file=/oracle/export/db_comp$rq.dmp" SH file for cumulative backup: exp_cumu.sh rq= ' date + '%m%d ' SU-ORACLE-C "Exp

Database platform: SunOS 5.8 generic_108528-23 sun4u SPARC sunw,ultra-enterprise Database version: 8.1.5.0.0 Database symptoms: Database response is slow, application requests cannot be returned, business operations are stalled, and DBA

Oracle shutdown suddenly power off, resulting in the use of Sql/plus startup can not connect to the database, specifically described as: Connection can not be permitted, shut in progress. To the DOS prompt, type: C:\> Sqlplus/nolog Show:

I. Theoretical part The materialized view of Oracle is a database pair that includes a query result, which is a local copy of the remote data, or is used to generate a summary table based on the sum of the data tables. Materialized views store data

For local Users, insert permission is required only for INSERT permission, which is not sufficient for insert operations through the database chain. Looking at Oracle's admin manual is a problem that has not been noticed before. To see a specific