Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are Table Space, Data files, parameter file, control files?

April 26, 2017CONTROL Data file files parameter Table

0

Posted

What are Table Space, Data files, parameter file, control files?

1 Answer

0

Posted

A22) Table space: The table space is useful for storing the data in the database. When a database is created two table spaces are created. a) System Table space : This data file stores all the tables related to the system and dba tables. b) User Table Space: This data file stores all the user related tables. We should have separate table spaces for storing the tables and indexes so that the access is fast. Data files : Every oracle Data base has one or more physical data files. They store the data for the database. Every datafile is associated with only one database. Once the data file is created the size can not change. To increase the size of the database to store more data we have to add data file. Parameter file:Parameter file is needed to start an instance. A parameter file contains the list of instance configuration parameters e.g. db_block_buffers = 500 db_name = ORA7 db_domain = u.s.acme lang Control files : Control files record the physical structure of the data files and redo