Oracle's system is too large, for beginners, there are some know how to feel, what want to learn what the results are not adopted, so the learning experience to share about the hope that people just started an oracle general understanding, less take
oracle, oracle database, mistake, programmer, circumstances, creativity, s system, logical thinking, database management, transformation, learning experience, fuzz, writing notes, management responsibilityOctober 11
Finally online. Telecom broadband connection upstairs, 4M, using the old cable before, found his book to get less than IP, guess there is another problem of crystal head, crystal really the first line of the original sequence does not. Huawei had hea
mistake, servers, telecom, huawei, cattle, technology research, desire, outsider, neighbor, tensions, tea, absolute security, indirect water, broadband connection, upstairs, sense of security, crystal head, chance of a lifetime, walkwaysOctober 3
1. Someone sent me to modify the local time change, because the other would be likely to forget. (2) sent me the requirements for, look, updates to the document. 3 According to the document to write the script, and run, look at the table really add o
mistake, local time, time change, data dictionarySeptember 28
A: RPM package, This package is like the windows EXE installation files, various documents have been compiled, and hit the package, which documents the folder into which are well specified, installation is very easy, in the graphical interface where
installation directory, quot quot, mistake, firefox, source code package, tar gz, rpm, linux, shell, tar zxvf, graphical interface, software name, asterisk, terminal 2, software directory, bz2, source code archive, realplay, bzSeptember 28
A: RPM package, This package is like the windows EXE installation files, various documents have been compiled, and hit the package, which documents the folder into which are well specified, installation is very easy, in the graphical interface where
installation directory, quot quot, mistake, firefox, source code package, tar gz, rpm, linux, shell, tar zxvf, graphical interface, software name, asterisk, terminal 2, software directory, bz2, source code archive, realplay, bzSeptember 23
If you have old vs2003 compiler, or the significance of this essay is not very big, http://blog.donews.com/tekjian/archive/2006/08/06/990279.aspx a simple introduction to how to install this stuff directly. But now many people were using vs2005 or vs
implementation, lib, mistake, environment variables, python, microsoft, mingw32, compilation, sdk, software microsoft, visual studio, py, twists, visualstudio, pyc, r softwareSeptember 21
Today in the debugging code, met a very funny mistake, Page-encoding specified in XML prolog (UTF-8) is different from that specified in page directive (utf-8), since the beginning of jdk version to I changed, I always thought it was a jdk version is
long time, jsp, mistake, debugging, page directive, prologSeptember 14
As follows: A .8.0 in 1 into the first CD-ROM 2.cd / mnt / cdrom / Fedora / RPMS 3.rpm-ivh ttfonts-ZH_CN-2.11-29.noarch.rpm (Simplified Chinese, you can use the tab key to the padded back section, so as not to make a mistake) 4.rpm-ivh ttfonts-ZH_TW-
mistake, zh, package names, rpm, tw, cd rom, chinese language pack, fedora rpms, noarchSeptember 13
Colleagues in a time of deployment of this project LoadError (Expected /--/app/controllers/xxx_controller.rb to define XxxController) Controller that is the beginning of the name wrong, but several times than not found error. To see the document whic
deployment, mistake, several times, rb, colleagues, suspicion, controller errorSeptember 9
As a general statement, a data table if the data exceeds the hundreds, we should consider the establishment of the index. Dragged on for so long, is finally given some of our larger the data table is indexed. First, see the current index has been est
oracle, oracle table, mistake, circumstances, indexes, table indexSeptember 9
ps-ef | grep java java process on all root 17540 1 0 2009? 01:42:27 / usr/java/jdk1.5.0_15/bin/java-Djava.util.logging.config.file = / usr / local / tomcat / conf / logging.properties-server - Xms800m-Xmx800m-XX: PermSize = 64M-XX: MaxNewSize = 256m-
java java, mistake, catalina, grep, java jdk1, classpath, apache tomcat, rpm, linux, serial number, xxxxx, java process, ef, usr localSeptember 8
from: http://my.oschina.net/u/179560/blog/31626 oracle system too large, for beginners, there are some know how to feel, what want to learn what the results are not adopted, so the learning experience to share about the hope that people just started
oracle, oracle database, blog, mistake, programmer, circumstances, creativity, logical thinking, database management, transformation, learning experience, oracle system, proce, writing notes, oracle courses, management responsibilitySeptember 4
Error reason: a new table in Oracle called "QueryHistory", used to save the user's query log, time, and then "Select * from QueryHistory" to query, report "ORA-00942: table or view does not exist." Error Analysis: the use of
column name, oracle, google, mistake, quotation, query log, schema name, upper case, caps, query report, log timeSeptember 2
sftp This is an open-ssh package, so the port is the same as 22 and ssh. In addition there are other ssh packages scp, keypair generation software and so on. sftp configuration is simple, without any special configuration you can use it, but what is
mistake, upload files, correct path, server directory, ssh package, file transfer, rh, session error, generation softwareSeptember 1
Oracle's optimizer (Optimizer) (CBO optimization) Before running a SQL Oracle, first analyze the statement execution plan, then the execution plan to execute. Analysis of statement execution plan by the optimizer work (Optimizer) to complete. Differe
oracle, sql statements, sql oracle, mistake, emergence, circumstances, optimization approach, optimization methods, oracle8, two rows, implementation plan, toad, pl sql developer, statistics statistics, optimization method, execution plan, index statistics, memory optimizerSeptember 1
What is a savepoint? Use the SAVEPOINT statement to identify a point in a transaction to which you can later roll back. For example: SQL> SELECT * FROM SCOTT.DEPT; DEPTNO DNAME LOC ------ -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARC
sql, oracle, parameters, mistake, transaction rollback, accounting, loc, transaction context, boston, savepoint, current point, dnameAugust 28
Joint multi-table query by connecting to a multi-table queries, multi-table query data from multiple tables, but the table must have the appropriate connection between the conditions. In order to query from multiple tables, multiple tables must be id
oracle, two tables, statistics, mistake, query data, execution, query results, cartesian product, emp, query sql, comparison operator, ename, dname, group functions, query groupAugust 22
Had a very simple thing, toss a long time, here summarize the installation steps to install 32-bit linux system mysql 5.1.56, for example, all the directories for the installation of the default directory. 1 package in the official website, where I m
long time, default installation, relationship, lib, mistake, installation steps, rpm, linux, internet search, com blog, server start, simplicity, server package, default directory, three ways, segment, posix, first command, confi, mysql downloadAugust 18
I head on to the Ftp assign a user, then give him a 50MB of space, the path will be mapped to the IIS path. Personal understanding of this seems to be the same as free space configuration. FTP upload to modify a given user to delete permissions, the
apache, long time, mistake, root directory, free space, physical path, uploads, domain users, 50mb, root windowAugust 14
Now learn to build a portal, is now considered the use of open source framework and in doing good Jetspeed2 the Portal framework. The following day I want to record a recent study into the problems and solutions encountered. Today, trying to add a po
utf 8, configuration file, resource file, mistake, resource files, webapps, garbage, open source framework, ascii codes, tomcat jsp, unicode code, portal frameworkAugust 13
SAP BW e-mail sent Monitoring Strategy The past is the message a queue of messages submitted to the BW we believe that their work is done. In fact did not, and we have been puzzled because the message is wrong, it will drag, will, etc., will card, al
mistake, aim, queue, temporary storage, correspondence, information table, e mail system, exception message, wait state, sdn, sap bw, sood, soscAugust 9
Afternoon and new colleagues made a fun game - "Sea Project", through a tiny project, we completed it with the user to select from the initial to the final release plan development process, benefit a lot. Small but perfectly formed, this process
mistake, paradigm, merger, diary, benefit, colleagues, business processes, agility, use case, host user, shopping, decomposition process, typical user, ui design, fun game, brain storm, critical path, combing process, sea project, tiny projectAugust 4
The special circumstances of the project because the company are in charge of money, can not have the slightest mistake, really fast so special contests for verification, before, though also with js validation framework validate.js, but always felt a
authentication framework, lt, java code, quot quot, attributes, mistake, special circumstances, money, input type, ip, open source java, wrong way, onchange, validation logic, field verification, simple matter, contests, addid, support idJuly 26
Has not written a savings process, and today tried to write the next, but the problem with the out, when calling the following exceptions: Execute SQL exception !SQL: {call P_VIP_RULE_INS(?,?,?,?,?,?,?,?)} java.sql.SQLException: Index missing IN or O
apache, java sql, dbcp, oracle jdbc driver, oracle, parameters, sql statement, mistake, exceptions, ins, index parameter, column index, dbaccess, half sizeJuly 6
http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html Aborted_clients That for some reason the client does not close the connection and cause failure of the number of connections. If the customer does not withdraw prior to adjustment my
variables, memory, mistake, variable value, threads, index number, temporary files, refman, insertion, attempts, server status, data packet, server number, index scan, timeout limit, cause failureJuly 6
My Computer -> Manage -> Services and Applications -> Services The right to find Print Spooler, change its startup type to Automatic and start the service, it will not be prompted to print a mistake
mistake, powerdesigner, startup typeJune 14
Sprint review meeting people from the product liability, Scrum team and the Scrum Master to participate in the meeting need to discuss what good ideas or methods should be adopted in the Sprint what is undesirable, what approach works well and should
quot, mistake, gap, development framework, reflection, backlog, sprint, participants, retrospective, scrum development, estimates, important events, important event, completion time, scrum master, product liability, meeting peopleJune 10
Workaround: Modify the Tomcat port, the specific approach - to find the directory ... \ Tomcat 5.5 \ conf, in the conf directory under the "server.xml" file, use Notepad to open this file, find the (open the file Ctrl + F) All documents, "8
long time, java virtual machine, aspx, notepad, blog, mistake, ip, internet search, default port, ports, conf directory, machine software, endpoint, 192 168 0 1, www service, computer servicesApril 28
Dong-soon light SQLITE3 use summary (3) Reproduced <script> </ script> tags: Knowledge / exploration <! - Body start -> 4) Transaction sqlite is to support transaction processing. If you know you want to delete a lot of data synchronizat
lt, amp, intention, sql statement, notepad, mistake, exec, sqlite, transaction processing, glance, interface functions, rollback transaction, 1 million, xin, million times, knowledge explorationApril 23
ORA-01033: ORACLE initialization or shutdown in progress error solution 2008-04-07 20:53:40 <! - ShowHead end -> Tags: ORACL error solution Original works, for permission to reproduce, reprint, please be sure to indicate the form of hyperlinks origi
lt, oracle, aspx, mistake, oracle product, original source, 163 com, original works, important place, article author, search solutions, evening classesApril 22
The classic mistake about Oracle ORA-01555, there have been many articles online, but mostly from a DBA perspective to this problem, mainly is to introduce the principles and back office solutions. This is the Oracle client as a visitors point of vie
oracle, blog, mistake, perspective, point of view, oracle client, server settings, e 133, office solutionsApril 20
SQL Server2005 installation program can not access the system accounts ASPNET account information Problem installing SQL Server2005 information: "SQL Server Setup can not obtain system account information for the ASPNET account." Solution: With
mistake, microsoft, microsoft net framework, sql server 2005, locals, information system, windows microsoft, framework v2, aspnet regiis, aspnet account, server setup, information problemApril 18
Colleagues conclude the PD Caution, record it. Create table script generated by the pdm when the field exceeds 15 characters on the error (oracle) The solution is to open the PDM, Database menu bar will appear, enter the Database - Edit Current DBMS-
quot, oracle, naming convention, existence, mistake, provisions, colleagues, double quotes, caution, script objects, case sensitivity, menu bar, pdm, table script, index test, model options, case option, database menu, case options, open cdmApril 17
oralce10g database, a table, larger than the data as a table, about 150 million data, because the database structure is not very reasonable, resulting in a 40G size of the table, but customers need to export a detail, so the establishment of a joint
database structure, lt 2, efficiency, mistake, culprit, who the bossApril 11
Before running a SQL Oracle, first analyze the statement execution plan, then the execution plan to execute. Analysis of statement execution plan of work is to optimize device (Optimizer) to complete. Different circumstances, there may be a variety o
oracle, sql statements, sql oracle, mistake, emergence, circumstances, rpm, optimization approach, optimization methods, oracle8, two rows, implementation plan, toad, pl sql developer, statistics statistics, optimization method, oracle optimizer, execution plan, index statistics, memory optimizerApril 1
The midpoint of the service start mysql, Automatically stopped soon, Start again, there will be 1067 error, the service stops unexpectedly google a lot, is that correct my.ini path is not the reason. But still tried unsuccessfully. I do not know what
google, mistake, configured, default directory, computer name, different path, midpoint, backup folderMarch 28
This switched http://blogold.chinaunix.net/u/29134/showart_373855.html Novice in this range are often easy to mistake cause can not enter MYSQL, the whole was very depressed. I do a few examples will soon understand. 1, the original password is 12345
123456, google, mistake, direct access, search a lot, server version, rpm, beta, connection id, mysql connection, quotes, community server, sec rows, html noviceMarch 23
Original Post address: http://topic.csdn.net/u/20090502/13/8f4737bd-d40a-498d-b05e-e662ef2925a1.html The beginning of a customer to do to optimize the configuration, there have been such a mistake, then no experience, how the database get up, they sc
max size, parameters, scope, mistake, instances, simulation, cache size, current value, variable size, memory information, global area, memory components, windowxpMarch 21
In many cases, mysql password forgotten, only to reload, but doing so is awkward. Solution is now given, attention inside the spaces and punctuation in line with other mistake, or will not succeed. Change mysql password is the first operation 1, put
mistake, installation path, bin directory, privileges, dos window, safe mode, punctuation, directory typeJanuary 15
Add, delete or modify database objects, once the mistake may lead to big trouble, need a database management staff, or developers of the relevant entities may be affected code rewrite. To change the database structure and problems, to track the probl
database structure, sample database, statistics, database operations, entities, mistake, operating system, developers, administrative tasks, database schema, big trouble, red tape, response data, sql server 2005, database management, database objects, data definition language, management staff, schema changes, posttimeJanuary 11
oracle Select queries, statistical queries, group functions, order by, having, subqueries, set operations, Keywords: oracle Select queries Statistics Section of the function order by having a collection subquery computing Select queries can be create
oracle, two tables, mistake, query data, execution, query results, comparison operators, cartesian product, emp, query sql, ename, dname, group functions, statistics section, statistical queriesJanuary 7
Have encountered such a problem. We have some tables by the system to allow other systems to access the view, because yesterday I removed the two parts of table fields, leading to other systems to access Times view view_name has errors, careful analy
mistake, reconstruction, careful analysis, access timesDecember 14
If you enter this sql statement: select product_type_id, avg(price) from products where avg(price) > 20 group by product_type_id; Would be a mistake, because the words Where a single line rather than the group can only filter Line in order to filter
sql statement, single line, mistake, type id, products groupNovember 30
I. PURPOSE: 1, to talk about Oracle's Optimizer and some related knowledge. 2, a table to answer why sometimes there is clearly an index of a field, when observing some of the SQL execution plan and found that the index does not take issue. 3, if you
oracle, sql statements, sql oracle, doubts, mistake, emergence, circumstances, models, optimization approach, optimization methods, oracle8, two rows, statistics statistics, optimization method, oracle optimizer, execution plan, index statistics, memory optimizerNovember 26
During this time, do not torture oracle, silent friends, know that their oracle, do the work in the use frequently, but the configuration, optimization of the things that are in a hazy state. Taiqing say, do not quite understand, so take the time to
oracle, sql statements, mistake, optimization approach, optimization methods, oracle8, full table scan, information note, statistics statistics, optimization method, cbo, oracle optimizer, execution plan, expert oracle, index statistics, rbo, memory optimizer, optimization model, silent friendsOctober 15
Configured tnsname.tra information, connect to the database results to the "ORA-12545: because target host or object does not exist, connection failed"; Then finally think of it in C: Windows \ System32 \ Drivers \ etc under the HOSTS file to th
quot, alias, mistake, hosts, target host, relevant database, database results, windows system32September 26
What if what is varchar convert other types such as clob blob so you do not have the data and add columns or remove columns holding a mistake is likely because you deleted but did not submit
This article is reproduced from: http://justdo2008.iteye.com/blog/743153 The following is the MySQL installation diagram, with the installation of the executable file that details a bit! First, open the Mysql Download Center: http://www.mysql.com/dow
installation directory, quot quot, interface, double click, mistake, ini, operating system, database installation, hook, mysql server, software installation, executable file, partition, server mysql, msi, configuration wizard, generic version, installation wizard, system backup, typical defaultAugust 30
I recently visited my machine oracle11 appear "ora-12514 tns listener not recognize the current connection descriptor in the requested service" error, preventing access to the database, I thought I was a mistake on my machine causing the error ,
oracle, listener, oracle home, mistake, oracle product, rewrite, desc, sid, service request, current connection, network admin, c oracle, orcl oracle, ora 12514August 24
Chengdu JAVA Club on the 2nd group 51,397,782 The following is the MySQL installation diagram, with the installation of the executable file that details a bit! First, open the Mysql Download Center: http://www.mysql.com/downloads/mysql/MySQL Server M
installation directory, quot quot, interface, double click, mistake, png, operating system, mysql server, executable file, partition, chengdu, server mysql, java club, msi, generic version, installation wizard, system backup, typical default, bc10August 20
product key for vs2010 ultimate master keyPowered by JForum information serviceshppt: www.jiaogui.com wapttuu,comWWW.1ZUOYEhttp: www.cdpc.china.cnwhttp: 001maya.com:8000 index.phpclear procedure cache mysqlLianXiU22,Comhttp: 120.27.148.219:9080 sjsb