Oracle Database - Auto extend table space via enterprise manager console

Asked By farrukh on 22-Jun-12 05:04 AM
Hello All,

Please tell me how to extend the tablespace in oracle via enterprise manger ?


Thanks
hammeed
[)ia6l0 iii replied to farrukh on 22-Jun-12 01:09 PM
You should execute the following command in the Enterprise Manager Console to increase the tablespace.

Note the Alter Database command with the Resize switch.
ALTER DATABASE
DATAFILE '/u03/oradata/coxdata.dbf'
RESIZE 200M;


Alternatively, you can set AutoExtend while creating the tablespace itself. Please see below.
CREATE temporary TABLESPACE TEMPNAME TEMPFILE 'C:\ORACLE\APP\ORADATA\A\coxdata.tmp' SIZE 200m AUTOEXTEND on NEXT 10m maxsize 300m;

If you want to alter, execute this.
ALTER DATABASE TEMPFILE 'C:\ORACLE\APP\ORADATA\A\coxdata.tmp' AUTOEXTEND on NEXT 10m maxsize 300m; 

Hope this helps.
Jitendra Faye replied to farrukh on 25-Jun-12 02:29 AM
reference from-

http://mhabib.wordpress.com/2007/03/31/increase-the-size-of-tablespace/

solution-


You can do this by enterprise manager console. Increase the size of datafile for particular tablespace.

OR


For Example

ALTER DATABASE
DATAFILE ‘/u03/oradata/ userdata02. dbf’
RESIZE 200M;


If you don’t have any free space on that partition of disk then you can add another datafile on the other partition  for particular tablespace.


For example


ALTER TABLESPACE app_data
ADD DATAFILE ‘/u01/oradata/ userdata03. dbf’
SIZE 200M;

Now you can insert data with in this tablespace.


farrukh replied to [)ia6l0 iii on 13-Jul-12 11:12 AM