Oracle

The failure of Oracle user connection makes us a headache. The following describes how to solve the failure of Oracle user connection and hopes to help you learn about Oracle user connection. After installing oracle11g, I want to enable the

Recently, a Java client was used in the project to pass an array of objects to the Oracle Stored Procedure for large data volume insertion, such as 0.1 million levels.The following is an example of inserting 0.1 million records. For ease of

Transferred from: bytes. In 9ir2 and earlier versions, only one inherent data type suitable for storing numeric data is supported. After 10 Gb, two new numeric types are available, native floating-point data types are introduced: binary_float

1, error: ORA-12560: TNS: protocol adapter Error Listener is not started. Start listener: LSNRCTL start on the server where the database is located. 2, error: ORA-01033: Oracle initialization or shutdown in progress Oracle is not in the open

1. Create a test table and data first,Create Table EMPSelect level empl_id,(Mod (rownum, 20) + 1) dept_id,Substr (dbms_random.string ('x', dbms_random.value (20, 50), 0, 10) empname,Trunc (dbms_random.value (1000,500 000), 2) salary,Decode (round

The following table lists the types of locks added to the table and the compatibility between the locks and other types of operations. Table 13-3 Summary of table locks SQL statement Mode of table lock Lock modes permitted?

In Oracle, how does the following script map all objects owned by a user, tables, sequence, and procedure... Delete all.   1. Drop object method. Delete all foreign key constraints first.   Declare Type cst_table_list is table of varchar2 (40 );Type

Document directory Environment:  Beginner notes environment: Vbox Virtual Machine oel6 oracle10.0.2 1. precautions for installing OEL. For Linux, you must install the development kit or check the kernel option. Otherwise, no kernel crashes.

I recently learned Oracle9i 9.2.0.1 again with Lei. Although I used to study every problem from the DBA's perspective, but after all, we will find that the entire Oracle system architecture is not what we can do. So this time, we have changed the

Find apply the patch & Mini Patch: Select patch_name, patch_type From ad_applied_patches Order by creation_date -----------------------2644657 one-off2641718 one-offSelect app_short_name, max (patch_level) as patch_level From applsys.

Maintenance mode is a new feature provided after EBS 11.5.10. First, you can make a normal system down plan and give an announcement. This is done through Oracle Applications Manager (OAM. Second, there is a restricted mode access

We just found that Oracle still has this tool. You can modify the block. In 9204, 10gr1, and 10gr2, you have tried this. Check again, from Oracle 7. There are still many unknown things! Such hidden stuff must be used internally and risky. The

Let's talk about internal concurrent manager today. As mentioned earlier, internal concurrent manager is a concurrent manager for managing concurrent managers. Because of this, even if internal concurrent manager is plug-in, other concurrent

Oracle EBS front-end error, reported Ora-00942: Table or view does not exist error, but do not know which table or view is in the end, and can not immediately see the code, trace is useless. Later, I suddenly thought that I could use events to

I. Software and Hardware configuration check 1. Check memory #/Usr/contrib/bin/machinfo CPU info: 4 Intel (r) itanium 2 9100 series Processors (1.59 GHz, 18 MB) 532 Mt/s bus, CPU version A1 8 logical processors (2 per socket) memory: 32737 MB (31.97

Modify Dbsnmp Password 1.Stop em Emctl stop dbconsole   2.Check if Em has been stopped Emctl status dbconsole   3.Use sysUser Login sqlplus, Use the command to change the password   Sqlplus/As sysdba alter user dbsnmp identified by ; 4.Verify

Document directory Feedback   I. Preparation steps Obtain the Oracle 10g installer or download the CD image from the Oracle technical network (OTN. During the evaluation phase, you can download and use full-featured oracle without technical

 Use PL/SQL to read and write blob objects 1. Write files to blobSQL> Create Table iihero_blob (FIDIntPrimary Key, fnameVarchar(32), F BLOB ); The table has been created. SQL> Conn/As sysdbaConnected.SQL> Create or replace directory blobdir as 'd:

Http://www.adp-gmbh.ch/ora/misc/null.html   NULL in Oracle   A column in a table can be defined with the not null constraint. see also nulls and Boolean operatorsnvl, nvl2 and lnnvl are SQL constructs that are related to

From: http://www.cnblogs.com/boulder19830907/archive/2008/01/31/1059627.html Someone asked me today, after designing the field type to float (2) and inserting 93.5 data, why is it 90? In order to illustrate this problem, let's look at a paragraph