| user tablespace resizinng [message #340009] |
Mon, 11 August 2008 00:13  |
hasanshaw
Messages: 8
Registered: June 2008
Location: pakistan
|
Junior Member |
|
|
Previously i have USER tablespace of size 100gb (oracle 10g).
Now I move these tables in anoter tablespace that leads almost 50gb free space in USER TS.
Now I m trying to reduce size of USER TS. When I issue command to resize USER TS
It gives me error
Failed to commit: ORA-03297: file contains used data beyond requested RESIZE value
Please guide me how to reduce USER TS
Regards,
Hasan
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: user tablespace resizinng [message #340357 is a reply to message #340200] |
Tue, 12 August 2008 08:12  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
Easiest way is to do like anacedent suggested and identify the objects, then move them to another tablespace (beware of the implications of moving objects to other tablepaces).
You can identify them by looking at DBA_EXTENTS.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
