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..

Managing Redo Logfiles in Oracle database 11gR2 Brief about the Redo logfiles in an Oracle databases it should contain atleast 2 redo logfile group as mandatory & Oracle writes every statement expect the select statement, Example – update etc, The Oracle writes to the datafile in case if there is power failure or any system Read More