Recycle bin concept in Oracle database 11gR2 Recycle bin is similar to windows recyclebin in Oracle database & here the entire drop object is stored in FLASHBACK Area As per my recycle bin its a virtual where all the dropped objects reside in it, It occupy the exact space as when they are created in Read More

Truncate all the tables data from the Oracle schema in Oracle database 11gR2 sys@TESTDB>;create user mir identified by mirhassan123; User created. sys@TESTDB>;grant connect,resource to mir; Grant succeeded. sys@TESTDB>;conn mir Enter password: Connected. mir@TESTDB>;sho user USER… Read more..

Managing the UNDO TABLESPACE in Oracle database 11gR2 In an Oracle DB the undo tbs is used for maintaining the information that is used to rollback or any undo changes to the database. The Undo records are more used as shown below: Rollback the transactions when a ROLLBACK statement is issued Recover… Read more..

Managing Multiplexing of Control Files in Oracle database 11gR2 As per the Oracle DB, every db has its own controlfile; the control file is a binary file that records the physical structure of the db  The control file contains: The database name Name & location of datafiles… Read more..

Managing Temporary Tablespaces in Oracle database 11gR2 The temporary tablespace is basically used for sorting the large tables in database & database should contain 1 temp tbs in it, this temp tbs are created while creation of the database itself, Therefore if it requires you can create multiple temp tbs in the database. sys@TESTDB>… Read Read More

Increase or decrease the size of Tablespace and Datafiles in Oracle database 11gR2  To Increase/extend the Size of a tablespace Method 1 – Increase/Extend the size of the tbs using the resize keyword as shown below: sys@TESTDB> select INSTANCE_NAME, VERSION from v$instance; INSTANCE_NAME   … Read more..