Oracle

Today, I encountered a problem. Suddenly, Oracle failed to log in with the System user in the normal state, but sysdba was able to log in. The reasons are as follows: 1. Oracle DBA groups are related to the operating system, and ora_dba is a DBA

The following error is reported when running sqlplus in cmd in win7. SP2-1503: Unable to initialize Oracle call interface SP2-1503: Unable to initialize Oracle tuning SP2-0152 Solution: Right-click sqlplus.exe In the oracle \ product \ 10.2.0

On the Internet, you can see an article about partition tables and local indexes written by eygle.Article, I think the summary is quite good. OracleOfPartitioning technologyIt can be greatly improved under some conditions.QuerySo it is widely used.

Oracle cluster (RAC) Startup and Shutdown Pay attention to the following points when starting and disabling Oracle RAC: 1. Check shared devices Ii. Automatically Start RAC and check related processes Iii. manually start RAC 4. Check the

(I) can a view use an index? The answer is no. Why?What is a view first?View, essentially, is just a stored SQL statement.Some may ask why materialized views can be viewed?This... this, it's just two different things, two completely different

  The arcsde10 of ArcGIS suddenly fails to connect to Oracle and prompts an error: After querying Google, the solution is as follows: 1 View the user's proifle, which is generally default: SQL > Select username, profile from dba_users; 2

Oracle cannot log on IN NORMAL STATE Today, I encountered a problem. Suddenly, Oracle failed to log in with the System user in the normal state, but sysdba was able to log in. The reasons are as follows: 1. Oracle DBA groups are related to the

A database version used to change the password of an Oracle user: 9.2.0.5) Sometimes we may not know the password of a user, but we need to perform some operations with this user, and we cannot modify the password of this user. At this time, we

The requirement is to check what the topic of the site we have set up for the user has been adjusted n times, so I found relevant information on the Internet, query with a specific Oracle statement. Detailed content from

1. delete a tablespace Drop tablespace tablespacename [including contents [and datafiles]2. delete a user Drop user user_name Cascade3. Notes for deleting a table When deleting all data in a table, the truncate table name must be used. Because

After learning how to use ibatis over the past few days, I suddenly used fuzzy queries and dynamic multi-condition queries. I tried it for a long time based on my own ideas and did not solve this problem. The first problem is fuzzy query. At the

Quick query of common Oracle functions 1. ASCII () C1 is a string that returns the ASCII code of the first letter of C1. Its Inverse Function is CHR () Select ASCII ('A') big_a, ASCII ('Z ') big_z from empbig_a big_z65 1222.chr( ) [nchar_cs] I is a

Basic knowledge related to table fragments: What is waterline? (High water mark )? ---------------------------- All the Oracle segments (segments here, for ease of understanding, we recommend that you use segment as a synonym for the table) have

I. Prerequisites: 1,Make sure yourSqlserver 2005Already installedReporting Service. 2,Started in the serviceSQL Server,SQL Server Agent,SQL Server Browser,SQL Server Reporting ServicesThis4Services. 3,Sqlserver2005The Working Group version

  1.To the specified user(Tecamocmsuser)Authorize (CtxappAndExecute on ctx_ddl) Grant ctxapp to tecamocmsuser;   Grant execute on ctx_ddlTecamocmsuser;   2Create Word Segmentation   Ctx_ddl.create_preference ('My_lexer','Chinese_vgram_

Create   Or   Replace   Procedure P_rebuild_all_index(Tablespace_name In   Varchar2 ) As Sqlt Varchar ( 200 ); Begin For Idx In ( Select Index_name, tablespace_name, status From User_indexes

Use cursor to update data in Oracle Declare cursor cur is select * from test for update;Idnum number;R test % rowtype;BeginIdnum: = 0;Open cur;LoopFetch cur into R;Exit when cur % notfound;Idnum: = idnum + 1;Update Test Set ID = idnum where current

Sometimes, when inserting a database, we may insert duplicate data, but do not want Modify existingProgram, We can use triggers to avoid modifying programs and solve problems directly in the database. Test procedure: 1. First, create a test

Yesterday, a colleague asked me to read a piece of SQL, saying it was very slow. I first looked at the execution plan and found that the cost was very large, but at the same time I also found that there was a big problem with partition reading.

This is because more and more people have asked me this question recently. I want to write down my ideas. 1. How fast is it?Many people like shortcuts, so they often ask for shortcuts, but I often tell you that there are no shortcuts, or there are