Oracle

We often have error handling in our proc program, and in error handling we often have to output error messages to help us analyze and resolve the cause of the error to correct the data. Sqlcode and SQLERRM will be used at this time.SQLCode: The

Several ways in which a function/procedure in Oracle returns a result setNote: This article is derived from: "Several ways in which a function/procedure in Oracle Returns a result set"There are several ways in which a function/procedure in Oracle

The client SQL plus requests the connection, listens to the TCP connection that accepts the client, and obtains the TNS packet sent by the client. The listening process opens the pipeline used to communicate with the child process, while fork a

In practice, you will encounter a situation where a user needs to query the table data or view under another user, but when there is no authorization, an error with no permission operation is indicated. Then you need to pass the authorization

Sort out all the questions I've encountered about full-text indexing.I. Setting up a lexical analyzerOracle implements full-text retrieval, and its mechanism is simple. That is, through the Oracle patented Lexical Analyzer (lexer), all the

1. Current number of database connectionsSelect Count(*) fromV$processwhereProgram='ORACLE. EXE (SHAD)'; 2. Maximum number of connections allowed for the databaseSelectValue fromV$parameterwhereName='Processes'3. To modify the maximum number of

Al16utf16 a Kanji account of 3 bytesZHS16GBK a Kanji account of 2 bytesSql> Conn/as sysdba;sql> shutdown immediate;Database closed.Database dismounted.Oracle instance shut down.sql> startup Mount;Oracle instance started.Total system global Area 13533

1.1 Hardware Requirements? The server has the same architecture (such as 64bit and 32bit cannot be the same cluster)? Non-cluster environments require higher physical memory than the 2g,cluster environment requires more than 3G of physical memory1.2

First, the basic usage:First press 11G beforeConn/as Sysdba;Create user test identifed by test;ORA-65096: The public user name or role name is not valid.Check the official document that "trying to create a generic user, you need to use C # #或者c #

Common Oracle-developed tools are SQL Developer and PL-Developer, which personally feel that the former is better than the latter, but larger (more than 300M) occupies resources, and the user experience is generally, while the latter is relatively

Experienced old staff want to be able to generate 1 Awr reports per day for the database, so that the performance changes in the post-analysis database, manual generation too cumbersome, check the information, found that can be automatically

Start by querying the owner,table_name,comments (description, annotations) of all tables, where owner is the category you want to query　　Select tcom. OWNER, tcom. Table_name,tcom. COMMENTS from all_tab_comments tcom where owner=' Sadmin ' and

Query scripts that Oracle DBA must master:1: Querying the size of Oracle standard data blocks by V$parameter data fields1 ----Query the size of the Oracle standard data block by v$parameter the data dictionary. 2[Email protected]> startup3ORACLE

Explain the table partitions by day, by month, and by year in oracle. Partition Table concept: When the amount of data in a table increases, the speed of data query slows down, and the performance of applications degrades. In this case, you should

[80122]column statistics and histogram .txt,20180122.txt [80122]column statistics and histogram .txt -- // I saw token yesterday: 1. Environment:SCOTT @ book> @ ver1PORT_STRING VERSION BANNER-----------------------------------------------------------

Summary of Oracle8i UNDO tablespace corruption (ORA-01092 and ORA-00600 [4193]) in the case of database Incomplete recovery experience, oracle8iora-01092 The recovery directory library of the backup production environment cannot be started due to a

Oracle function summary, oracle Summary Among the various databases that are currently popular, why oracle can be listed at the beginning and the birth of oracle has brought a storm to the use of the whole database, what functions and advantages

How to view the permissions or roles of the current Login User in Oracle View the role of the current user SQL> select * from user_role_privs; SQL> select * from session_privs View the system and table-level permissions of the current user SQL>

After connecting to oracle error "ORA-28547: connectiontoserverfailed, probableappslenetadmin solution, Listener. ora is the oracle configuration file on the server. Then, comment out this line of listener. ora, and (PROGRAM = extproc) To: SID_LIST_

ORA-12162: TNS: net service name is incorrectly specified how to solve the error ?, Ora-12162tns "ORA-12162: TNS: net service name is incorrectly specified" appears today when you log on to sqlplus using an oracle user ". As follows: [oracle@oracle