How do you add a data file to a tablespace?
ALTER TABLESPACE ADD DATAFILE <datafile_name> SIZE <size>
View answer Workspace Report Error Discuss
What does coalescing a tablespace do?
Coalescing is only valid for dictionary-managed tablespaces and de-fragments space by combining neighboring free extents into large single extents.
What do you mean by a tablespace?
- These are the Logical Storage Units into which a database is divided.- It is used to group together the related logical structures.