Oracle

  When you execute DMBS_JOB.RUN (: JOB_ID); then the job record will have a record in user_jobs, but the record does not exist in DBA_JOBS_RUNNING.       1. The Broken () process updates the status of a submitted job. It is typically used to mark a

  The configuration of tomcat 5.x and tomcat 6.x connection pool is different. Here, the configuration process of tomcat 6.0 is recorded.   Container: tomcat 6.0   Database: oracle 10g   Procedure:   1,   Put the driver package ojdbc6.jar of the

Project module: Survey and coupon Requirement: each questionnaire has three statuses: Start Time and End Time, And not started (status = 1) --> under investigation (2) --> ended Survey (3. The system is required to automatically determine whether

------ Create a type Create or replace type whiteListType as object (Spid number,Spname varchar2 (200 ),Spcode varchar2 (200 ),Listname varchar2 (200 ),Mdncount number ----- Create a reference Create or replace type "WHITE_LIST_TYPE_ARRAY" IS array (

Any real number can be expressed as: S = A. B * 10n (N power of 10 ). Then we only need to store A. B (Data Part), n (highest bit. However, oracle also stores the symbol bit (which is required for negative numbers ).Create table test_number (num_col

Today's Oracle research encountered this problem ora-01033: oracle initialization or shutdown in progress, after analysis and research finally solved, write down to commemorate. My database is oracle 9i, which is 90.I. First, the cause of the

Author: runming QQ: 226399587 http://blog.csdn.net/runming9183. query Versions between VersionsMore powerful. With versions between, you can view different versions recorded in the undo tablespace within a specified period of time (note that only

1. switchover of physical standbyNote: Before switchover, you need to change the host name in the tnsnames. ora file of the listening parsing file, change both the master and backup, and restart the listening.Master database operations:The

Author: skateTime: 2012/02/22 Oracle10g sysaux space increase and space recovery In Oracle10, The tablespace SYSAUX is introduced, and oracle stores statistics here. This is also to better optimize the system tablespace. We can use view V $

/******************* Method 1 ***************** ************/-- Create typeCreate or replace type t_str is table of varchar2 (2000 );-- Create functionCreate or replace function uf_splitstr (I _str varchar2, I _split varchar2)Return t_strPipelined

I accidentally saw the lnnvl function today.Lnnvl is used as a condition in the where clause of a statement. If the condition is true, true is returned. Otherwise, false is returned.It can be understood as LNNVL = is null or is not true.Its

For the development of Oracle databases, we may sometimes encounter some strange problems, which are different from other databases. Here I have listed some interesting questions.Problem 1: solving the time problem in Oracle The default date type of

First of all, the system tables provided by databases of different versions are different. You can view the tables provided by the database of this version according to the data dictionary.Like this:Select * from dict where table_name like '%

Ora-12154 causes and solutions to solve a large online, but the following: 1. the local environment variable oracle_home is not set. 2. due to the installation of excessive versions of oracle, the instance version first loaded in plsql is incorrect.

The database cannot use the archive logs of oracle when the set limit value is reached. The error message is: ORA-00257: archiver error. connect internal only, until freed. At this time, you can choose to move its log file to another place, delete

I. Conclusion In the VirtualBox virtual machine environment, an Oracle RAC environment is set up. Combined with Network File System (NFS), each node of RAC can access the External table normally. That is, it is important to have a shared storage

Restrictions on oracle user logon failures"FAILED_LOGIN_ATTEMPTS" is used to configure the maximum number of consecutive password input errors. If this value is exceeded, the account is locked. 1. Run the following command to query the value of

-- In Oracle Database Operations, we sometimes use lock table queries and unlock and kill processes. How do we implement these operations? This article mainly introduces this part. -- The lock Table query code can be in the following format: select

Oracle time issue continuation string -- Time Format continuation previous article: oracle time issue ( http://www.bkjia.com/database/201202/119154.html ) TO_CHAR is to convert the date or number to the string TO_DATE. It is to convert the string to

Resolve ORA-01536: Method of exceeding the space limit for TABLESPACE "users" case role: CONNECT, RESOURCE system permission is empty when creating a table, this error is reported, and then add system permission unlimited tablespace, you can create