oracle 9i

With Oracle 11g for a long time, really feel is a very heavy client, installation will take one hours, recently started to contact this lite version of the database client, tinkering with the half-day, finally success.1. Download the client2. InstallationThe fool installs can, remembers own path.3. Configure Environment variablesThe path variable is the first to add the paths just installed, everyone is different, c:\

The ORACLE tutorial is as follows: startup after Oracle 9i Database is shut down abnormally. Oracle Database startupA sudden power failure occurs during Oracle shutdown, and the database cannot be connected when SQL/plus is used for startup. The specific description is as fo

The Oracle tutorial you are looking at is the launch of an Oracle 9i database shutdown after an exception. Oracle Database Startup Oracle shutdown suddenly power off, resulting in the use of Sql/plus startup can not connect to the database, specifically described as: Conne

Js|oracle Recently, due to the project, the system needs to be transformed into another environmental system. That is, the Resin + Ms SQL developed JSP program into the WebLogic + Oracle JSP program. Oracle I played it six years ago, I forgot how to use it long ago. From the cooperation project company to get the genuine installation disk installed, suddenly do n

The premise is that Oracle 9i is already installed.1. Download the corresponding Oracle client installation.Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.htmlSince there is no 9i client available to download, I choose the closest version to download:Version 10.1.0.5Instant Client packa

Oracle Purpose: Install Oracle 9i on Linux 8.0 to ensure database security and stability Software Environment: Linux 8.0 (three CDs) Oracle 9.2.0.1.0 for Linux (three CDs) Hardware environment: P4 2.4, Memory 512M, hard disk 80G high RPM, 16x_dvd optical Drive Problem Reason: Linux runs Oracle's system environment c

Oracle 9i reported ORA-01036: Invalid variable name/Number The The problem is the variable name. SQL method: @ username I use the Oracle database in the following way: username Just change to Oracle. Public StringInsertUser (UsersUser) { // String SQL = "insert into Tuser (user_id, username, password, gender, ema

The service starts background processes, which are similar to the daemon process in UNIX. When the Oracle Database Service is started, no typical Oracle process is running in the system. On the contrary, the service process waits for the initial connection from SQL * Plus, which causes a foreground process to start and create the background process of SGA in the global region of the system. When the

A friend in the group asked a question: the Oracle 9i database failed to execute the job, and the materialized view refresh reported an error. The error message is as follows: ORA-04068: existing state of packages has been discardedORA-04062: of has been changedORA-04062: Timestamp of package "SYS. dbms_snapshot_utl" has been changedORA-06512: At "SYS. dbms_snapshot", line 617ORA-06512: At "SYS. dbms_snapsh

1, if the default Value of Oracle 9i,national CharSet is installed, it is al16utf16. If you're going to replace AL16UTF16 with UTF8, According to the previous method Update sys.props$ Set value$ = ' UTF8 ' WHERE name = ' Nls_nchar_characterset '; There's going to be a problem. There is no information in Oracle that fully reflects CharSet. So, when insert in table

The external table introduced in Oracle 9i allows you to map a sequential text file to an Oracle table definition. Once you have defined an external table, you can apply all the functionality of the SQL SELECT statement-including parallel queries-to handle it. External tables are based on Sql*loader, but the syntax for defining them is different. If you're alread

Pfile file The Pfile (Parameter file) file is a text-formatted parameter file that contains configuration parameters for the database. Oracle 9i establishes a pfile for each database at installation time, the default name is "init+ routine name. Ora", a text file that can be opened with any text editing tool. Table 6.1 initialization parameter file analysis of database Content Description

6.2.1 Pfile FileThe Pfile (Parameter file) file is a text-formatted parameter file that contains configuration parameters for the database.Oracle 9i establishes a pfile for each database at installation time, the default name is "init+ routine name. Ora", a text file that can be opened with any text editing tool.Table 6.1 initialization parameter file analysis of database Content Description # Copyright (c) 1991, 2001 by

Oracle 9i has achieved new breakthroughs in cluster technology, high availability, business intelligence, security, and system management, and its features include the following.1.4.1 Cluster TechnologyThe principle of clustering is shown in Figure 1.2.1.4.2 Online analytical processing, data mining and analysis technology1. What is online analytical processing2. What is a data warehouse3. What is data mini

6 ways to 3.6.1 server startup Oracle 9i database servers have 6 ways to boot, as shown in Table 3.3. Table 3.3 Server Startup 6 ways features normal boot start loading and opening the database, the user can make normal access do not load boot start the server without loading the database because the database is not open , the user is not allowed

' ); Insert into EMP (Emp_id, manager_id ) Values ('002', '123' ); Insert into EMP (Emp_id, manager_id ) Values ('003 ', '123' ); Insert into EMP (Emp_id, manager_id ) Values ('20160301', '20160301' ); Insert into EMP (Emp_id, manager_id ) Values ('20160301', '20160301' ); Insert into EMP (Emp_id, manager_id ) Values ('20160301', '20160301' ); Commit; Someone gave the following answer:Select emp_id, manager_id FROM (SELECT CONNECT_BY_ROOT (emp_id) emp_id, manager_id, CONNECT_BY_ISLEAF v_isleaf F

1. References: Http://archive.cnblogs.com/a/1520906/ Http://blog.oracle.com.cn/html/07/t-86007.html Http://feng10251225.blog.163.com/blog/static/6312279820089154288377/ Http://space.itpub.net/12330444/viewspace-620190 Http://topic.csdn.net/t/20040511/08/3052489.html 2. Steps Implementation Method:1. Choose "start"> "Settings"> "Control Panel"> "Administrative Tools"> "services" to stop all Oracle services.2. Start-> Program ->

Conditions for running data guard1. The same version of Oracle Enterprise Edition must be installed on the master database and all slave databases.2. The master database must run in archive mode.3. the operating system of the master database and slave database must be the same (different versions are allowed). The slave database can use a different directory structure than the master database.4. The architecture of the Master/Slave Database hardware s

The Oracle tutorial you are looking at is: Oracle 9i easy access to table and index DDL statements. We all know that before 9i, it would be a hassle to get the statements to build tables and indexes. Our usual practice is to come through the export with Rows=no, but its output is not directly available because of the f

The most important new feature of oracle9i is the ability to dynamically modify almost all Oracle performance parameters. This allows Oracle experts to dynamically reconfigure the Oracle instance during the run-whether it is addressing a current performance problem or anticipating an urgent performance requirement. Because you can dynamically modify everything in