§         Transfer of tables (partitions/subpartitions). Automatic detection of available tablespaces for transfer (by mask, taking account of statuses, availability of free space and previously planned jobs)

§         Automatic rebuilding of indexes invalidated during the transfer of tables  or their partitions (subpartitions)

§         Calculation of the necessary space for transferring or rebuilding with respect to the index compression factor during the transfer and a full list of planned jobs

§         Quick creation of tablespaces, automatic naming

§         Adding and extending files, automatic naming

§         Splitting, exchange and removal of table partitions. Support of partitioning by various criteria (dates, intervals). Automatic creation of tables for exchange. Existence of global indexes is also taken into account

§         Granting and revocation of system or object privileges using lists. Simultaneous assignment of corresponding privileges to base documents

§         User creation and editing. Simultaneous saving of the description, base document, password generation and saving

§         Conversion of tablespaces into RO/RW modes using lists

§         Parallel command execution (all table changes (e.g. transfer or splitting) during the first step, rebuilding of all related indexes on the second step). If the amount of work is significant and hardware resources are available, the system idle time is substantially decreased

§         Automatic recompilation of invalidated objects
 

The advantage of automation is obvious even if you have a relatively small number of tasks for user creation, distribution of access privileges and other regular tasks. All these tasks can be completed even by Oracle rookies that have no deep knowledge of SQL syntax and don’t even know passwords! It enables you to delegate routine and tedious tasks to night shifters, which substantially cuts operation expenses and frees up a lot of personal and night :) time!