Skip to Content
0
Former Member
Mar 10, 2009 at 07:40 AM

Tablespace Layout Preparation for System Upgrade

20 Views

Hello,

have got an 4.7 HR System on AIX 5.3 with Oracle 9.2.0.7 that has the new SAP Tablespace layout, but the release dependend tablespace is empty:

List of database tablespaces

Pos. Tablespace Type Status ExtMan. SegMan. Backup Files/AuExt.

Total[KB] Used[%] Free[KB] ExtSize[KB] FreeExt. Largest[KB]

1 - PSAPDAT DATA ONLINE LOCAL AUTO NO 11/11

70522880 99.97 23296 33638400 16 25528320:8110080:4032:3008:3008

2 - PSAPDAT620 DATA ONLINE LOCAL AUTO NO 11/11

22016000 0.00 22015296 33628160 11 29184000:4444160:2047936:2047936:2047936

3 - PSAPDATUSR DATA ONLINE LOCAL AUTO NO 1/1

30720 0.42 30592 30689280 1 30689280+:30592:0:0:0

4 - PSAPTEMP TEMP ONLINE LOCAL MANUAL NO 1/1

1792000 0.00 1792000 28928000 0 28928000+:0:0:0:0

5 - PSAPUNDO UNDO ONLINE LOCAL MANUAL NO 1/1

29798400 0.18 29744704 921600 12 4063232:4063232:4063232:4063232:4063232

6 - SYSTEM DATA ONLINE LOCAL MANUAL NO 1/1

563200 97.97 11456 30156800 2 30156800+:11200:256:0:0

I have done a test upgrade to Oracle 10.2.0.2 and ERP 6.0 on a copy of that system. The upgrade was fine, but all table conversions are done in PSAPDAT and no PSAPDAT700 was necessary.

My question is: Which release dependend objects do normally belong to PSAP<SID>620? I would like to migrate them before the upgrade so that the upgrade puts the new tables to PSAP<SID>700.

Thanks in advance

Christian