Home » RDBMS Server » Server Administration » user tablespace resizinng (oracle 10g . windows2000)
user tablespace resizinng [message #340009] Mon, 11 August 2008 00:13 Go to next message
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 #340010 is a reply to message #340009] Mon, 11 August 2008 00:18 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Tell me how to make my pig fly.
I wait your response.
Re: user tablespace resizinng [message #340016 is a reply to message #340009] Mon, 11 August 2008 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64107
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Please guide me how to reduce USER TS


Remove the data the data that are "beyond requested RESIZE value".

Regards
Michel
Re: user tablespace resizinng [message #340047 is a reply to message #340009] Mon, 11 August 2008 03:42 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

And...Search on google for ORA-03297 error.
Re: user tablespace resizinng [message #340200 is a reply to message #340016] Mon, 11 August 2008 23:04 Go to previous messageGo to next message
hasanshaw
Messages: 8
Registered: June 2008
Location: pakistan
Junior Member
Michal,

hot to Remove the data the data that are "beyond requested RESIZE value".


Please guide me in detail


Regards,

Hasan
Re: user tablespace resizinng [message #340201 is a reply to message #340009] Mon, 11 August 2008 23:06 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>hot to Remove the data the data that are "beyond requested RESIZE value".
First you need to identify the objects which reside above RESIZE value.
Re: user tablespace resizinng [message #340357 is a reply to message #340200] Tue, 12 August 2008 08:12 Go to previous message
joy_division
Messages: 4640
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.
Previous Topic: Database Migration
Next Topic: Problem with initjvm.sql and rmjvm.sql
Goto Forum:
  


Current Time: Mon Dec 05 04:44:17 CST 2016

Total time taken to generate the page: 0.09326 seconds