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

SQL> select * from sys. SHIP_CABINS; SHIP_CABIN_ID SHIP_ID ROOM _ ROOM_STYLE ROOM_TYPE window guests SQ_FT BALCONY_SQ_FT-----------------------------------------------------------------------------------------------------1 102 Suite Standard Ocean 4

Fault description: the following error is reported when the master database is started after the oracle dataguard environment is set up: Wed Feb 8 23:12:38 2012LGWR: Error 16047 creating archivelog file 'standby'Wed Feb 8 23:12:38 2012Errors in file/

Oracle11g modify sga to modify memory_target and other parameters first, otherwise the service will be restarted with an error ORA-00844: Parameter not taking MEMORY_TARGET into account, see alert log for moRe information. To modify the SGA

Manage oracle clusterware (Voting Disk) The Voting Disk file is mainly used to record the node member status. When split-brain occurs, it is determined that the Partion gets control, and other Partion must be removed from the cluster. Voting disk

A cool exception, no clue at all, so google. In the past, my database used oracle 11.2.0.1.0 and jdbc used ojdbc 10.2.0.2.0. After several months, no error was reported. Today, even more enchanting events have occurred. The two applications are

In the past, I remember that Mysql Command terminals can insert or update databases in batches. Write down the PL/SQL Deverloper Method for Batch Data Processing today. 1. log on to PL/SQL Developer2. Choose menu File> New> command window.3, SQL> @

/******************* 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

The simplest scheduled Oracle task1. Create a table in PLSQL:Create table HWQY. TEST(CARNO VARCHAR2 (30 ),CARINFOID NUMBER) 2. Create a stored procedure in PLSQL:Create or replace PRocedure pro_testASCarinfo_id number;BEGINSelect s_CarInfoID.nextval

Today with the client to connect to oracle, found to report ORA-01033: ORACLE is initializing or closing the error, in fact, this error reported for a few days, the first two restart just fine, why can't I get up today? By searching on the Internet,

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 '%

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

Insert into Table Name (Field 1, Field 2) select '1', '2' from dual union all select '3', '4' from dual union all select '5 ', '6' from dual union all select '7', '8' from dual union all select '9', '10' from dual reads all data from a CSV file, it

Oracle Database Password validity period parameter 1. view the profile corresponding to the database user. SQL> select username, profile from dba_users; check the profile of the historical database user sersv IN THE displayed information. Generally,

-- 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

Sometimes oracle reports the following error when executing a large transaction: Pl/SQL code ORA-01555: snapshot too old (rollback segment too small) this indicates that the random rollback segment allocated by oracle to this transaction is too

Recently, the company is working on Oracle database-related products. Here is a summary:The ISNULL () function syntax ISNULL (check_expression, replacement_value) parameter check_expression will be checked for a NULL expression. Check_expression can