Oracle

In my blog last week, I wroteArticle, Solves the troubles of installing on your own book. In the past, my computer and server were in the same LAN, so every time they were remote servers, they were not the solution. Because multiple people used

Using sqlplus can connect to Oracle normally, and using PLSQL to connect to Oracle is also normal. However, the following exception occurs when myeclipse's dB browser is used to connect to Oracle: Java. SQL. sqlexception: ORA-00604: Error occurred

The T table has nearly 11 million data records. In many cases, we need to perform string matching. in SQL statements, we usually use like to achieve our search goal. However, the actual test shows that the like efficiency is quite different from the

Import the data exported from the Oracle database to the MySQL database1. Import the data to the MySQL database using the default ending symbol:Load data local infile 'd:/oracle.txt 'ignore into Table alarmlogThe default ending character of fields

I have been providing technical support for 2 months. That is to say, I haven't touched the Technical Support for 2 months.CodeNow, I am very familiar with it. Recently, I encountered a big concurrency problem in the project, and the data was

Some time ago, in the company's big meeting room, I saw my colleague D reading the book "efficient Oracle design" and encouraged d to say, "Do you know? After learning this book, H colleagues of the company made a big breakthrough in Oracle

EXP-00091 exporting questionable statistics cause: export was able to export statistics, but the statistics may not be useable. the statistics are questionable because one or more of the following happened during export: a row error occurred,

A) Oracle remote access: Modify the directory c:/Oracle/ora92/Network/admin LF =(Description =(Address_list =(Address = (Protocol = TCP) (host = 172.16.30.74) (Port = 1521 )))(CONNECT_DATA =(Server = dedicated)(SERVICE_NAME = Oracle)))   B) 1. After

1. optimizer_mode Parameter Value descriptionAll_rowsThe optimizer uses a cost-based approach for all SQL statements in the session regardless of the presence of statistics and optimizes with a goal of best throughput (minimum resource use to

  Oracle tips by Burleson Consulting This is an excerpt from "Oracle 10g new features for Administrators" by Ahmed Baraka. Undo Advisor The undo advisor helps you perform the following tasks: O set the Undo retention period O set the size of

Write Public Boolean savewordfile (string filepath ){ File file = new file (filepath ); Connection conn = getconnection (); Try { Java. SQL. Statement ST = conn. createstatement (); Conn. setautocommit (false ); St.exe cute ("insert into table_name

Oracle uses rowid to delete duplicate records in a table   First look at the table myemp   Identify records with duplicate data   Identify records with no duplicate data   Identify non-Repeated Records   Or Select * From myemp e where rowid =

One of the technical principles for ensuring Oracle database security is to carefully analyze the usage of the public user group. The public user group, as its name implies, represents every user in the database. Therefore, granting permissions to

Since many debugging methods are not very good shortly after oracle is involved, the most common debugging currently is the debugging provided by PLSQL developer. Although it is not as easy as Microsoft's vs.net series, for example, when viewing the

In the installation process if there is a OUI-25031 error interface, then the main Linux host name, because oracle is not directly get the IP address, but by parsing the host name to get the IP address of the specific operation is as follows: #

  From: http://hi.baidu.com/benmaoer/blog/item/7a5bcbefbf03213aadafd569.html   One day, after the machine was restarted due to power failure and insufficient UPS power supply, it was found that the listener could not be started and an error was

Oracle is different from MySql in many concepts. to switch from MySQL, you need to understand some Oracle concepts.1 Database and instance databases and Instances A database is a collection of physical files., Stored on a hard disk device, which

From: http://blog.csdn.net/inthirties/archive/2009/08/03/4400905.aspx   A friend on csdn asks for a code segment for help. The code snippet is as follows: DeclareType t_indexby is table of numberIndex by binary_integer;Type t_nesteed is table of

Some users are locked by default after oracle is installed. For example, if Scott user is often lucked, we must first try to give her unluck to use her, this article will introduce how to manually unlock scoot users. Of course, you can also go to

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */