- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: deleting a tablespace
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2002 10:47 PM
тАО10-15-2002 10:47 PM
deleting a tablespace
Now one instance of the oracle storage manager is still deleting the tablespace, but if i open another storage manager and look this tablespace it show me like if it has 4.8 Gb of data. Why?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2002 12:03 AM
тАО10-16-2002 12:03 AM
Re: deleting a tablespace
I'm not quite clear on this. How exactly are you "deleting" the tablespace ?
Regards,
Tom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2002 12:23 AM
тАО10-16-2002 12:23 AM
Re: deleting a tablespace
Thanks in advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2002 02:50 AM
тАО10-16-2002 02:50 AM
Re: deleting a tablespace
This sounds like the behavior you would have when someone is doing an action that has not been committed yet. Now, in the versions of Oracle I have (seen), this would not be the case for the dropping of tablespaces, since those actions do not need commits. However, I have heard - I'm no longer a DBA but used to be - that very recent releases of Oracle support commit/rollback for this kind of action too. What version of Oracle are you running ?
Regards,
Tom
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2002 02:53 AM
тАО10-16-2002 02:53 AM
Re: deleting a tablespace
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2002 02:53 AM
тАО10-16-2002 02:53 AM
Re: deleting a tablespace
When you delete the objects from the tablespace the space is not released.
Only when you truncate or drop the objects the free space is re-claimed by the tablespace.
If you want to reclaim the space in the tablespace export the objects from the tablespace
drop the objects
recreate the objects by importing the objects from the export file.
Thanks
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2002 10:37 PM
тАО10-16-2002 10:37 PM
Re: deleting a tablespace
??can anybody help me?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2002 10:55 PM
тАО10-16-2002 10:55 PM
Re: deleting a tablespace
connect as system using SQLPLUS and run the following SQL commands (you should get the list of objects residing on the tablespace you are trying to delete)
select substr(owner,1,20) owner,
substr(table_name,1,20) "Table name"
from dba_tables
where tablespace_name = 'TBS1'
select substr(owner,1,20) owner,
substr(table_name,1,20) "Table name"
from dba_indexes
where tablespace_name = '
and also (since it can also be temporary objects too):
select username
from dba_users
where default_tablespace='
or temporary_tablespace='
[NB. substitute TBS1 for the tablespace in question here]
and finally, the output generated by the attached script (free.sql).
Post your results! SQLPLUS queries will give us the right picture.
Regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2002 11:08 PM
тАО10-16-2002 11:08 PM