on 01-13-2014 10:52 AM
Hello,
I´ve finished EHP installation and I'm doing the Follow-up activites when I try to drop the old tablespace I can't do it because there are objects into this old tablespace.
I´ve read this notes:
1715052 - Tablespace cannot be deleted after upgrade
1819182 - Tables (TTREE*) remain in old exchange tablespace But in this note, It doesn't explain the steps to process/change the objectos from old to new TS.
In transaction SE13 or SE11, change the data type SSEXC to APPL0 for the tables and activate your data. After you do this, you can use
a) SE14
b) ICNV
c) DB tools
to move the table to a different tablespace (for TABART APPL0).
Looking for scn I´ve founded this thread but the solution It's not "official" by Sap.
brspace -c force -o process,time -u / -f tbreorg -a reorg -tablespace PSAPPRD700 -t "*" -parallel 3 -degree 3 -newts PSAPSR3731
http://scn.sap.com/thread/3294166
Any advice?
Thanks
Hi,
I´ve just finished the reorganization of the objects into the new TS.
Then I need to drop the old tablespace but I´ve founded this note and I'm not sure
1677201 - Oracle 11g: Dictionary corruption / ORA-959 due to DROP TBS
If a segment is created using Deferred Segment Creation and the related tablespace is later dropped before the segment is populated with data, accessing the object fails with errors ORA-00604 ORA-00959...
If I've checked that the TS is empty with this sql, I would be sure that reorganized objects are not in a segment with deferred segment?
select table_name from dba_tables where tablespace_name='PSAPSR3701';
select index_name from dba_indexes where tablespace_name='PSAPSR3701';
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Looking for scn I´ve founded this thread but the solution It's not "official" by Sap.
Who said this, it is using brtools not any other tool which is unsupported.
You may go ahead and execute the command mentioned by other techie.
*Only an additional check is, you nee to select right parameters of command before you execute
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
You just need to move all the objects in the old tablespace to the new tablespace.
Use the command I have provided in that thread.
I have done it many times.
su - orasid
brspace -c force -o process,time -u / -f tbreorg -a reorg -tablespace PSAPPRD700 -t "*" -parallel 3 -degree 3 -newts PSAPSR3731
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Ruben
Connect as sidadm and run the command.
Also this is the standard way to move the objects in the old tablespace to the new tablespace after the upgrade (if required).
Check this SAP note
1848753 - SUM 1.0: exchange tablespace (e.g. PSAPSR3702X) handling during release upgrade/update
Regards
RB
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.