Unless it's your TEMP tablespace, of course ;)

Cheers,
Leila.

>>> "chao_ping" <[Email Address Removed] 10/31/02 03:32pm >>>
Bernita Joseph,
hi,do:
select owner,segment_name,segment_type from dba_segments where tablespace_name='THE NAME OF THE TABLESPACE THAT YOUR WANT TO DROP';
If it shows that no other segment is using this tablespace, you can safely drop this tablespace.



Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[Email Address Removed]
www.happyit.net


======= 2002-10-30 17:08:00 ,you wrote =======

>Hi all,
>
>I used the export utility to export the objects from let say user1.
>Then I deleted the user1 since I have been asked to remove
>from the database.
>
>Now user1's tablespace still remaining online. Can I delete the
>tablespace? Will that cause any problems to other schemas?
>How can I make sure that the tablespace used by user1 is not
>shared by any other users?
>
>Thanks!
>
>--------
>Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed]
>To subscribe: send a blank email to oracledba-[Email Address Removed]
>Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html

= = = = = = = = = = = = = = = = = = = =





--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed]
To subscribe: send a blank email to oracledba-[Email Address Removed]
Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page