Oracle10g入门基本培训材料.ppt

Oracle Database 10g: 2 Day DBA for Windows 1-* Creating and Dropping Indexes To create a standard (B-tree) index on one column: 1. Click table in the Schema region of the Administration page. The Tables page appears. 2. Enter the table name or use the search facility to select the table. Select Create Index from the Actions drop-down menu. Click Go. 3. The Create Index page appears. Enter a name for the new index. Enter the tablespace name and select Standard B-tree as the index type. 4. Select the column in the list of table columns by entering 1 in the Order column. Accept ASC as the Sorting Order. Click OK to create the index. 5. After the index is created, the Indexes page appears with a confirmation message. The new index is listed under Results. Perform the following steps to drop an index: 1. Select Indexes in the Schema region of the Administration page. The Indexes page appears. 2. Enter the index name or use the search facility to locate the index. Click Delete. 3. If you are certain you have identified the correct index, click Yes on the Confirmation page. 4. A confirmation message appears if the index has been successfully deleted. Oracle Database 10g: 2 Day DBA for Windows 1-* Managing Views Views are customized presentations of data from one or more tables or other views. They can be thought of as stored queries. Views do not actually contain data, but instead they derive their data from the tables upon which they are based. These tables are referred to as the base tables of the view. Like tables, views can be queried, updated, inserted into, and deleted from with some restrictions. All operations that are performed on a view actually affect the base tables of the view. Views provide an additional level of security by restricting access to a predetermined set of rows and columns of a table. They also hide data complexity and store complex queries. You can click the Views link under the Schema heading on the Administration page to see the views