It is very important for a database management system to offer many tools that help database administrators work more efficiently, freeing them for more strategic and creative tasks. Oracle Database 10g really is that big of a deal for databases administrators. In this paper, I will provide brief, focused analyses of these interesting new tools and techniques for managing schema objects. The goal is to outline the functions and benefits of the feature so that you can put it into action in your environment as quickly as possible. The paper is a case study to determine appropriate table types for our requirements: heap, partition, IOT or cluster. In addition, the paper contains a description of four databases administrator’s tasks for schema management