BRSPACE

[Former Member]

Dear All,

i am using oracle 10 g and try to extend table space PSAPSR3

but getting error....

Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ....... [J:\ORACLE\MRP\SAPDATA4\SR3_20\SR3.DATA20]

2 * Last added file size in MB (lastsize) . [2000]

3 - New file to be added (file) ........... [J:\oracle\MRP\sapdata4\sr3_21\sr3.data21]

4 # Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [2000]

6 - File autoextend mode (autoextend) ..... [yes]

7 - Maximum file size in MB (maxsize) ..... [10000]

8 - File increment size in MB (incrsize) .. [20]

9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile 'J:\oracle\MRP\sapdata4\sr3_21\sr3.data21' size 2000M autoextend on next 20M maxsize 10000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2009-11-19 09.01.11

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR1049W Not enough free space in J:\oracle\MRP\sapdata4\sr3_21 for total maximum size of all database files of tablespace PSAPSR3 located on this disk volume, missing at least 12215.717 MB

BR1049W Not enough free space in J:\oracle\MRP\sapdata4\sr3_21 for total maximum size of all database files of tablespace PSAPSR3700 located on this disk volume, missing at least 25075.717 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

while J drive having 10 gb free space.....

please mark ur valueable suggestion

Regards

Dik

[Former Member]

thanks

[anindya_bose]

I guess this is happenign because your auto extend is ON and BRTOOLS is calculating space if all the datafiles reach their maximum limit.

Suppose you have 20 GB space , 3 datafiles , and out of that only 10 GB is in use., But the maximum size of a particular file is 6 GB. Then actually you have 20 - 3X6=2 GB free. So if you want to create a datafile with 1 GB initial space, 3 GB maximum size and auto extend on, BRTOOLS will not allow you to do that.

[Former Member]

yup tablespace is autoextended.

now tell me what should i do .....

actually PSAPSR3 has been filled 93 % and it is auto extended mode but i want to extend tablespase through brtools

so what is the way to do this....

provide your valuable suggestion

Best Regards

Dik

[Former Member]

Dear

check current status of my table space

19.11.2009 10:25:58 MRP sappro

Tablespace status

-

---

Date/time of this analysis: 19.11.2009 09:47:43

-

---

Tablespace

Size (kb)

Free (kb)

Used (%)

Tab/ind

Extents

AutoExt (kb)

Used (%)

Status

Backup

-

---

PSAPSR3	43,008,000	4,559,552	89	152,950	188,295	198,656,000	19	ONLINE	NOT ACTIVE
PSAPSR3700	72,069,120	7,688,960	89	908	11,279	184,320,000	35	ONLINE	NOT ACTIVE
PSAPSR3USR	20,480	18,368	10	32	32	10,240,000	0	ONLINE	NOT ACTIVE
PSAPTEMP	2,048,000	2,048,000	0	0	0	10,240,000	0	ONLINE	NOT ACTIVE
PSAPUNDO	8,990,720	8,855,360	1	17	164	10,240,000	1	ONLINE	NOT ACTIVE
SYSAUX	286,720	11,456	96	986	2,110	10,240,000	3	ONLINE	NOT ACTIVE
SYSTEM	860,160	4,096	99	1,204	2,758	10,240,000	8	ONLINE	NOT ACTIVE

-

---

Total

127,283,200

23,185,792

81

156,097

204,638

-

---

[anindya_bose]

If you have auto extend on then why do you want to add datafile? Is it for learning purpose?

Anyway, if you want that only , then there are two solutions.

1. Select another drive where you have sufficient space.

2. Caculate the the maximum usage size of J drive when all the existing datafile will attain their respective maximum size.

Suppose you have datafile1 , 2 and 3 with maximum size 4,5,6 GB respectively. Then when these file will attain their maximum size , total usage will be 456=15 GB. Now , if you have 20 GB space in J drive, then you can add one data file with maximum size 5 GB, if you try to create with more size , it will throw error.

Tell me one more thing , did you change the autoextend recently for any files?

Edited by: Anindya Bose on Nov 19, 2009 10:29 AM

[Former Member]

no i did not change auto extended mode...

is it be ok if i will create new drive K:

on my hard disk as i am having unpartion space there and add new data file there .....

for that what will be the procedure.....

if i create new drive K then i have to create K:\oracle\MRP\sapdata5 manually...then run look for brtools or what...

Treat me fresher for that....

Regards

dik

[anindya_bose]

If you enter in the string value for datafile something like 'K:\oracle\MRP\sapdata2\SR3_21\sr3.data21' , then BRTOOLS automatically will create those folders in OS level and update the information in control file.

Go ahead... Best of Luck