 Related Questions A database is divided into Logical Storage Unit called tablespaces. A tablespace is used to grouped related logical structures together. Latest Answer : It is a Logical area of storage in a Database, that directly corresponds to one or more physical files. ... Every ORACLE database contains a tablespace named SYSTEM, which is automatically created when the database is created. The SYSTEM tablespace always contains the data dictionary tables for the entire database. Latest Answer : Every Oracle Database contains a tablespace called system tablespace.This tablespace gets created at the time of database creation and it holds data dictionary information for the entire database. ... Each databases logically divided into one or more tablespaces one or more data files are explicitly created for each tablespace. Latest Answer : Databases, tablespaces, and datafiles are closely related, but they have important differences:1) An Oracle database consists of at least two logical storage units called tablespaces, which collectively store all of the database's data. You must have ... Yes. A data file can be associated with only one database. Once created a data file can't change size.One or more data files form a logical unit of database storage called a tablespace. Latest Answer : Oracle architecture: Database->Tablespace->DatafilesData ... Latest Answer : All Extent info is maintained in Dictionary which is infact a dis-advantage, Also in case of a huge insert operation undo is generated. ... Read Answers (4) | Asked by : Ashu Shukla
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0