Oracle has provided the Flashback Query function based on rollback segments starting from 9i, which can be used to restore wrong DML operations. in Oracle 10 Gb, the flash-back query has been greatly improved. It is no longer limited to flash-back queries. It can also be used to recover incorrect DDL (Drop) operations, flash-back tables, and Flash-back databases.
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 down
The Oracle tutorial you are looking at is to resolve the planned stability of Oracle 8i/9i.
Starting with Oralce8.1, Oracle added a new feature is stored outlines, or plan stability (planning stability). This feature brings three benefits. First, you can optimize the processing of very expensive statements. Second, if
2.4.1 Process Structure
There are two major classes of processes in Oracle 9i network environments.
1. User process
A user process is a program that runs on the client's memory, such as "SQL Plus", "Enterprise Manager," running on the client. The user process is making an operational request to the server process.
2. Server process
The main server process is shown in table 2.5.
Table 2.5
Data Scheme objects
Table 7.1 Oracle 9i data scheme objects
Name
Meaning
Data tables
A table is a database object that holds user data. Tables in a database can be divided into system tables and user tables, depending on the functionality. The system table is used to store data that manages user data and the database itself, also known as the Data dictionary table, the user t
If you encounter a problem when installing Oracle 9i enterprise on Redhat Linux5, please read the following article to help you solve the problems related to the actual application of Oracle 9i enterprise. The installation steps are as follows:Environment: Red Hat Enterprise Linux 5 (RHEL5), Oracle9i (9.2.0.4.0)For RHE
I have been learning Oracle 9i Database for many years. Now I will give a brief description of the basic entry-level operations of Oracle 9i Database. I hope I will be able to learn from Oracle 9i Database beginners.
Initial userU
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 dif
The following articles teach you how to uninstall Oracle 9i correctly. We uninstall Oracle 9i in the actual operating system of win2000 Enterprise Edition, if you are interested in the actual operations, you can click to view the following articles.
1. Stop all Oracle servi
Oracle 9i Server
Oracle 9i includes processes, memory structures, files, and other componentsThe Oracle 9i server is composed of an Oracle instance and an
and save the feature Designe item in License.dat, restart license Manager;5, problem solving.
Resolve Oracle 9i and Tomcat Port conflicts (reprint)
Programme I:
Installed the system, found in the debugger, Tomcat 8080 port has been used, so run Netstat-ano view port usage, found that 8080 port by Oracle listener to occupy, so combined with the Internet to find
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
Separate the strings 1, 2, 3, 4, 5 with commas (,) and output them as rows. That is, 12345 is handwritten. The Oracle10G and above tables are as follows: SQLselect * fromt; IDNAM ..
Separate the strings 1, 2, 3, 4, 5 with commas (,) and output them as rows. That is, 12345 is handwritten. The Oracle10G and above tables are as follows: SQLselect * fromt; IDNAM ..
Separate the strings '1, 2, 3, 4, 5 'with commas and output them as rows, that is
12345
With one hand written,
Oracle| issue recently on the Linux platform to write a program need to use Oracle 9i Client call Pl/sql, when debugging found that there is a memory leak problem, the program has bugs, checked n times also did not find problems (whining, depressed dead), It was later found that the Oracle
Unmount Oracle 9i under XP
Keywords: oracle Environment: Windows XP + oracle 9i
1. Stop all Oracle services: Choose Control Panel> Management Tools> services> stop all oracle servic
For the installation process of Oracle 9i in Ubuntu, refer to this article. This article is mainly based on kubuntu to install Oracle 10g. Refer to this article to easily install 10g, however, oracle 9204 has encountered many obstacles and the installation is complete.
The installation process is as follows:
1. Space R
oracle| Process | data | database
Oracle 9i Database Migration process
Author: unknown
Database movement, often occurs during the implementation of a project, and for experienced DBAs, database movement is very easy. But for some people who only know the system and are not very knowledgeable about the database, Oracle's move is less than capacity.
For example,
Oracle 9i provides a total of 16 scalar data types, as shown in table 7.4.
Table 7.4 Oracle 9i scalar data types
Name
Meaning
Char
Used to describe fixed-length character data, length
Varchar2
Used to describe variable-length character data,
NChar
Fixed-lengt
Oracle 9i Predefined roles
Table 8.2 Oracle 9i Predefined roles
Role name
Description
CONNECT
Database connection role, used to connect to a database, with the right to create clusters, database links, sequences, synonyms, tables, and views, and modify sessions
Dba
The datab
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.