More than one datafile per tablespace - Oracle Architecture

Q.  Can there be more than one datafile per tablespace?
- Published on 30 Jul 15

a. Yes
b. No

ANSWER: Yes

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 27 Aug 15
    -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.

➨ Post your comment / Share knowledge


Enter the code shown above:

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