Oracle

Error ORA-28002: the password will expire within 7 days solution: when using sqlplus today, www.2cto.com ================== ======================================= ERROR: ORA-28002: the password will expire within 7 days =============================

Oracle sets serveroutput permanently for oracle beginners. It is very troublesome to set the serveroutput parameter for each output. The permanent setting method is introduced. Www.2cto.com serveroutput is the configuration parameter of sqlplus,

Rac crs Resource VIP each node has a VIP, which is the IP address we access. If a node goes down, its VIP address will be moved to another node according to the algorithm, www.2cto.com seems to be a normal access for users. I think the vip is used

Oracle retains decimal places. When we are working on a project today, we will find the data in one table and update it to another table. However, an error is reported during execution. The error is as follows: www.2cto.com SQL code ORA-01438: The

Oracle bulk collect Batch Data fetch efficiency SQL code www.2cto.com -- Created on 2010/11/04 by WANGNAN declare -- Local variables here I integer; TYPE t_table IS TABLE OF VARCHAR2 (10) index by VARCHAR2 (2); v_t_table t_table; TYPE t_pg3 is table

Oracle creates a primary key auto-increment table 1, creates a table www.2cto.com create table Test_Increase (userid number (10) not null primary key,/* primary key, automatically adding */username varchar2 (20 )); 2. CREATE an automatic growth

Propagation of oracle exception SQL code www.2cto.com procedure test1 (p_RETCODE in out varchar2, p_retInfo in out varchar2); procedure test2 (p_RETCODE in out varchar2, p_retInfo in out varchar2 ); procedure test3 (p_RETCODE in out varchar2,

[SQL] www.2cto.com -- 19-1: create or replace function cur_datetime RETURN VARCHAR2 is begin return TO_CHAR (sysdate, 'yyyy "year" MM "month" DD "day" HH24 "Hour" MI "Minute" SS "seconds" '); END;/-- 19-2: create or replace function get_sal (name

The oracle object unlock operation queries the locked object select * from v $ locked_object; www.2cto.com queries the locked table select B. owner, B. object_name,. session_id,. locked_mode from v $ locked_object a, dba_objects B where B. object_id

Solve the Problem of garbled characters in Oracle in Linux: where all Chinese characters appear? Alternative, or directly garbled. Sometimes the error message is garbled. Www.2cto.com solution: 1. Switch the temporary solution to the Oracle user and

When the Oracle index prompts parsing hints, in some cases, we may specify a full set of hints to ensure that the optimizer produces the optimal execution plan. Oracle index prompt, oracle index prompt, oracle index tips, oracle index OPTIMIZATION,

Database environment simple detection conn/as sysdba -- output the file to the specified path spool c: \ output www.2cto.com -- (set echo on outputs all query statements) set line 150 -- disable tti off on the header of each page -- disable bti off

Query the space occupied by the LOB field query the space occupied by the LOB field in the Oracle table. Each LOB field in the table is stored independently on a segment with an index segment. Therefore, you need to query two segments to obtain the

Oracle Database Partition technology Partition introduction Partition refers to dividing a very large table or index into smaller, easy-to-manage logical fragments-partitions according to the value of a column. Partitioning a table or index does not

When creating a database using the Oracle multi-Table cascading deletion method, all foreign keys are not cascade to prevent accidental deletion errors. I don't know when I entered a batch of wrong data, but I used the software to automatically

After the GoldenGate process fails, how can we skip the current transaction during the OGG operation? Generally, the disaster recovery REPLICAT process is ABENDED due to various reasons. At this time, we need to analyze ggserr. log, DISCARDFILE,

Environment: [SQL] [oracle @ localhost ~] $ Uname-r2.6.18-308. el5xen [oracle @ localhost ~] $ Sqlplus-v SQL * Plus: Release 10.2.0.1.0-Production(I) syntax www.2cto.com example:① Reclaim space immediately:Alter table table_name truncate partition

If file is not specified for exp, the default path is the current path of CMD. When executing the exp command in the morning, the FILE path is missing. The command is as follows: www.2cto.com C: \ Users \ Administrator> exp scott/scott @ orcl file =

Oracle join and where join in execution order: select * from a inner join B on. aa = B. bb; equivalent to select * from a, B where. aa = B. bb; that is, the internal join is equivalent to the normal equivalent join. Outer join: www.2cto.com is

Oracle lsnrctl cannot start the processing process fault phenomenon: listener cannot start-bash-3.2 $ lsnrctl startLSNRCTL for Linux: Version 10.2.0.1.0-Production on 08-MAY-2009 17: 54: 52 Copyright (c) 1991,200 5, Oracle. all rights reserved.