-
Happy New Year to All!
I have two tablespaces and each contains 8 datafiles with size 50M. I want to make these two tablespaces contain two datafiles on each tablespace with size 2G in the same location. What is a safe and quick way to accomplish this goal? Thanks!
-
drop and recreate tablespace
-
before you drop and recreate tablespace,
export the tablespace ( all segments in it), drop tablespace with contents.
Then delete the datefiles, recreate tablespace with the same name, do import.
-
to dwang and pando
Thanks for your respond and help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|