Oracle

Oracle launches the Times following error after modifying parameters[email protected] >startupORA-00119:INVALID specification for system parameter DISPATCHERSOra-00111:invalid attribute DisppatchersWorkaround1. Create Pfile[email protected] >create

As a novice, learn Oracle, and even install Oracle feel the struggle!After continuous search, study, try to find some more useful "guidance", listed as follows:1. http://www.2cto.com/database/201208/150620.html2. http://wenku.baidu.com/link?url=

Sql> Conn Scott/[email Protected]_databaseConnected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0Connected as Scott。。。。。。sql> drop table Student2;drop table Student2ORA-00054: The resource is busy, but the resource is specified as

Common scenario: When backing up an Oracle database from a server to a local machine to restore an Oracle database, you often encounter inconsistent database character encoding, you can use the following command to modify the local Oracle Database

1.1.1. ora-19502,ora-27072Date: 2014-05-12 00:12Environment: Test machine"Error Number"$ oerr ora 1950219502, 00000, "write error on File\"%s\ ", block number%s (block size=%s)"*cause:write Error on output file*action:check the file$ oerr ora 2707227

If loop control statementIf--then endifIf----then----else endifIf-----then--elsif then----else endif--Write a procedure that allows you to enter an employee's name and increase it by 10% if the employee's salary is less than 2000Create or Replace

Recently, because the project rushed to the line, has not time to continue to write a blog, today finally vacated the time. Fame: I am not a professional art, so interface problems, I hope you do not shoot bricks. The login interface is as

If we encounter the need to take data from the database of other systems for statistical analysis, the suspect chooses to use ORACLE 's ODI tool for the number of votes, but the other side of the database provided by the user does not have any

Remote connection to Oracle is cumbersome and usually requires client installation of Oracle to be implemented. With instantclient, you can compare simple connections to remote Oracle.1. New directory D:\Oracle_Cleint used to store related files,

BeanID= "DataSource"class= "Org.apache.commons.dbcp.BasicDataSource" > Propertyname= "Driverclassname"> com.microsoft.sqlserver.jdbc.SQLServerDriver - value>Com.mysql.jdbc.Drivervalue> Property> Propertyname= "url">

Two simple row and column transpose1, fixed column number of the row conversionSuch asStudent Subject Grade--------- ---------- --------Student1 Language 80Student1 Mathematics 70Student1 English 60Student2 Language 90Student2 Mathematics 80Student2

Oracle more and more in the latest work, although they can also write some sql, stored procedures, triggers and so on, but the database management is still unfamiliar, and now will own the recent learning step by step. How to start Oracle on

--PRIMARY key setting:xx_id number (primary key)1 Createsequence Xx_seq--sequence name2Increment by 1--Add a few each time3Start with 1--Counting starting from 14 Nomaxvalue--nomaxvalue--not set maximum value5 Order 6 nocycle--keep

1.ORDER siblings byUsed in conjunction with connect by prior, mainly used to recursively query a tree structure, the structure of the tree itself can be displayed "original" (tree structure of the root node, minor points, leaf nodes rendered "tree"

Deformation of the nearest point pair, the key is to calculate the distance, if the same point, the direct decision to infinity can be.Other gossip:(1) For some reason, was forced to use the C + + for the time being.(2) long time no brush problem,

One table is named tb, the field segment is named name, and the data type is nchar (20 ).1. If the field data is empty, you can directly execute the following command regardless of the field type:Alter table tb modify (name nvarchar2 (20 ));2. If

1.1 symptom description UseExpAn error occurred while exporting data. The following error message is displayed: EXP-00008: ORACLE error 942 encountered ORA-00942: table or view does not exist EXP-00024: Export views not installed, please sort y

During routine database maintenance, we will find some objects in the database (Package, stored Procedure, Function, View, synonym .....) it becomes INVALID and is in an INVALID status (INVALID ). Sometimes it is necessary to regularly check which

1.1.1. ORA-19502, ORA-27072 Date: Environment: Testing Machine [Error code] $ Oerr ora 1, 19502 19502,000 00, "write error on file \" % s \ ", block number % s (block size = % s )" // * Cause: write error on output file // * Action: check the file $

1. Price MySql: Cheap (partially free): currently, MySQL uses DualLicensed, a commercial license agreement developed by GPL and MySQLAB. If you use MySQL in a free (Open Source) project that complies with GPL, you can follow the GPL protocol to use