Oracle

An old test AIX server, which no one has ever adjusted, has recently seen Oracle Flash-back full. Cleaned up. Version:oracle 10GR2 for AIX Phenomenon: ? 1 2 3 4 5 6 7 sql> ALTER DATABASE open; ALTER DATABASE open * ERROR at line 1

Oracle stored procedures are typically compiled into test records that are compiled locally. Test table: ? 1 2 3 4 5 6 7 sql> CREATE TABLE T1 (RID number);    Table created sql> CREATE TABLE t_n (RID number); Table created

The phenomenon is that the system can not log in, no user can not, suspected that the database has problems, into the server, run Sqlplus Username/password, unable to enter the database, prompted to enter the user name. Restart the database, report

To implement data synchronization in this way by insert into the table data in the current library table Select Remote Library, the Oracle service is configured, and both remote and local services are Oracle Insert data in the current library?

It is appropriate to use this statement when you frequently encounter the insertion of data into several different tables during Oracle operations. All represents a non-short-circuit operation, that is, if the first condition is met, and a check is

1. The origin of the problem When the Oracle database field value is less than 1 decimal, processing with the char type loses 0 of the preceding decimal point For example, 0.35 becomes. 35 2. Solution: Format digital display with To_char function

Oracle offers a number of ways to reduce the time spent parsing Oracle SQL expressions, which can drag down the system's performance when performing complex queries with a large number of execution plans. Now let's take a brief look at several of

In peacetime development, we often encounter data tables in the duplication of data, then how to solve it? Here are two cases of data-weight method, one, complete duplication of data to weight, two, part of the field data duplication to heavy. A

Oracle can be equipped with more than one database, and only need to open a listener on it, for multiple databases as long as the appropriate service name can be configured to connect. I'm using Oracle 8.1.7 Enterprise edition,os is Windows Server,

How do you determine in Oracle how many tables in this table have foreign key associations with them? We are mainly divided into two steps: First step: PRIMARY KEY constraint name for query table SELECT * from User_constraints e where

When you create a database, all foreign keys do not have cascading deletions to prevent others from accidentally deleting the operation. Do not know when oneself into a batch of wrong data in, warehousing use is the software automatically, a bit

Yesterday, the server a disk unexpected failure, c disk data loss, reinstall the operating system, completely restore the data before the unexpected method: After reinstalling Oracle completely according to the original configuration (installation

One, close the database [Oracle@rhel5] $sqlplus/as sysdba Sql>shutdown immediate; Second, close the monitoring [Oracle@rhel5] $lsnrctl stop Iii. deletion of Oracle_base I'm switching to root here. [Root@rhel5] #rm-rf/s01 Iii. Clearance of

When monitoring, diagnosing and dealing with database performance problems, time information is often a very important basis for judgment. Sometimes we might use some scale to judge performance, but using scale rather than time tends to lead us in

Create statistics for a grouped column --Check table structure SELECT * from Scott.emp where 1=2; --Creating a virtual column will output the virtual column name Select Dbms_stats.create_extended_stats (' Scott ', ' emp ', ' (empno,job) ') from

Object permissions Select owner, TABLE_NAME, Grantor, Privilege, Grantable, Hierarchy, ' TABLE '/*o.*/object_type From Dba_tab_privs P where p.grantee = ' HR ' Order by P.owner, P.table_name; Role Select Granted_role, Admin_option,

1. The following statements are used to query which objects are locked: The code is as follows Select object_name,machine,s.sid,s.serial#From V$locked_object l,dba_objects O, v$session swhere l.object_id = o.object_id

Database versionOracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bitTest codeDeclareP_cur sys_refcursor; V_ename varchar2(); Procedure pro_1(p_cur outsys_refcursor) as Begin--Sub-Program 1Open p_cur forSelect ename from

Index Establishment Principles Determine whether the operation against the table is a large number of query operations or a large number of additions and deletions. Try to build an index to help a particular query. Check your own SQL

A total of 7 services, the meaning of these seven services are:1. Oracle ORCL VSS Writer service:oracle Volume Mapping copy write service, VSS (Volume Shadow Copy service) enables the creation of high-fidelity point-in-time images for storage