The specific methods for creating a database are: With Database Configuration Assistant (DBCA), a graphical tool. With the CREATE DATABASE SQL statement. 1. Specify an Instance Identifier (SID) The ORACLE_SID environment variable is used to distinguish this instance from other Oracle Database instances on the same host computer. 2. Ensure That the Required Environment Variables Are Set 3. Choose a Database … Read more
Normally if you are trying to shrink a compressed table lets say you get below error, and the trick to solve it is below :- For partition tables and for normal tables There are two possibilities:1: The SHRINK clause is not valid on a compressed table and you will get ORA-10635 . (b) Autosegment space … Read more
Space allocation in the UNDO tablespace is unique and does not follow the same rules as normal tablespaces. Data within the tablespace frequently grows and shrinks throughout the life of the instance. There are three categories of blocks in the UNDO tablespace: Active, unexpired and expired Active: Blocks that contain active UNDO data for active … Read more