oracle 9i

In actual work, developers often accidentally delete an important table. At this time, they will find the Administrator to retrieve the deleted table. The specific scenarios are as follows:1. Developers:SQL> conn usr1/usr1Connected.SQL> create table t (id int, name varchar2 (10 ));Table created.SQL> insert into t values (0, yejun0 );1 row created.SQL> insert into t values (1, yejun1 );1 row created.SQL> commit;Commit complete.SQL>.........................After a while.........................2.

Oracle different versions of Official documents online reference and packaging Download The address summary, listed here, for your reference.1.9iOracle Official Document1) Online BrowsingHttp://www.oracle.com/pls/db92/homepage2 download in hand, reference worry-freeOracle9i Database Release 1 (9.0.1) documentationHttp://www.oracle.com/technology/documentation/Oracle9i_arch_901.htmlOracle9i Database Release 2 (9.2) DocumentationHttp://www.oracle.com/te

placed in the same physical order as the most commonly used indexes.(3) Oracle SQL uses table indexes to use hint hints with bitmap indexesOracle internal structure and disk I/O (1) db_file_mutltiblock_read_count and disk I/O Db_file_mutltiblock_read_count: This parameter controls the reading when a continuous long block of data is requested According to the speed of the block. This parameter has an important relationship with Db_block_size. At the

AIX 5.3 Install Oracle 10g RAC Error Collection--9i RAC PresentSystem environment:Operating System: AIX 5300-08Cluster Software: CRS 10.2.0.1Database: Oracle 10.2.0.1System Architecture Diagram650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/26/9D/wKioL1NsV8Lw9ekFAAFqCT5td6k081.jpg "title=" r2.jpg "alt=" Wkiol1nsv8lw9ekfaafqct5td6k081.jpg "/>Failure phe

A brief introduction to Oracle 9i's 16 types of data Oracle 9i provides a total of 16 scalar data types, as shown below. 　　the scalar data type name meaning of Oracle 9i Char is used to describe fixed-length character data, length VARCHAR2 used to describe variable-le

Oracle uses PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX in PROFILE to determine whether the password can be reused and the restrictions on Password reuse. However, after testing, I found that the description in the Oracle administrator guide is incorrect. I checked METALINK, although the two parameters are described in detail in an article on METALINK, some descriptions are still incorrect. PASSWORD_REUSE_TI

20030102 Aaah2oaaiaaaabsaao 20030103 Aaah2oaaiaaaabsaap 20030104 ――――――――――――――――――――――――――――――――――――― Oracle 9i-Supported indexes The indexes in Oracle 9i can be grouped into two broad categories: B-Tree indexes and bitmap indexes. Table 7.9 B-Tree Index classification Name Meaning Non-

connection pool, use kill session to manually disconnect the connection. ORA-00028 your session has been killed Yes Use the connection pool and kill session to manually disconnect all connections ORA-03114: not connected to oralce No. The connection pool is damaged and only the process is restarted. This error is displayed when reconnecting: ORA-00022 invalid session ID; Access Denied Use the connection pool and kill session to manually disconnect the connection po

oracle| process Many beginners install Oracle, do not know how to configure Enterprise Manager, can not go in, because this kind of problem see much, now I write down the detailed process: 1: Start-> Program->oracle->configuration and Migration tools->enterprise Manager Configuration Assistant 2: Configure local oraclemanagementserver-> next-> create a new da

oracle| Index In oracle9i we know that we can use the Jump Index Scan (index Skip Scan). However, there are some limitations to the use of jumping index scans. From Oracle's documentation we can find this: Index Skip Scans Index skip scans improve index scans by Nonprefix columns. Often, scanning index blocks is faster than scanning table data blocks. Skip scanning lets a composite index is split logically into smaller subindexes. In skip scanning,

that returns a single value The Executeoraclescalar () method of the OracleCommand class is used to execute an SQL statement or stored procedure that returns a single value as a OracleType data type. If the command returns a result set, the method returns the value of the first column in the first row. If ref CURSOR is returned, rather than returning the value of the first row of the first column pointed to by ref CURSOR, the method returns a null reference. The ExecuteScalar () method of the O

command, as shown in Figure 3.19. (5) The "Save work separate as" interface appears as shown in Figure 3.20. 3.4.3 the use of "Enterprise Manager" 1. Independent Login (1) The Oracle Enterprise Manager console interface appears as shown in Figure 3.21. (2) The "Enterprise Manager after standalone startup" interface appears as shown in Figure 3.22. (2) "Menu bar" has 6 items. (3) There are 6 shortcut buttons in the shortcut button area, as shown i

/92010Sol_Disk2.cpio.gz Http://download.oracle.com/otn/solaris/oracle9i/9201/92010Sol_Disk3.cpio.gz Oracle9i Database Release 2 Enterprise/Standard Edition for Sun iSCSI Solaris (64-bit) Http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk1.cpio.gz Http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk2.cpio.gz Http://download.oracle.com/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.Disk3.cpio.gz