Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
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%
Keerti
post Apr 14 2017, 03:48 PM
Post #1


Newbie
*

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
Vishok
post Apr 17 2017, 07:44 AM
Post #2


Newbie
*

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:

example:

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

Note:

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.

Regards,

Vishok


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


Advanced Member
***

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



Hi,

I would not do it this way.

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

Please read:

http://www.dba-oracle.com/t_alter_table_in...s_unlimited.htm




--------------------
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: 23rd August 2017 - 01:06 AM