-
Question on drop tablespace
I would like to ask what does including contents really mean? what does the contents represent?
DROP TABLESPACE tools
INCLUDING CONTENTS;
-
any objects which are stored in that tablespace - shuld also have 'and datafiles' to delete the os file
-
Does it support Oracle version 8.0.4?
-
It's not a command I'd use on db that I really cared about. Better to look in DBA_SEGMENTS and drop or move the objects until the DROP command works without using INCLUDING CONTENTS. That way you'll know what went out of the window.
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
|