RE:[sap-basis] error when exteding tablespace in upgrade system.
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Kumar on Apr 22 at 3:16 AM |  Mark as helpful |
Thanks all as i have told you that we have upgraded from ecc5 to ecc6.
i have some queries
1 i an extend the tablespace PSAPPRD but why the tablespace PSAPPRD640 is comming.
2 if i want to alter tablespace by oracle than the command is
alter tablespace PSAPPRD add datafile
'L:\oracle\DEV\sapdata4\prd_95\prd.data95' size 2000M autoextend on next 20M
maxsize 6000M
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
__.____._ i have some queries
1 i an extend the tablespace PSAPPRD but why the tablespace PSAPPRD640 is comming.
2 if i want to alter tablespace by oracle than the command is
alter tablespace PSAPPRD add datafile
'L:\oracle\DEV\sapdata4\prd_95\prd.data95' size 2000M autoextend on next 20M
maxsize 6000M
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
Related Content
In the Spotlight
White Papers
In the Spotlight
Toolbox.com for iPhone: Ask Questions & Get Answers Anywhere Use the New iPhone App
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
_.____.__ 
