Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to drop users tablespace

650105Feb 16 2009 — edited Feb 17 2009

Hey to all
I want to drop USER tablespace wid data file but as we know many oracle users Scott OE data reside in users. How can I protect their data. One method which I read on net to export and import once again is quite cumbersome I run this query

SELECT
owner
, segment_name
, segment_type
FROM
dba_segments
WHERE
tablespace_name='USERS'

it give me two user OE and SCOTT. How can I protect their data before drop the user tablespace

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 17 2009

Added on Feb 16 2009

#general-database-discussions

13 comments

1,757 views