Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


381: Oracle 9i data types
Oracle 9i provides a total of 16 kinds of scalar data types, such as shown in Table 7.4. Table 7.4 Oracle 9i scalar data types Name Meaning Char Used to describe the fixed-length character data, length <= 2000 bytes varchar2 Used to descri...

382: Oracle 9i program object
Program object data Table 7.1 Oracle 9i data on the program object Name Meaning Data Sheet Table is used to store user data of the database objects. Database table in accordance with the functions of the different systems can be divided into tw...

383: Oracle 9i lock
Why lock the introduction of the concept of What is a lock Oracle 9i lock all the management and distribution of database management system by the auto-complete, and does not require user intervention, but also provides a manual locking order for ...

384: To deal with outstanding matters
Why is the concept of the introduction of Service Service is the current mainstream database system widely used concurrency control mechanism. What is a Service Services have the following four most important characteristics, in accordance with t...

385: The use of data dictionary
6.11.1 What is the data dictionary In fact, data dictionary table and view data as the main form of existence. It can be said that data on the data dictionary table and view data. 6.11.1 How to use the data dictionary (1) as shown in Figure 6.65....

386: Database upgrade
6.10.1 What is the upgrade Upgrade is to install the Oracle database release is converted to a higher version of the release. For example, Oracle 9i Database 9.0.1.1.0 is converted to Oracle 9i 9.0.1.1.1 database system is upgraded. Database migra...

387: Oracle 9i database template customization
6.9.1 What is a template Database relationship between the template and database files on a blank as if the registration form and the actual relationship between the personnel file. 6.9.2 The three kinds of default templates 【】 To choose a ty...

388: Oracle 9i database to delete
(1) Start Database Configuration Assistant】 【until 6.44 appears as shown in Figure】 【operation interface. (2) appears as shown in Figure 6.45】 【database interface. (3) appears as shown in Figure 6.46 Summary】 【interface. (4) appea...

389: Oracle 9i database model modified
(1) Start Database Configuration Assistant】 【until 6.34 appears as shown in Figure】 【operation interface. (2) appears as shown in Figure 6.35】 【database interface. (3) appears as shown in Figure 6.36 of the database options】 【datab...

390: Create Oracle 9i database
6.6.1 Using Database Configuration Assistant】 【create database (1) appears as shown in Figure 6.18】 【Welcome to the interface. (2) appears as shown in Figure 6.19】 【operation interface. (3) appears as shown in Figure 6.20】 【databa...

391: Oracle 9i database using the user query
6.5.1 What is a conversation Session (Session) is the Oracle database server to connect to database users a means of recording. 6.5.2 What are the contents of the conversation (1) as shown in Figure 6.11 of the conversation interface. If the data...

392: Oracle 9i database log mode switch
6.4.1 Database log mode of the two There are two Oracle database log mode. Non-archive log mode Archive log mode 6.4.2 Switch to the archive log mode (1) as shown in Figure 6.7 for editing the database configuration】 【General Information ta...

393: Oracle 9i database configuration parameters
As shown in Figure 6.2. 6.3.1 General Information】 【parameters tab As shown in Figure 6.3 appears to edit the database configuration】 【General Information tab. 6.3.2】 【memory parameters tab As shown in Figure 6.4 for editing the data...

394: Initialization parameter file Oracle 9i
6.2.1 Pfile document Pfile (Parameter File) file format is based on the parameters of the text file containing database configuration parameters. Oracle 9i is installed for each database when the establishment of a Pfile, the name of the default &...

395: Oracle 9i to ensure the normal operation of the network
Oracle 9i a complete operation network, including the following four parts. Database server 】 【Management Server Oracle HTTP Server Management client 6.1.1 to ensure the normal operation of the database server To ensure the normal operatio...

396: Oracle 9i through the IE browser to monitor and control - report
5.6.1 What is the definition of the report 】 【Management Server database server on the collection of the various operating parameters. What kind of methods in accordance with the collection of database servers running on the parameters, called ...

397: Oracle 9i management Web-based
5.5.1 Based on the principles of Web Management 1. Client Client operating system for Windows 2000, Windows 98 or Windows NT, install the IE 5.0 browser or above to install Java plug-ins based on the Oracle JInitiator 1.1.8.10 and Applet technolog...

398: Management tasks to run automatically operating ─ ─
5.4.1 What is the operating Operation of some database servers is automated, standardized management. For example, from time to time to shut down or restart the database, the implementation of the database from time to time to restore or backup. 5...

399: Monitoring the operation of automatic incident ─ ─
5.3.1 What is the incident Events in the Oracle 9i database server on the definition, can monitor the server resources and processing tasks. Includes the following main content. 5.3.2 The role of incident System administrators can use the inciden...

400: How to manage Oracle 9i】 【Management Server administrator
5.2.1 the establishment of the administrator by default 【】 After the management server, the default Administrator account set up two, as shown in Table 5.1. Table 5.1 the default administrator Account Default password Permissions Role sys...


Page 20 of 37
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]   [36]   [37]