RE:[sap-basis] error when exteding tablespace in upgrade system.
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Snowy (Certified Netweaver '04/Oracle Basis consultant) on May 3 at 12:53 PM |  Mark as helpful |
Hi,<BR>
<BR>
ok, you have a few possible solutions<BR>
<BR>
1. add disk space<BR>
2. put datafile on another disk<BR>
3. decrease maximum size of datafile (autoextend)<BR>
4. decrease maximum size of other datafiles on the same disk (autoextend)<BR>
<BR>
<BR>
Good luck<BR>
---------------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
__.____._ <BR>
ok, you have a few possible solutions<BR>
<BR>
1. add disk space<BR>
2. put datafile on another disk<BR>
3. decrease maximum size of datafile (autoextend)<BR>
4. decrease maximum size of other datafiles on the same disk (autoextend)<BR>
<BR>
<BR>
Good luck<BR>
---------------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
SnowySAP Basis Helper
Posted helpful replies on 50 threads in a group to earn a Silver Achievement
Related Content
In the Spotlight
White Papers
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
_.____.__ 
