Can't activate a table after reorganisation

[former_member424394]

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!!!

[Sriram2009]

Hi Igor.

Check this SAP note - 1954320

BR

SS

[former_member424394]

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