Skip to Content

Can't activate a table after reorganisation

Dec 22, 2017 at 09:22 AM


avatar image

Hello! I have done the tablespace reorg by these commands:

1. brspace -u / -f tscreate -t PSAPSR3NEW -d both -l PSAPSR3

2. brspace -u / -f tbreorg -s PSAPSR3 -t "*" -n PSAPSR3NEW -p 16

3. drop table SAPSR3.PLAN_TABLE;

4. brspace -u / -f tsdrop -t PSAPSR3

5. brspace -u / -f tsalter -a rename -t PSAPSR3NEW -n PSAPSR3

6. brconnect -u / -c -f stats -t PSAPSR3 -f collect -p 4

And I think that all was good till I tried to activate a new table in se11:

> ORA-00959: tablespace 'PSAPSR3NEW' does not exist

And I see that in dbacockpit:

But it should be PSAPSR3 !

How can I fixed it ? Thanks!!!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

S Sriram Dec 24, 2017 at 07:36 AM

Hi Igor.

Check this SAP note - 1954320



Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi S Sriram !

Thanks for note, but it didn't help (

I checked on all my systems (with problem and on normal systems) and I see that the default tablespace for schema SAPSR3 is everywere PSAPSR3USR