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,

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

As mentioned in introducing add values and drop values statements, add values and drop values are just changes in the data dictionary and do not involve changes in the data. Therefore, if the add values or drop values statements are executed, the

This article is the migration of the way to achieve the database 10g to 11g migration upgrades. First, the environment introduction 1. Source Database Environment Operating system version: OEL5.8 x64 Database version: 10.2.0.5 x64 Database SID

This process is called the parsing process in order to translate the SQL text written by the user into an Oracle-aware and executable statement. Parsing is divided into hard parsing and soft parsing. A SQL statement must be hard resolved the first

The internal management of the log buffer is divided into two parts, one being the build redo record and the other being the redo record writing to the online log file. These two parts are not isolated and unrelated. During the process of generating

The following code has been tested to run directly Oracle analysis functions, multidimensional functions and model functions are briefly described, mainly for the BI report statistics, not necessarily very comprehensive, but a little explanation of

After we have a datapump job, we can view the current progress through v$session_longops. Username-job owner opname-job name target_desc-job operation Sofar-megabytes transferred thus far Duri ng the job totalwork-estimated number of

Before you can create a logical repository, you must first create a physical repository, and for how to create a physical library, refer to the Data Guard series (4)-Creating a physical repository without stopping the main library. 1. Stop the Log

We sometimes have a demand that the database can help us do something regularly. For example, we want the database to be able to aggregate data from one table in the library, or from some tables, into another sheet on a regular basis. Then we can do

1, Table space: Table space is the logical division of the database, a table space belongs to only one database. Each table space consists of one or more data files. Data from other logical structures in the tablespace is stored in these data files.

1. View database Information Show parameter instance_name Show parameter Db_name Show Parameter Service_Name Select dbid from V$database; 2. Normal Shutdown database Sqlplus/as SYSDBA Sql>shutdown Immediate 3. Start database to mount mode

Dictionary Management table Space-DMT Local management table space-LMT The Dictionary Management table space (dictionary-managed tablespace, DMT), 8i previously includes a table space management model that can be used in the future, managing the

By using a database backup, the DBA can establish a replica database on the same server or other server. This replica database can have the same name (copy) as the primary database or be different from the primary database name (clone). Oracle's

1. Choose the appropriate Oracle Optimizer There are 3 Oracle optimizer types: A. Rule (rule-based) b. Cost (based on costs) c. CHOOSE (optional) Set the default optimizer to pass various declarations of optimizer_mode parameters in the Init.ora

REF cursor is the reference of the result set that we define on the server side. When we open a REF cursor, no data is returned to the client, instead, the address of the data on the server will be returned to the client. This allows the user to

I made a simple packaging class, the source code posted for your reference. This program is not rigorously tested and needs further refinement, and the code is tested through the xlc of Vs2005 and Aix. Note: If you need to link in vs2005, you will

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

ORA-00922 Missing or invalid option 0ra-00922: Missing or invalid option Cause an invalid option is specified in defining a column or storage clause. The valid option in specifying a, NOT NULL to specify, the column cannot contain any NULL values.

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