- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Delete or reduce a file in oracle
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-14-2002 02:04 AM
тАО10-14-2002 02:04 AM
Delete or reduce a file in oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2002 02:25 AM
тАО10-14-2002 02:25 AM
Re: Delete or reduce a file in oracle
ALTER DATABASE DATAFILE '
this expands or reduces the file to the new size if possible.
If the file contains data you have to drop or remove this objects.
If you dont care about the data drop the tablespace and recreate it with new size.
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2002 02:46 AM
тАО10-14-2002 02:46 AM
Re: Delete or reduce a file in oracle
Use
DROP TABLESPACE your_ts INCLUDING CONTENTS;
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2002 02:48 AM
тАО10-14-2002 02:48 AM
Re: Delete or reduce a file in oracle
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2002 02:54 AM
тАО10-14-2002 02:54 AM
Re: Delete or reduce a file in oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2002 06:40 AM
тАО10-14-2002 06:40 AM
Re: Delete or reduce a file in oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2002 04:14 PM
тАО10-14-2002 04:14 PM
Re: Delete or reduce a file in oracle
To do something like this, you would need to find the objects in the datafile with a command like the following:
select segment_name from dba_extents where block_id = (select max(block_id) from dba_extents where file_id =
You will need to get the file number from dba_data_files for the file you are trying to reduce. This would give you the object that you need to move next. Once this object is rebuilt to another datafile, you would need to reduce the datafile again, and find the next object to move.
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2002 11:19 PM
тАО10-14-2002 11:19 PM
Re: Delete or reduce a file in oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2002 06:07 AM
тАО10-15-2002 06:07 AM
Re: Delete or reduce a file in oracle
What you may want to do is
* export the tablespace
* drop the tablespace and remove the files.
* recreate the tablespace with the file(s) in the desired location and with the desired size.
* import the tablespace
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-15-2002 06:25 AM
тАО10-15-2002 06:25 AM