Managing Oracle Objects

Managing Tables

To view a table, click Tables on the Administration page of Enterprise Manager. Initially, Oracle DBA see the tables for the schema that Oracle DBA are logged into. Click on the above link to read more and to become a Oracle DBA.

Creating Tables

Oracle DBA can use Enterprise Manager to create tables. Oracle DBA can do so as a system administrator or user with the CONNECT role. Click on the above link to read more and to become a Oracle DBA.

Modifying Table Attributes

Oracle DBA can use Enterprise Manager to modify tables, such as adding and deleting columns or adding constraints. Click on the above link to read more and to become a Oracle DBA.

Managing Indexes

Indexes are optional structures associated with tables. They can be created to improve query performance. Just as the index in this book helps Oracle DBA to quickly locate specific information, an Oracle index provides a quick access path to table data. Click on the above link to read more and to become a Oracle DBA.

More Tutorials on Oracle dba ...

Liked it ? Want to share it ? Social Bookmarking