Oracle

Installing Oracle on RHEL requires some necessary packages, such as binutils compat-db compat-libstdc++-33 control-center gcc gcc-c++ glibc, and so on. If one of the outfit, really very troublesome, fortunately with Yum and oracle-validated: 1

Create or Replace procedure Tj_data is--variable v_tablename VARCHAR2 for the current stored procedure ; V_sql varchar2 (); V_count integer; --Gets all the tables in the current database CURSOR Table_loop is SELECT table_name from

Four ways to start Oracle databases 1, Startup Nomount Non-installation startup: This way to launch executable: Rebuild the control file, rebuild the database, start the instance, that is, start the SGA and background processes, this startup

1, the creation and description of the sequence To create a sequence, the syntax format for the Oracle sequence is:CREATE SEQUENCE sequence Name[INCREMENT by N][START with N][{Maxvalue/minvalue n| Nomaxvalue}][{cycle| Nocycle}][{CACHE n| NoCache}]; 1

In the day-to-day process of dealing with Oracle databases, you may encounter a situation in which a non-SYS or system segment is built in the system tablespace. For a long time, as the volume of data surges, the database will become more and more

--oracle exception return complete information, see finally attached--Of course, it's best to select the returned information, along with other relevant information about the code--such as the occurrence of object name, time, etc. insert pre-built

To create a process script for a package declaration: CREATE OR REPLACE PACKAGE "Com_bos" is-------------------------------------------------------------------------Description: --Constructing SQL statements of type B

1. See which stored procedure is lockedCheck V$db_object_cache ViewSELECT * from V$db_object_cache where owner= ' the owning user ' and locks!= ' 0 ' 2. See which SID, through the SID, can tell which sessionCheck v$access ViewSELECT * from v$access

See an article on the online Oracle cold backup, very detailed: First, cold backup The process by which the database completes copies of all physical system files in the shutdown state, also known as offline backup Suitable for non-archive mode,

sqlplus into the database Export write commands directly at the command Line 1. Export your own table   exp userid=scott/tiger@myoral tables= (emp,dept) file=/opt/e1.dmp   2. Export tables for other scenarios If users want to export tables for

1. System Rights Management1.1 3 Default UsersOracle 9iSYS Change_on_install [as Sysdba]--sqlplus/as sysdbaSystem ManagerScott TrigerOracle 10g aboveSYS Setup when it is installed. [As SYSDBA]Setup when system is installed.Scott Triger is locked by

Sometimes you want to delete an Oracle user and rebuild it, but the user will not be able to delete it if the user still has a client to keep the connection. At this time we need to find the user connection Sid and serial#, use the relevant command

1. View Oracle Max Connection numberSql>show parameter Processes #最大连接数2. Modify the maximum number of connectionsSql>alter system set Processes=value Scope=spfileRestart the databaseSql>shutdown ForceSql>start Force3. View the current number of

There are several reasons for ORA-01034 and ORA-27101 errors: 1. The main Oracle current service is not available, shared memory realm does not exist, because Oracle is not started or does not start properly, share memory is not assigned to the

in development, we may have deadlocks when manipulating the database, and if we don't want to wait, this requires us to manually kill the process. Oracle View Lock Table SELECT l.session_id Sid, S.serial#,

  Software Environment Windows oracle9i  + hardware environment CPU 1.8G + RAM 512M   Now we have 2 tables   as follows: t1--large table 10000 strokes  t1_fk_id T 2--Small Table 5000    t2_pk_id T1 by the field ID in the table and T2 the primary key

1. Log in with SYS user Sqlplus Sys/pass@tt as Sysdba 2. Look at the location of Archiv log Sql> Show parameter log_archive_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ Log_archive_dest

Several ways in which a function/procedure in Oracle Returns a result set: In the case of function return, the stored procedure can only be changed to out parameters and passed in the Oracle 10g test. (1) Return cursor: The return type is:

  Oracle Data Source Configuration   Prerequisites: Jboss_home=jboss's home directory (installation directory) has the Jndi name of the test Jboss4.2.0-ga version data source is oracleds   Oracle data source with password code is configured

  1.  explains the differences between cold and hot backups and their benefits    answers: Hot-backed databases for archive mode, backed up while the database is still working. A cold backup is a database that is backed up after the database is