Nothing but my learning and experience with Oracle..!

An Oracle user is always granted to drop their own objects. To prevent a user to drop their own objects, we can use DDL triggers. Here...

Creating a simulation of block corruption and recovering it through RMAN in linux 1.Before proceeding with block corruption simulation ta...

Dba_data_files: The dba_data_files means total size of the data file. The data file size is total number of the dba_free_space + dba_segmen...

Each session in your database has a limited number of database links  that can be opened at the same time.If you access a database link in ...

You can user merge command to perform inserts and updates into single table in a single command .Based on the condition you specify ,oracle...