Home » RDBMS Server » Server Administration » How to Alter Tablespace/s in oracle? (11.2.0.1.0G,Window 7 (32bit))
How to Alter Tablespace/s in oracle? [message #578291] Tue, 26 February 2013 10:49 Go to next message
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
Re: How to Alter Tablespace/s in oracle? [message #578292 is a reply to message #578291] Tue, 26 February 2013 10:55 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How to Alter Tablespace/s in oracle? [message #578294 is a reply to message #578292] Tue, 26 February 2013 11:08 Go to previous messageGo to next message
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
Re: How to Alter Tablespace/s in oracle? [message #578295 is a reply to message #578294] Tue, 26 February 2013 11:14 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
Senior Member
when all else fails Read The Fine Manual

http://www.oracle.com/pls/db112/search?remark=quick_search&word=alter+tablespace
Re: How to Alter Tablespace/s in oracle? [message #578297 is a reply to message #578295] Tue, 26 February 2013 11:33 Go to previous message
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
Previous Topic: uncommit change and redo record ?
Next Topic: Strange alters in alert.log
Goto Forum:
  


Current Time: Tue Sep 02 00:08:42 CDT 2014

Total time taken to generate the page: 0.08817 seconds