Can there be more than one datafile per tablespace?

Options
- Yes
- No


CORRECT ANSWER : Yes

Discussion Board
Datafile

Yes, there can be more than one datafile per tablespace. When a schema object such as a table or index is created, its segment is created within a designated tablespace in the database. For example, suppose you create a table in a specific tablespace using the CREATE TABLE command with the TABLESPACE option. Oracle allocates the space for this table's data segment in one or more of the datafiles that constitute the specified tablespace. An object's segment allocates space in only one tablespace of a database.

Prajakta Pandit 02-17-2017 01:29 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement