RE:[sap-basis] error when exteding tablespace in upgrade system.
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Kumar on Apr 30 at 10:10 AM |  Mark as helpful |
Dear All,
when i am extend the tablespace PSAPPRD fron brtools i am still getting the old tabe sapce and free space error ,there is free 50 gb free sapce
Please suggest how to extend the tablesapce PSAPPRD
Options for extension of tablespace PSAPPRD (1. file)
1 * Last added file name (lastfile) ....... [L:\ORACLE\DEV\SAPDATA4\PRD_96\PRD.
DATA96]
2 * Last added file size in MB (lastsize) . [2000]
3 - New file to be added (file) ........... [L:\oracle\DEV\sapdata4\prd_97\prd.
data97]
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) ..... [6000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPPRD add dataf
ile 'L:\oracle\DEV\sapdata4\prd_97\prd.data97' size 2000M autoextend on next 20M
maxsize 6000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2010-04-30 18.57.38
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
f all database files of tablespace PSAPPRD located on this disk volume, missing
at least 722474.467 MB
BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
f all database files of tablespace PSAPPRD640 located on this disk volume, missi
ng at least 118714.467 MB
BR0668I Warnings or errors occurred - you can continue to ignore them or go back
to repeat the last action
Please suggest
Regards
Kumar
---------------Original Message---------------
From: Kumar
Sent: Wednesday, April 21, 2010 7:58 AM
Subject: error when exteding tablespace in upgrade system.
> Dear all,
>
> I am getting error when we are getting extend the tablespace PSAPPRD.
> We have upgraded from ecc5 to ecc6 and this the first time I am extending the tablespace in upgrade system.
>
> I am not able to find the error
> 1. In the l drive there is 50 gb free space
> 2 why the old tablespace PSAPPRD640 is coming
>
> Options for extension of tablespace PSAPPRD (1. file)
>
> 1 * Last added file name (lastfile) ....... [L:\ORACLE\DEV\SAPDATA4\PRD_94\PRD.
> DATA94]
> 2 * Last added file size in MB (lastsize) . [2000]
> 3 - New file to be added (file) ........... [L:\oracle\DEV\sapdata4\prd_97\prd.
> data95]
> 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 PSAPPRD add dataf
> ile 'L:\oracle\DEV\sapdata4\prd_95\prd.data95' size 2000M autoextend on next 20M
> maxsize 10000M]
>
>
>
> BR0662I Enter your choice:
> c
> BR0280I BRSPACE time stamp: 2010-04-21 16.44.08
> BR0663I Your choice: 'c'
> BR0259I Program execution will be continued...
>
> BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
> f all database files of tablespace PSAPPRD located on this disk volume, missing
> at least 722473.425 MB
> BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
> f all database files of tablespace PSAPPRD640 located on this disk volume, missi
> ng at least 118713.425 MB
>
> BR0668I Warnings or errors occurred - you can continue to ignore them or go back
> to repeat the last action
>
> Regards,
> Kumar
__.____._ when i am extend the tablespace PSAPPRD fron brtools i am still getting the old tabe sapce and free space error ,there is free 50 gb free sapce
Please suggest how to extend the tablesapce PSAPPRD
Options for extension of tablespace PSAPPRD (1. file)
1 * Last added file name (lastfile) ....... [L:\ORACLE\DEV\SAPDATA4\PRD_96\PRD.
DATA96]
2 * Last added file size in MB (lastsize) . [2000]
3 - New file to be added (file) ........... [L:\oracle\DEV\sapdata4\prd_97\prd.
data97]
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) ..... [6000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPPRD add dataf
ile 'L:\oracle\DEV\sapdata4\prd_97\prd.data97' size 2000M autoextend on next 20M
maxsize 6000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2010-04-30 18.57.38
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
f all database files of tablespace PSAPPRD located on this disk volume, missing
at least 722474.467 MB
BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
f all database files of tablespace PSAPPRD640 located on this disk volume, missi
ng at least 118714.467 MB
BR0668I Warnings or errors occurred - you can continue to ignore them or go back
to repeat the last action
Please suggest
Regards
Kumar
---------------Original Message---------------
From: Kumar
Sent: Wednesday, April 21, 2010 7:58 AM
Subject: error when exteding tablespace in upgrade system.
> Dear all,
>
> I am getting error when we are getting extend the tablespace PSAPPRD.
> We have upgraded from ecc5 to ecc6 and this the first time I am extending the tablespace in upgrade system.
>
> I am not able to find the error
> 1. In the l drive there is 50 gb free space
> 2 why the old tablespace PSAPPRD640 is coming
>
> Options for extension of tablespace PSAPPRD (1. file)
>
> 1 * Last added file name (lastfile) ....... [L:\ORACLE\DEV\SAPDATA4\PRD_94\PRD.
> DATA94]
> 2 * Last added file size in MB (lastsize) . [2000]
> 3 - New file to be added (file) ........... [L:\oracle\DEV\sapdata4\prd_97\prd.
> data95]
> 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 PSAPPRD add dataf
> ile 'L:\oracle\DEV\sapdata4\prd_95\prd.data95' size 2000M autoextend on next 20M
> maxsize 10000M]
>
>
>
> BR0662I Enter your choice:
> c
> BR0280I BRSPACE time stamp: 2010-04-21 16.44.08
> BR0663I Your choice: 'c'
> BR0259I Program execution will be continued...
>
> BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
> f all database files of tablespace PSAPPRD located on this disk volume, missing
> at least 722473.425 MB
> BR1049W Not enough free space in L:\oracle\DEV\sapdata4 for total maximum size o
> f all database files of tablespace PSAPPRD640 located on this disk volume, missi
> ng at least 118713.425 MB
>
> BR0668I Warnings or errors occurred - you can continue to ignore them or go back
> to repeat the last action
>
> Regards,
> Kumar
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
KumarSAP Basis Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement
In the Spotlight
Your SAP Security is at Risk...Learn How to Stay Protected. Read the free white paper from SenSage
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
