Database Administrator (DBA) Question:
Download Job Interview Questions and Answers PDF
How do you resize a data file?
Answer:
ALTER DATABASE DATAFILE <datafile_name> RESIZE <new_size>;
Download Database Administrator (DBA) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How do you add a data file to a tablespace? | What view would you use to look at the size of a data file? |