learn-oracle




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.
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.
 
Modifying Table Attributes

Oracle DBA can use Enterprise Manager to modify tables, such as adding and deleting columns or adding constraints.
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.
 

More Tutorials on Oracle dba ...


Liked it ? Want to share it ? Social Bookmarking

Add to: Mr. Wong Add to: BoniTrust Add to: Newsider Add to: Digg Add to: Del.icio.us Add to: Reddit Add to: Jumptags Add to: StumbleUpon Add to: Slashdot Add to: Netscape Add to: Furl Add to: Yahoo Add to: Spurl Add to: Google Add to: Blinklist Add to: Technorati Add to: Newsvine Information


Source : Website | Oracle DBA

Want to share or request Oracle Tutorial articles to become a Oracle DBA. Direct your requests to webmaster@oracleonline.info





   Forum
Oracle Forum   
Google

Oracle DBA Tutorial
Introduction
Installation
Oracle Enterprise Manager
Configuring client/server network
Database Instance
Database Storage Structures
DBA Accounts
Managing Oracle Objects
Backup & Recovery Concepts
Database Monitoring

SQL Statement Tuning
Backup and Recovery Concepts
Oracle 11g New Features
Oracle E Suite & Others
Oracle Data Guard
Oracle DBA FAQ