on 2009 Mar 10 7:40 AM
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
You don't need to do that now.
PREPARE will check the number of support packages and langauges you BIND and will then suggest to create a new tablespace with the appropriate size.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.