Skip to Content
avatar image
Former Member

Can't activate a table after reorganisation

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 24, 2017 at 07:36 AM

    Hi Igor.

    Check this SAP note - 1954320

    BR

    SS

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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