Computer Science - Database Systems - Discussion
Discussion Forum : Database Systems - Section 2 (Q.No. 14)
14.
In SQL, the ALTER TABLESPACE command is used
Discussion:
1 comments Page 1 of 1.
Deepak said:
9 years ago
If you have ALTER TABLESPACE system privilege, then you can perform any ALTER TABLESPACE operation. If you have MANAGE TABLESPACE system privilege, then you can only perform the following operations:
1. Take the tablespace online or offline.
2. Begin or end a backup.
3. Make the tablespace read only or read-write.
1. Take the tablespace online or offline.
2. Begin or end a backup.
3. Make the tablespace read only or read-write.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers