OraFAQ Forum: Server Administration » How to Alter Tablespace/s in oracle?

Home » RDBMS Server » Server Administration » How to Alter Tablespace/s in oracle? (11.2.0.1.0G,Window 7 (32bit))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Alter Tablespace/s in oracle? [message #578291]

Tue, 26 February 2013 10:49

taoqir.hassan
Messages: 16
Registered: February 2013
Location: LAHORE

Junior Member

Hi Gurus,
bellow is my tablespace information,
1-how can i alter/change the size of tablespaces?.
2-is any changing in tablespace size will effect the over all performance?

thanks
Taoqir

Tablespace ; Size (MB); Free (MB); % Free; % Used
------------------------------;----------;----------;----------;----------
USERS ; 5; 4; 80; 20
SYSAUX ; 600; 140.875; 23; 77
UNDOTBS1 ; 640; 114.125; 18; 82
SYSTEM ; 700; 28.3125; 4; 96
TEMP ; 64; 0; 0; 100

Report message to a moderator

Re: How to Alter Tablespace/s in oracle? [message #578292 is a reply to message #578291]

Tue, 26 February 2013 10:55

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

As you never feedback and thank those that help you in your previous topics, I don't think it is worth to help you further.
However I advice you to read:
Database 2 Day DBA
Database Concepts

Regards
Michel

Report message to a moderator

Re: How to Alter Tablespace/s in oracle? [message #578294 is a reply to message #578292]

Tue, 26 February 2013 11:08

taoqir.hassan
Messages: 16
Registered: February 2013
Location: LAHORE

Junior Member

Thanks Michel,
I realy apologized for not saying thanks to seniors,now from onwards i will be careful about this.
Thanks again

Taoqir

Report message to a moderator

Re: How to Alter Tablespace/s in oracle? [message #578295 is a reply to message #578294]

Tue, 26 February 2013 11:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when all else fails Read The Fine Manual

http://www.oracle.com/pls/db112/search?remark=quick_search&word=alter+tablespace

Report message to a moderator

Re: How to Alter Tablespace/s in oracle? [message #578297 is a reply to message #578295]

Tue, 26 February 2013 11:33

taoqir.hassan
Messages: 16
Registered: February 2013
Location: LAHORE

Junior Member

thanks Michel i found solution from 'DATABASE 2DAY DBA'
I run this script accoding to my requirement

ALTER DATABASE
DATAFILE/TEMFILE 'C:%File_Location\TEMP01.DBF'
RESIZE 1024M;

now the recent information about tablespace

Tablespace                    ; Size (MB); Free (MB);    % Free;    % Used
------------------------------;----------;----------;----------;----------
USERS                         ;       100;        99;        99;         1
UNDOTBS1                      ;      1024;   807.125;        79;        21
TEMP                          ;       100;        36;        36;        64
SYSTEM                        ;      1024;  349.3125;        34;        66
SYSAUX                        ;       600;  138.4375;        23;        77

Thanks Michel and Black Swan

Best Regards;
Taoqir

Report message to a moderator

Previous Topic:	uncommit change and redo record ?
Next Topic:	Strange alters in alert.log

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 00:52:40 CST 2025