enlarge tablespace

[jlaudirt]

Environment information:
* Oracle version: 10g
* Operating system: RedHat Enterprise


I need to know how to increase a tablespace. You are currently 900mb. The system is accusing use in 87% of Tablespace.


From now on, thank you ...

[Tupi]

The command is this:

Select all

ALTER DATABASE DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXPLO.DBF' RESIZE 23M

After the resize you boot for what size you want to increase in my case is 23 you can paste 12g by exeple.


Anything is only question.

Embrace

[Tupi]

The best is for selfextend to not have to perceive with in the middle of the night the tablespace run out of space.

[diegoleite]

Friend,

I recommend the local management of extent as well as Maximum Datafile 1500m size.

Oracle recommends 2000m.

Select all

CREATE  
 TABLESPACE t_data 
 LOGGING 
 DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\data1.dbf' SIZE 10M AUTOEXTEND ON NEXT 100M MAXSIZE 1500M 
 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;