Oracle DBA基础培训课件.ppt

Oracle Database 10g: 2 Day DBA for Windows 1-* Viewing the Attributes of a Table To use Enterprise Manager to view the attributes of a table: 1. Click the Tables link in the Schema region of the Database Administration page. 2. Select a table from the Results list, and then click the View button to see the attributes of the table. Oracle Database 10g: 2 Day DBA for Windows 1-* Viewing the Contents of a Table To use Enterprise Manager to view the rows in a table: 1. Select the table on the Tables page, select View Data from the Actions menu, and then click Go.The “View Data for Table” page appears. The row data for the table is shown in the Results region. The Query box displays the SQL query that was executed to produce the results. 2. Click any column name and sort the data in the column in either ascending or descending order. If you want to change the query, click the Refine Query button. On the Refine Query for Table page, you can select the columns that you want to display and specify a WHERE clause for the SQL statement to limit the results. For more information about WHERE clauses in SQL statements, refer to the Oracle Database SQL Reference. Oracle Database 10g: 2 Day DBA for Windows 1-* Dropping a Table If you no longer need a table in your database, you can drop the table. When you drop a table, the following occur: The table definition is removed from the data dictionary. All rows of the table are removed. All indexes defined on the table are removed. You can drop (delete) a table by using Enterprise Manager: 1. Select Tables in the Schema region of the Administration page. 2. Enter the schema name and table name, or use the search facility to select the table. Select Delete. 3. The Confirmation page enables you to choose whether to continue the operation. Click Yes if you have identified the correct table to delete. 4. A confirmation message appears if the table has been successfully deleted. If you find later that you dropped a table in error, yo