Oracle : Storage Management

STORAGE MANAGEMENT     In oracle, database space demanding objects are called segments. There are 5 different segments i.e. tables, indexes, temporary, undo, rollback segments.     Within a single server, we can create multiple database. Database contains one or more tablespace. One tablespace can… Read More

Oracle : TABLESPACE MANAGEMENT

TABLESPACE MANAGEMENT WHAT IS TABLESPACE ? IT’S A LOGICAL LINK BETWEEN USER AND DATAFILES.IT IS LOGICAL STORAGE OF DATA   DICTIONARY: EXTENTS INFORMATION WILL GET FROM BASE TABLES LOCAL: EXTENTS INFORMATION WILL GET FROM DATAFILE HEADERS TABLESPACE MANAGEMENT   HOW TO CREATE THE TABLESPACE SYS>>… Read More