Oracle

  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 configuration of tomcat 5.x and tomcat 6.x connection pool is different. Here, the configuration process of tomcat 6.0 is recorded.   Container: tomcat 6.0   Database: oracle 10g   Procedure:   1,   Put the driver package ojdbc6.jar of the

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

Project module: Survey and coupon Requirement: each questionnaire has three statuses: Start Time and End Time, And not started (status = 1) --> under investigation (2) --> ended Survey (3. The system is required to automatically determine whether

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

Calculate the total amountSelect sum (price * qty) from books; Query groups (the group by statement must be in select)Select sum (price * qty) from books group by pub; use Group by and having to replace where Incorrect case:This is not correct. As

Summary of Oracle date timestamp Time FunctionsYyyy-mm-dd hh24: mi: ss. ff year-month-day hour: minute: Second. millisecond -- Last month, last yearSelect add_months (sysdate,-1) last_month, add_months (sysdate,-12) last_year from dual;-- Next month,

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

1. switchover of physical standbyNote: Before switchover, you need to change the host name in the tnsnames. ora file of the listening parsing file, change both the master and backup, and restart the listening.Master database operations:The

Computing Time Difference in Oracle is often used. You can use "date 1-date 2" and calculate it to obtain the time difference: day, hour, minute, or second. For example:  Select TO_DATE ('2017-02-20 17:45:04 ', 'yyyy-mm-dd hh24: mi: ss')-TO_DATE (

Author: skateTime: 2012/02/22 Oracle10g sysaux space increase and space recovery In Oracle10, The tablespace SYSAUX is introduced, and oracle stores statistics here. This is also to better optimize the system tablespace. We can use view V $

Someone posted an error in the group:ORA-00600: Internal error code, parameter: [dmlsrvColLenChk_2: dty], [2], [0], [16896], [], [], [], [], [], [], [], []ORA-06512: In "IDBG17_DEV.ETL_LINK13_LLR_BRN", line 44ORA-06512: In line 2 I searched the MOS

I recently summarized how to set the oracle primary key. paste it here and save it. There are two ways to set a primary key, one is auto-incrementing primary key, and the other is to generate a unique sequence.I. Auto-increment primary key -- First

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

Oracle10g, OracleDBConsoleoracl is my service.The service cannot be started the next day, because the IP address is changed. 1. Run "emctl start dbconsole" under the cmd command. "Environment variable ORACLE_SID not defined. Please define it."

The database cannot use the archive logs of oracle when the set limit value is reached. The error message is: ORA-00257: archiver error. connect internal only, until freed. At this time, you can choose to move its log file to another place, delete

Sys_guid ()-a unique index in Oracle can use SYS_GUID () to generate a guid, which is equivalent to newid () in msSql (). In Oracle9i and Oracle 10g, SYS_GUID generates 32-bit data, for example, 234e45f0077881aae0430aa301161aa. However, the guid

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

In Oracle, how does one import the table structure under one user to another? Unix: exp \ 'sys/password as sysdba \ 'file =. dmp owner = Export user rows = Nimp \ 'sys/password as sysdba \ 'file =. dmp fromuser = Export user touser = import user in