Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

Oracle training Weblogic Book
Easy Oracle Jumpstart
Oracle training & performance tuning books
Burleson Consulting Remote DB Administration
Reply to this topicStart new topic
> Adding datafile to tablespace if % of space left is less than 10%
post Apr 14 2017, 03:48 PM
Post #1


Group: Members
Posts: 1
Joined: 14-April 17
Member No.: 51,906

can anyone suggest script?
Attached File(s)
Attached File  Capture.PNG ( 9.64K ) Number of downloads: 3
Go to the top of the page
+Quote Post
post Apr 17 2017, 07:44 AM
Post #2


Group: Members
Posts: 2
Joined: 17-April 17
From: bangalore
Member No.: 51,911

QUOTE (Keerti @ Apr 15 2017, 02:18 AM) *
can anyone suggest script?

Hi Keerti,

As per the screen shot you have given here. There seems to be with the tablespace name ('exit;'), which is non-existent in the database.

Normally you can add a datafile to any existing tablespace name in the below format:


alter tablespace '&existing_tbs_name' add datafile '+<DG_NAME>' size 100M autoxtend on 50M maxsize unlimited;


maxsize unlimited --> your datafile will grow until the file size limit based on your db_block_size --> if db_block_size is set to 8K then your datafile will grow till 32 GB.

you can provide any limit for maxsize, based on the db_block_size value.



Go to the top of the page
+Quote Post
post Apr 25 2017, 10:14 AM
Post #3

Advanced Member

Group: Members
Posts: 13,566
Joined: 26-January 04
Member No.: 13


I would not do it this way.

Try using "autoextend on" for objects and maxextents unlimited" for the tablespace:

Please read:


Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


Lo-Fi Version Time is now: 17th October 2017 - 10:15 AM