Timeline for Can database administrators access and modify the database before it's opened?
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 18, 2023 at 11:22 | vote | accept | Mehdi Charife | ||
| May 18, 2023 at 10:36 | comment | added | pmdba |
Creating datafiles in MOUNT mode is possible for specific maintenance operations, like recovering from a backup. For typical storage management - adding a file to a tablespace - the database is open. The specific command you want to use to add or manipulate the datafile: e.g., create database, alter database, alter tablespace, etc. will determine what mode the database must be in.
|
|
| May 18, 2023 at 10:33 | comment | added | Mehdi Charife | So, creating datafiles is not possible under MOUNT mode? Or should I look at the right documentation for my version to check if creating datafiles is considered as a maintenance operation? | |
| May 18, 2023 at 0:22 | history | edited | pmdba | CC BY-SA 4.0 |
added 456 characters in body
|
| May 18, 2023 at 0:11 | history | answered | pmdba | CC BY-SA 4.0 |