Skip to Content
0
Former Member
Apr 01, 2010 at 09:59 AM

upgrade from ecc5 to ecc6 old data like PRD640_1 is still there

19 Views

Dear All,

we have resent upgrade from ecc5 to ecc6 and i have some quires regarding the datafile.

In sapdata1 -4 i see all old data like PRD640_1 i still there .Please suggest it is ok or it should not be there in the sapdata.

in db02 tablespace

PSAPEL701D

PSAPEL701I

PSAPPRD

PSAPPRD640

PSAPPRD701

PSAPPRDUSR

PSAPTEMP

PSAPUNDO

PSAPUNDO2

SYSAUX

SYSTEM

There is once more thing when i am extend the table from brtools for

BR*Tools main menu 2 - Space management 1 = Extend tablespace 3 ~ Tablespace name (tablespace) ... []

1 - BRSPACE profile (profile) ...... [initPRD.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... [PSAPPRDUSR]

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initPRD.sap -s 20 -l E -f tsextend -t

PSAPPRDUSR]

c

c

Options for extension of tablespace PSAPPRDUSR (1. file)

1 * Last added file name (lastfile) ....... [L:\ORACLE\PRD\SAPDATA4\PRDUSR_4\PR

DUSR.DATA4]

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

3 - New file to be added (file) ........... [L:\oracle\PRD\sapdata4\prdusr_5\pr

dusr.data5]

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

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

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

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

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

9 - SQL command (command) ................. [alter tablespace PSAPPRDUSR add da

tafile 'L:\oracle\PRD\sapdata4\prdusr_5\prdusr.data5' size 460M autoextend on ne

xt 20M maxsize 500M]

BR0259I Program execution will be continued...

BR1049W Not enough free space in L:\oracle\PRD\sapdata4\prdusr_5 for total maxim

um size of all database files of tablespace PSAPPRD located on this disk volume,

missing at least 741702.647 MB

BR1049W Not enough free space in L:\oracle\PRD\sapdata4\prdusr_5 for total maxim

um size of all database files of tablespace PSAPPRD640 located on this disk volu

me, missing at least 137942.647 MB

BR1049W Not enough free space in L:\oracle\PRD\sapdata4\prdusr_5 for total maxim

um size of all database files of tablespace PSAPPRDUSR located on this disk volu

me, missing at least 13522.647 MB

BR0668I Warnings or errors occurred - you can continue to ignore them or go back

to repeat the last action

Please suggest what is right configuration and how to sol ther error in brtools.

Regards,

Kumar