 Related Questions Latest Answer : A tablespace in Oracle database is logical grouping of physical datafiles. ... Latest Answer : IN 10g, there are two system table spaces called system and sysaux(auxillary) tablespace. These system tablespaces are backbone of database, and data base will not function at all without these tablespaces. They created at the time of creation and contained ... Latest Answer : The database is actually a collection of objects, which are made up of tablespaces and each tablespace must have datafile associate with it. The tablespace cannot be created without datafile. The tablespaces are two kind physical and logical.The logical ... Latest Answer : It can be, the only required option is that your tablespace have quota assigned to any user that want to store objects in it. ... It consists ofone or more data files.one or more control files.two or more redo log files.The Database containsmultiple users/schemasone or more rollback segmentsone or more tablespacesData dictionary Virtual Indexes are another undocumented feature used by Oracle. Virtual indexes, as the name suggests are pseudo-indexes that will not behave the same way that normal indexes behave, and are meant for View Question | Asked by : David Latest Answer : During the design phase of database, The tablesapce size is estimated by calculating the size of typical row of various tables that are going to reside in that tablespace multiplied by the number of expected rows inside the table. If any of the index ... Latest Answer : When Oracle allocates space to a segment (like a table or index), a group of contiguous free blocks, called an extent, is added to the segment. Metadata regarding extent allocation and unallocated extents are either stored in the data dictionary, or in ... Read Answers (2) | Asked by : shrihari Latest Answer : HiBase tables are made when the database is created and these tables are stored in data dictionary. these base tables contains the information related to the database. these tables are own by sys.the information in these tables is crypted and cannot ... Read Answers (1) | Asked by : richa chohan Latest Answer : select file_name, tablespace_namefromdba_data_files; ... Read Answers (3) | Asked by : sushil k
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 
1