tablespace resize [message #549271] |
Thu, 29 March 2012 05:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/0d8d54604424af68f3c669fe2bc54c02?s=64&d=mm&r=g) |
neetesh87
Messages: 280 Registered: September 2011 Location: bhopal
|
Senior Member |
|
|
respect to all,
i have a "prj_tbl" named tablespace in a user's schema in my database. i have given 100mb size to the "prj_tbl" at the time of its creation and auto extend is open for 10mb,and now this tablespace is using nearly 3.6mb space for its data and remaining space is free,now i want to reduce the size of "prj_tbl" tablespace to 20mb and when i tried to resize it then ,
it throws an error- "'ora-03297 file contains used data beyond requested resize value oracle"
i think this message showing that my new size is small than the size of data on my tablespace but it shows free space nearly 96mb then it means my new size is larger than the size of data on tablespace.then please tell me how should i reduce the size. thanx in advance.
|
|
|
|
|
|
|
Re: tablespace resize [message #549335 is a reply to message #549330] |
Thu, 29 March 2012 10:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68648 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Never use events when you do not knw what it is for.
New question, create a new topic.
For the script, you're right it currently does not handles queue table, I note it and will fix it.
Regards
Michel
|
|
|