Oracle

I. Set the environment variable [oracle @ orcl ~] $ Cat. bash_profile#. Bash_profile # Get the aliases and functionsIf [-f ~ /. Bashrc]; then.~ /. BashrcFi # User specific environment and startup programs ORACLE_SID = orclORACLE_BASE

1. Oracle tracking FileThere are three types of Oracle tracking files: One is the background alarm log file, which records the activity of background processes during database startup, shutdown, and running, such as creating tablespaces, creating

The index is like a dictionary directory. With the dictionary directory, we can quickly find the entries we need. The same is true for databases. With the Oracle database index, related statements can quickly locate the record location without

  The ORA-28000: the account is locked error appears in the Oracle database log, which can be handled as follows:     1. query the default value of the FAILED_LOGIN_ATTEMPTS parameter. This parameter limits the number of consecutive logon failures

  When oracle 11g exports a database using exp, empty tables cannot be exported. Therefore, you must use a Data Pump to import and export the oracle database.   1. expdp   SQL> create directory name (for example, dmpbx) as storage address (for

  POP3 is called Post Office Protocol version3, that is, Post Office Protocol version 3rd. It is used by the user agent to obtain the mail on the mail server. POP3 uses the C/S communication model, and the corresponding RFC file is RFC1939. This

  1: Analysis: Assume that ebay. SQL is placed on the E disk. Because the SQL file is too large, it always reports memory overflow when opened in the editor. Then, you can use the cmd command line to view it,   Execute type ebay. SQL to check

  To view the permissions of an Oracle user, you must first traverse all the users and then view the permissions of the Oracle user. I hope this article will help you.       1. View All Users:       Select * from dba_users; select * from all_users;

The two highly lethal commands compiled today can instantly kill Oracle. Next I will give a simple comment and demonstrate its power.$ Ps-ef | grep $ ORACLE_SID | grep-v grep | awk '{print $2}' | xargs kill-9$ Ipcs-m | grep oracle | awk '{print $2}'

Basic information:Operating system version: CentOS-5.6 X86-64Cpu: 2*12Memory: 16 MBDatabase Version: 10.2.0.4Number of nodes: 2When installing the system,/etc/sysctl. conf is not configured as optimal. In fact, for CentOS5.6-64, kernel. shmall and

ORA-06502: PL/SQL: Number or value error: string buffer is too smallWe usually use a where statement to query a database. However, we are not sure about the content of the where statement (for example, it needs to be determined at runtime, that is

I wrote a blog post last week about partition tables: http://www.bkjia.com/database/201202/119377.html.However, I found that I did not write much. When your query conditions are not closely related to partition columns, partition tables will not

Select a. *, rank () over (order by cj desc) pmFrom ((Select 'A' name, 1 cjFrom dual) Union (Select 'B' name, 1 cjFrom dual) Union (Select 'C' name, 2 cjFrom dual) Union (Select 'D' name, 3 cjFrom dual) Union (Select 'E' name, 3 cjFrom dual) Union

1. Create a logical directory. This command does not create a real directory in the operating system. It is best to create a directory as an administrator such as system.Create directory dpdata as '/opt ';2. Check the Administrator directory (check

This is because the listener on the server is not started. In addition, check whether the IP address or port of the client is correct.Start listener: cmd: lsnrctl startDisable monitor: lsnrctl stopMonitor status: lsnrctl statusIf the above Code

The main function of minus operations is: When two tables or two query results are performed, returns records in the first table/query result that are different from the second table/query result. For example, the data in Table A is as follows: id

1. Single-Row Functions (Single-Row function) Single-Row function returns a separate result Row for the table or view queried for each Row, single-row functions can appear in SELECT columns, WHERE clauses, start with and connect by clauses, and

The difference between the Oracle database and the MySQL database is what we will introduce in this article, hoping to help you. 1. group function usage rules: Group functions in mysql can be used at will in select statements. However, if a group

I have read articles on the Internet, and there are several possible reasons for Garbled text: 1. operating System Character Set 2. character Set of oracle server 3. character Set of the Client 1. view the oracle Character Set Java code select

The inline view embedded view is called the inline view, which is also called the inline view. To put it bluntly, it is the view created during execution. For example, select... from (select... from (select ...)), the select statement used as the