We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-basis] error when exteding tablespace in upgrade system.

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Posted by Kumar
on Apr 30 at 10:10 AM
Mark this reply as helpfulMark 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
__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Kumar
SAP 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
_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language