Oracle

When I tried to install Oracle 8i on Win2k with SP4, the setup program just did not startup. There seems to be a known issue: Cpuid detection for Intel. Pentium. 4 processor system:Intel has identified that applications which use the Symantec

Open powerdesigner-> menu bar "Database"-> database reverse engineering-> using an ODBC data source, select Browse-> connect to an ODBC Data Source-> machine data source select the data source you configured. (Note: If you need to configure the data

Open the ACCESS database, select a table, change the table name to uppercase letters, and select the storage type as follows: ODBC database (). Next, if you have not created a DNS, you can create a new one. As prompted, creating an oracle DNS will

Original article: http://www.cnblogs.com/believe3301/archive/2007/10/10/919408.html For the rownum problem in Oracle, many documents do not support>, >=, =, between... and. The preceding symbols can only be used (,> =, =, .. and will prompt SQL

Oracle + SDE data backup and recovery 1. Complete database backupExp System/password @ Sid Full = y file = D: \ system. dmp log = D: \ system. Log2. Data warehouse receiving(A) Delete SDE and SDE user from the databaseDrop user SDE cascade;Drop

  Oracle is a large database that can be used to store massive data. There are also various ways to import data sources, some of which are constantly added as the business grows, and some are also imported in batch during business system

To do well, you must first sharpen your tools. Oracle itself has some auxiliary client tools, but they are not very easy to use. However, real DBAs like to use command line methods to operate databases. We are not DBAs, we are Program Personnel, so

In the afternoon, a table structure is exported from the production database to test some problems. Because the production database is connected to tables of other users, the view is simulated locally, so a view is created: Create Or Replace

Early in the morning, someone in the group yelled at Oracle to buy sun. Haha, the change was too fast and did not respond. Fortunately, today is not because of the attitude of yu'e to check and view Google... The first reaction was that IBM would

  Many parameters are required to optimize the Oracle database. Some of these parameters have a great impact on the system performance. These parameters are variable parameters.Variable parameters can be divided into two categories based on their

Http://blog.csdn.net/lanpy88/article/details/7580691 method: Export using PL/SQL developer : Menu bar ----> Tools ----> Export tables, for example, set the relevant parameters: Method 2: Export using cmd commands : 1: There is a tnsname. ora file

In Oracle, only DML starts a transaction. That is to say, insert, update, and delete all start a transaction, and the transaction will automatically end when the commit/rollback/DDL command is executed. 1. Obtain the first few digits of a specific

SQL: -- Applicant indicates the table name. Select ' Private ' | Decode (A. data_type, ' Varchar2 ' , ' String ' , ' Number ' , ' Double ' , ' String ' ) | Lower (A. column_name) | ' ;// ' | B. Comments From

Implicit cursor Begin Update try set score = 60 Where course No. = 'c008 'and score If SQL % notfound then Dbms_output.put_line ('there is no score below 60! '); End if; End; / -- Use of cursor Variables Declare Type cursor_type

What is the Oracle diagnostic methodology (ODM )? [ID 312789.1] ODM test: Query statement: Select to_number (ADDR, 'xxxxxxxxxxxxxxxxxx') from V $ latch_parent where name = 'process allocation ';Select name from V $ latch_parent where name like '%

I learned and tested how to restore an Oracle database in archive log mode. The system is Win2k SERVER + Oracle 8.1.7. For more information, see chinaunix.net and itpub.com. Thank you for your help. Note: It is very important to develop a good

1. Introduction There are many backup methods for Oracle databases. No matter which method is used, the purpose of backup is to restore the system at the lowest possible time and cost after a fault occurs. For example, using exportProgramVarious

In Oracle, how does one analyze SQL statements in stored procedures? Let's take a look at how to analyze statements. Analysis tools found in oracle tools: Oracle-OraHome90-> Enterprise Management packs-> tuning-> SQL analyze Start logging on:

After many practices, see N multiple onlineArticle...... The final configuration is not complete. I may be too savvy to take notes from experts. It was finally completed with the help of the predecessors. We use the most practical method to record

Create or replace type tb_strSplit as table of varchar2 (4000 ); Create or replace function to_table (pv_str varchar2, pv_split varchar2) return tb_strSplitAsLtab tb_strSplit: = tb_strSplit ();Pos integer: = 0;Ls varchar2 (4000): = pv_str;BeginPos: =