Road To OCM
Thursday, December 20, 2012
Oracle tablespace from uniform to autoallocate
There is no "
alter tablespace
" syntax for changing it
You must re-define the tablespace to change the extent management:
Backup the tablespace
Export the tablespace data
Drop and re-allocate the tablespace
Import the tablespace
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment