Tutorials to .com

Tutorials to .com » Database » Oracle » Oracle Tutorial

Oracle Tutorial Articles


121: WhohasalltheTEMPspace
WhohasalltheTEMPspace Who has all the TEMP space? This tip comes from Sivasubramanian Sundar, Oracle DBA at Sun Micro Systems, in Singapore. This small script will provide a list of users and which processes occupy space in the TEMP tablespace. T...

122: howtocreateanOracle8.0LogMinerDictionary
howtocreateanOracle8.0LogMinerDictionary Changing the Database Character Set or the Database National Character Set PURPOSE ======= To explain how to change the database character set or national character set of an existing Oracle8 (i) or Orac...

123: TSMServer, Client, TDPO Installation Configuration Notes (2)
TSMServer, Client, TDPO Installation Configuration Notes (2) TSM Server, Client, TDPO Installation Configuration Notes (2) ...

124: The realization of the mysteries of high-availability design
The realization of the mysteries of high-availability design The realization of the mysteries of high-availability design Author: Matthieu Devin compiled this article from the: Microsoft High-availability requirements of an appropriate infrastruc...

125: The realization of the mysteries of high-availability design
The realization of the mysteries of high-availability design The realization of the mysteries of high-availability design Author: Matthieu Devin compiled this article from the: Microsoft High-availability requirements of an appropriate infrastruc...

126: Oracle introduced the system utility
Oracle introduced the system utility Oracle introduced the system utility (Source: chinesehack.net 2003.06.10) 1, application development (Application Development) SQL * Plus E: \ Oracle \ Ora81 \ BIN \ SQLPLUSW.EXE 2, database management (Data...

127: Create and use partition table
Create and use partition table Create and use partition table ORACLE years in particular if they are a big table, you can use the partition table to change the performance of their applications. Landing system status to the database, view the v $...

128: TemporaryTables
TemporaryTables Temporary Tables Here is another feature I found interesting that was introduced in Oracle 8i. Temporary tables, yep temporary tables. You may say, whats the big deal, I was creating temporary tables from before, whats new now. The...

129: Create a database of UNIX SHELL script
Create a database of UNIX SHELL script Create a database of UNIX SHELL script A script: newapp1.sh #! / bin / sh ORACLE_SID = app1 export ORACLE_SID / opt/oracle/product/8.1.7/bin/svrmgrl <<EOF spool / opt/oracle/product/8.1.7/install/c...

130: Table foreign key constraint
Table foreign key constraint Table foreign key constraint FK constraints are foreign key fields are allowed to be empty 1. Create a test table SQL> create table lesson (lesson_name varchar2 (20), classroom varchar2 (10)); Table has been crea...

131: Oracle installation, the frequent use of the modified form of the SQL code space
Oracle installation, the frequent use of the modified form of the SQL code space Oracle installation, the frequent use of the modified form of the SQL code space Configurations: Chinese version of Windows NT 4.0 10.2GB SCSI Hard Drive 5 minutes:...

132: UsingNIDtoChangeDBName
UsingNIDtoChangeDBName Using NID to Change DB Name This tip comes from Darl Kuhn, DBA at Sun Microsystems, in Broomfield, CO. Description: Prior to Oracle9i Database Release 2, you were required to rebuild the controlfile to rename your database....

133: ORACLE management of user connections
ORACLE management of user connections ORACLE management of user connections By system administrators to see the current database there are several user connections: SQL> select username, sid, serial # from v $ session; If you want to stop a c...

134: UseScannerUtilitybeforeAlteringtheDataba
UseScannerUtilitybeforeAlteringtheDatabaseCharacterSet Use Scanner Utility before Altering the Database Character Set A) Purpose. ----------- Before altering the character set of a database, check the convertibility of the data before convertin...

135: UseScannerUtilitybeforeAlteringtheDataba
UseScannerUtilitybeforeAlteringtheDatabaseCharacterSet Use Scanner Utility before Altering the Database Character Set A) Purpose. ----------- Before altering the character set of a database, check the convertibility of the data before convertin...

136: Installed in RedHatAdvancedServer2.1 meeting the needs of oracle817
Oracle817 in RedHatAdvancedServer2.1 need to install the patch In Red Hat Advanced Server 2.1 to install the patch need to oracle 817 AS2.1 installed directly in the oracle817, occur link error, it will be less than Bahrain. Metalink on the search...

137: Rapid elimination of line relocation table
Rapid elimination of line relocation table Rapid elimination of line relocation table Author: chao_ping Row Migration, which is an important Oracle basic concepts. Traditional sense, we need to eliminate the line relocation. Because of this, wil...

138: Linux install oracle9i repair the link errors
Linux install oracle9i repair the link errors How to calculate a table the size of the space occupied 1. View Record Size SQL> analyze table tl_indb_err_cn001 compute statistics; Table analyzed SQL> select * from user_tables t where t.tab...

139: In the ORACLE user name in the reconstruction of the index by the method of
In the ORACLE user name in the reconstruction of the index by the method of In the ORACLE user name in the reconstruction of the index by the method of If you are under the management of some of the ORACLE database applications a large number of a...

140: Win2000Server on how to uninstall completely Oracle8.17
Win2000Server on how to uninstall completely Oracle8.17 Win2000 Server on how to completely uninstall Oracle 8.17 Software environment: 1, Windows 2000 + ORACLE 8.1.7 2, ORACLE installation path: C: \ ORACLE Method: 1, Start -> Settings -&g...


Page 7 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]