Oracle

The Oracle parameter query command show parameter is a small trick. You can use fuzzy query. For example, if you want to query parameters that contain db _, you can use: SQL> show parameter db _; NAME TYPE VALUE --------------------------------------

In actual work, developers often accidentally delete an important table. At this time, they will find the Administrator to retrieve the deleted table. The specific scenarios are as follows:1. Developers:SQL> conn usr1/usr1Connected.SQL> create table

Cube is widely used in Oracle databases, especially when Cross reports are generated. OracleOLAP uses MView to refresh the cube.We created a cube using the Oracle database, and the data in the cube is only executed manually.Dbms_cube.build ('') is

In is equal to any member in the brackets, such as select * from dept where deptno in ('10', '20', '30', '40 ');Not in is not equal to any member in the brackets, such as select * from dept where deptno not in ('10', '20', '30', '40 ');Between A and

When we are working on database projects, there are only two principles to optimize the data store: one is Data Storage in blocks, which facilitates data dumping and discipline; the other is processing, the speed at which data is provided. This

In oracle/PLSQL, the substr functions allows you to extract a substring from a string. The syntax for the substr function is: Substr (string, start_position, [length])Note:String is the source string.Start_position is the position for extraction.

Cascading display of the drop-down list is a very common interface display effect. In FORMS, it is also very simple, but it is obviously a little troublesome in OAF...Assume that there is a table with two fields: Province and City ). You need to put

Import data from oracle10g to oracle9i Database   Generally, imp statements cannot be imported. Because the database versions are inconsistent, data can only be imported from a lower version to a later version. Otherwise, data cannot be imported.

1. SQL * Plus does not care about the case sensitivity of SQL commands. SQL * Plus is case sensitive only when detecting text values;2. All values in the varchar2 and char columns are characters, including 11 and 2. The values stored in these

[Oracle]-[v $ session] The SNIPED status of v $ session has just appeared in a test database recently. symptom: This status has never existed before: some applications (here deployed more than 100 applications, and are Tuxedo Persistent Database

Introduction to Oracle services in Windows: The Oracle service list of one node of RAC in 11gr2. Oracle does not need to start all services in the background when processing general transactions. Because the oracle service occupies a large amount of

After the server name is changed, crs cannot be started. Solution: DB: oracle 11.2.0.2OS: OEL Linux (OEL) 5.6 symptom: changed hostnamenjdyw-> restart 07. After restarting the server, the crs service cannot be started. [Oracle @ far 07 diag] $

The difference between a dedicated Oracle server and a shared server is that when you create an Oracle database, you should see this option in the database creation assistant wizard, that is, the connection mode of the database. There are two

Oracle Used to delete the DBF file to clear and drop all the tables, and the file was deleted. However, the actual DBF data file still exists under the ORADATA file. Must be deleted like this Drop tablespace tablespace_name [including contents [and

ORA-03113/03114 handle if the database does not set the correct OS core variable during installation, it may be okay when installing the database file, when creating a database, the error 03113 is often returned. Another reason for this is that the

Oracle monitoring indexes use Oracle to provide a monitoring index method to determine whether an index is used. If indexes are not used, you can delete them to reduce unnecessary statement overhead. Because a large number of unnecessary indexes on

The listener is not started or the database service is not registered with the listener solution oracle Encounters "the listener is not started or the database service is not registered with the listener" as follows: C: \ Users \ zhou> emca-repos

[One Moss per day]-[sequence]-continued-RAC and Sequences (853652.1) [one Moss per day]-RAC and Sequences (853652.1) http://www.bkjia.com/database/201308/239400.html what can be said of a simple sequence? If this is the case, it would be a big

The NUMBER type Rule Description of ORACLE in Oracle the Number type can be used to store 0, positive and negative fixed point or floating point NUMBER, the data range can be expressed in 1.0*10 (-130) -- 9. 9... 9*10 (125) {38 9 followed by 88 0}

How to restore the damaged undo tablespace (1) when the database is running in non-archive mode, it is normally disabled when the database is shut down. The undo tablespace is corrupted when the database is opened. The information is as