27 Replies Latest reply: Apr 4, 2013 9:21 AM by Ruzica Kalkasliev RSS

ORA-00959: tablespace 'PSAPSR370000D' does not exist

Ruzica Kalkasliev
Currently Being Moderated

Dear all,

 

I've finished the Export for OS migration of Non-Unicode Central instance SAP ECC6.0 NW70 SR2 Oracle 11.2.0.3 on HP-UX 11.31. to RedHat 6.

 

I've installed Oracle 11.2.0.3 with the latest bundel patches on RedHat 6.

Now I've started the SWPM 1.0 to install the target system and import. I've proceed with the installation of the target, and I've got new error in sapinst.log:

CJS-30022 Program 'Migration Monitor' exits with error code 103. For details see log file(s) import_monitor.java.log, import_monitor.log.

In the import_monitor.log there was 4 Errors:
Loading of 'SAPSLEXC' import package is interrupted with R3load error.
Loading of 'SAPAPPL1' import package is interrupted with R3load error.
Loading of 'SAPSSEXC' import package is interrupted with R3load error.
Loading of 'SAP0000' import package is interrupted with R3load error.

In the logs SAPSLEXC.log, SAP0000.log, SAPSLEXC.log, the same errors:
ORA-00959: tablespace 'PSAPSR370000D' does not exist
DbSl Trace: ORA-1403 when accessing table SAPUSER

 

In SAPAPPL1.log just the error :

DbSl Trace: ORA-1403 when accessing table SAPUSER

This tablespace PSAPSR370000D does not exist on the source system.

TAORA from source system:

 

APPL0 PSAPSTABD

APPL1 PSAPBTABD

APPL2 PSAPPOOLD

CLUST PSAPCLUD

DDIM PSAPCLUD

DFACT PSAPCLUD

DODS PSAPCLUD

POOL PSAPPOOLD

SDIC PSAPDDICD

SDOCU PSAPDOCUD

SLDEF PSAPEL700D

SLEXC PSAPEL700D

SLOAD PSAPLOADD

SPROT PSAPPROTD

SSDEF PSAPES700D

SSEXC PSAPES700D

SSRC PSAPSOURCED

TEMP PSAPPROTD

USER PSAPUSER1D

USER1 PSAPUSER1D

 

Because of the schema on the source SAPR3  I've selected the new schema in the target SAPSR3.

I've also find the Note 1765619 - ORA-00922: missing or invalid option and Note 957917 - ORA: Conversion from old to new tablespace layout.

 

I was wondering if these notes can help, but in the DDLORA.TPL in the export directory there is no variable @SCHEMAID@ , just

TABLESPACE &tablespace&. That's why I don't know how these notes can help.

And the tablespace PSAPSR370000D is very stange because of the 5 zeros, I think it should be 3 zeros.

From the Note 957917, PSAP*<RELEASE>* ==> PSAP@SCHEMAID@<RELEASE>

 

For our tablespaces should be converted as:

PSAPEL700D ==> PSAPSR3700D

PSAPES700D ==> PSAPSR3700D

not PSAPSR370000D


I've also looked in the Notes 1689026 - Installation of NW 7.0x Systems with Oracle Client 11.2.0x and Note 1642058 - Adapt SAPInst Oracle Clien 11.2.0.x. Should I implement Method 1 from the above notes or not beacuse I'm using the SWPM tool and the last 720_EXT kernel and the link for Oracle client 10x_64 to 11x_64 was already prepared durring the installation? Or this is not the case.

 

 

How I can proceed with the import of the target?

Thank you in advance.

 

Thank you in advance.

 

BR,

Ruzica

  • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
    Marius Burger
    Currently Being Moderated

    Hi Ruzica

     

    please try below from note 1317500

     

    Error during export preparation with R3szchk

     

    Symptom:

    When preparing the export, R3szchk creates wrong tablespace entries PSAPES70I and PSAPES700 in DBSIZE.XML. Hence SAPinst creates the wrong tablespace name PSAP<SCHEMAID>70 instead of PSAP<SCHEMAID>700.

     

    Solution: 

    1. 3. Get the latest R3szchk from the SAP Service Marketplace at http://service.sap.com/swdc -> Download -> Support Packages and Patches -> Entry by Application Group -> SAP NetWeaver -> SAP NETWEAVER -> <your product> -> Entry by Component -> Application Server ABAP -> <SAP KERNEL of your product> -> <your OS> -> ORACLE.
    2. 4. Restart the R3szchk step.
    3. 5. Correct the tablespace names in DBSIZE.XML befor you start the import on the target system.

     

    Best Regards

    Marius

  • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
    Deepak Kori
    Currently Being Moderated

    Hi Ruzica,

     

    Refer SAP  Note 1677201 - Oracle 11g: Dictionary corruption / ORA-959 due to DROP TBS

    SAP note talks about Latest bundle patch for 11.2.0.3 dated March 2013.

    If this bundle patch is not applied , you may follow the workaround mentioned in this note.

     

    DROP TABLESPACE PSAPSR370000D INCLUDING CONTENTS AND DATAFILES ;

     

    Hope this helps.

     

    PS: You have posted same query in following thread. http://scn.sap.com/thread/3334077

     

    Regards,

    Deepak Kori

    • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
      Ruzica Kalkasliev
      Currently Being Moderated

      Hi Deepak,

       

      I'm using the latest bundle SAP_112035_201302_LINX8664.zip

       

      BR,

      Ruzica

      • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
        Deepak Kori
        Currently Being Moderated

        Hi Ruzica,

         

        SAP_112035_201302_LINX8664.zip is from Feb 2013. SAP note mentioned above talks about Bundle patch from March 2013.

         

        Regards,

        Deepak Kori

        • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
          Ruzica Kalkasliev
          Currently Being Moderated

          Hi Deepak,

           

          I see this on the SAP Note:

           

          11.2.0.3:

          UNIX SBP 11203x_date   ( date  >=  201203 )

          UNIX SGR 11203x_date   ( date  >=  201203 )

           

          It is March but 2012.

           

          BR,

          Ruzica

          • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
            Deepak Kori
            Currently Being Moderated

            Hi Ruzica,

             

            Apologies for the date mistake.

             

            Could you check on the database whether tablespace with that name exists.

             

            SQL> select * from v$tablespace;

             

            Regards,

            Deepak Kori

            • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
              Ruzica Kalkasliev
              Currently Being Moderated

              Hi Deepak,

               

              These are the new tablespaces created on the target. There is no tablespace PSAPSR370000D

              Something is wrong with the mapping in the DDLORA.TPL

               

              SQL> select name from v$tablespace;

              NAME
              ------------------------------
              SYSTEM
              SYSAUX
              PSAPUNDO
              PSAPTEMP
              PSAPSR3
              PSAPSR3700
              PSAPSR3USR

              7 rows selected.

              SQL>

               

              Thank you in advance,.

               

              BR,

              Ruzica

              • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                Vimal SAP
                Currently Being Moderated

                Hi Ruzica,

                 

                You are correct... Something is wrong in your DDLORA.TPL file.

                 

                Please check the following.

                 

                1. Please go to /export location/ABAP/DB/ORA and open the DDLORA.TPL check whether there is any tablespace like PSAPSR370000D ..

                2. Please go to your /sapinst_instdir/*/*/*/*/*/* and open DDLORA.TPL and check the same.

                 

                If any of the above you can find PSAPSR370000D , then replace it accordingly in your sapinst_instdir location.

                 

                If not, you have to manually edit the DDLORA.TPL...

                 

                I have faced this issue before during one migration and I have manually edited the TPL file and restarted the import and it went well.

                 

                Can you please send me the DDLORA.TPL file to mjvimalan@gmail.com?

                 

                Secondly please execute the following commands in your source system and share the output also.

                 

                select name from v$tablespace;

                 

                 

                Thanks and Regards,

                Vimal

                • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                  Ruzica Kalkasliev
                  Currently Being Moderated

                  Hello Vimal,

                   

                  There is no tablespace PSAPSR370000D in DDLORA.TPL in the export location just in the DDLORA.TPL in the /sapinst_instdir/*/*/*/*/*/*

                  DDLORA.TPL from the installation dir:

                   

                  # cat DDLORA.TPL

                  prikey: AFTER_LOAD ORDER_BY_PKEY

                  seckey: AFTER_LOAD

                  cretab: CREATE TABLE &tab_name&

                          ( /{ &fld_name& &fld_desc& /-, /} )

                          TABLESPACE &tablespace&

                          &compress&

                          &lob_cache&

                          STORAGE (INITIAL     &init&

                                   NEXT        &next&

                                   MINEXTENTS  &minext&

                                   MAXEXTENTS  &maxext&

                                   PCTINCREASE &pctinc& )

                  drptab: DROP TABLE &tab_name&

                  crepky: CREATE UNIQUE INDEX &pri_key&

                          ON &tab_name&

                          ( &key_fld& /-, )

                          TABLESPACE &tablespace&

                          STORAGE (INITIAL     &init&

                                   NEXT        &next&

                                   MINEXTENTS  &minext&

                                   MAXEXTENTS  &maxext&

                                   PCTINCREASE &pctinc& )

                                   NOLOGGING

                                   COMPUTE STATISTICS ;

                          ALTER INDEX &pri_key& LOGGING

                  drppky: DROP INDEX &pri_key&

                  creind: CREATE &unique& INDEX &ind_name&

                          ON &tab_name&

                          ( /{ &fld_name& /-, /} )

                          TABLESPACE &tablespace&

                          STORAGE (INITIAL     &init&

                                   NEXT        &next&

                                   MINEXTENTS  &minext&

                                   MAXEXTENTS  &maxext&

                                   PCTINCREASE &pctinc& )

                                   NOLOGGING

                                   COMPUTE STATISTICS ;

                          ALTER INDEX &ind_name& LOGGING

                  drpind: DROP INDEX &ind_name&

                  crevie: CREATE VIEW &view_name&

                          ( /{ &fld_name& /-, /} )

                          AS &query&

                  drpvie: DROP VIEW &view_name&

                  trcdat: TRUNCATE TABLE &tab_name&

                  deldat: DELETE FROM &tab_name& &where&

                  negtab: LICHECK MLICHECK

                  negdat: LICHECK MLICHECK

                  negind: LICHECK~0 MLICHECK~0 LICHECK^0 MLICHECK^0

                  negvie:

                  negcpr:  NRIV ARFCSSTATE ARFCSDATA ARFCRSTATE TRFCQDATA TRFCQIN TRFCQOUT TRFCQSTATE QRFCTRACE QRFCLOG

                  # table storage parameters

                  loc: APPL0 PSAPSR3                      0000

                       APPL1 PSAPSR3                      0000

                       APPL2 PSAPSR3                      0000

                       CLUST PSAPSR3                       0000

                       DDIM  PSAPSR3                       0000

                       DFACT PSAPSR3                       0000

                       DODS  PSAPSR3                       0000

                       POOL  PSAPSR3                      0000

                       SDIC  PSAPSR3                      0

                       SDOCU PSAPSR3                      0000

                       SLDEF PSAPSR370000D                     0000

                       SLEXC PSAPSR370000D                     0000

                       SLOAD PSAPSR3                      0000

                       SPROT PSAPSR3                      0000

                       SSDEF PSAPSR370000D                     0000

                       SSEXC PSAPSR370000D                     0000

                       SSRC  PSAPSR3                    0000

                       TEMP  PSAPSR3                      0000

                       USER  PSAPSR3USR                     0000

                       USER1 PSAPSR3USR                     0000

                  sto: 0  0000000016K 0000000040K 0000000001 2147483645

                       1  0000000016K 0000000160K 0000000001 2147483645

                       10 0000000016K 0000655360K 0000000001 2147483645

                       11 0000000016K 0001310720K 0000000001 2147483645

                       12 0000000016K 0002621440K 0000000001 2147483645

                       13 0000000016K 0005242880K 0000000001 2147483645

                       14 0000000016K 0010485760K 0000000001 2147483645

                       2  0000000016K 0000000640K 0000000001 2147483645

                       3  0000000016K 0000002560K 0000000001 2147483645

                       4  0000000016K 0000010240K 0000000001 2147483645

                       5  0000000016K 0000020480K 0000000001 2147483645

                       6  0000000016K 0000040960K 0000000001 2147483645

                       7  0000000016K 0000081920K 0000000001 2147483645

                       8  0000000016K 0000163840K 0000000001 2147483645

                       9  0000000016K 0000327680K 0000000001 2147483645

                  # index storage parameters

                  loc: APPL0 PSAPSR3                      0000

                       APPL1 PSAPSR3                      0000

                       APPL2 PSAPSR3                      0000

                       CLUST PSAPSR3                       0000

                       DDIM  PSAPSR3                       0000

                       DFACT PSAPSR3                       0000

                       DODS  PSAPSR3                       0000

                       POOL  PSAPSR3                      0000

                       SDIC  PSAPSR3                      0

                       SDOCU PSAPSR3                      0000

                       SLDEF PSAPSR370000I                     0000

                       SLEXC PSAPSR370000I                     0000

                       SLOAD PSAPSR3                      0000

                       SPROT PSAPSR3                      0000

                       SSDEF PSAPSR370000I                     0000

                       SSEXC PSAPSR370000I                     0000

                       SSRC  PSAPSR3                    0000

                       TEMP  PSAPSR3                      0000

                       USER  PSAPSR3USR                     0000

                       USER1 PSAPSR3USR                     0000

                  sto: 0  0000000016K 0000000040K 0000000001 2147483645

                       1  0000000016K 0000000080K 0000000001 2147483645

                       10 0000000016K 0000163840K 0000000001 2147483645

                       11 0000000016K 0000327680K 0000000001 2147483645

                       12 0000000016K 0000655360K 0000000001 2147483645

                       13 0000000016K 0001310720K 0000000001 2147483645

                       14 0000000016K 0002621440K 0000000001 2147483645

                       2  0000000016K 0000000160K 0000000001 2147483645

                       3  0000000016K 0000000640K 0000000001 2147483645

                       4  0000000016K 0000002560K 0000000001 2147483645

                       5  0000000016K 0000005120K 0000000001 2147483645

                       6  0000000016K 0000010240K 0000000001 2147483645

                       7  0000000016K 0000020480K 0000000001 2147483645

                       8  0000000016K 0000040960K 0000000001 2147483645

                       9  0000000016K 0000081920K 0000000001 2147483645

                   

                   

                  From the source system:

                  SQL>  select name from v$tablespace;

                  NAME
                  ------------------------------
                  SYSTEM
                  SYSAUX
                  PSAPUNDO
                  PSAPSTABD
                  PSAPBTABD
                  PSAPBTABI
                  PSAPPOOLD
                  PSAPCLUD
                  PSAPDDICD
                  PSAPDDICI
                  PSAPDOCUD

                  NAME
                  ------------------------------
                  PSAPEL46CD
                  PSAPLOADD
                  PSAPLOADI
                  PSAPPROTD
                  PSAPES46CD
                  PSAPSOURCED
                  PSAPSOURCEI
                  PSAPEL700D
                  PSAPUSER1D
                  PSAPES46CI
                  PSAPDOCUI

                  NAME
                  ------------------------------
                  PSAPPOOLI
                  PSAPEL700I
                  PSAPSTABI
                  PSAPPROTI
                  PSAPCLUI
                  PSAPEL46CI
                  PSAPES700D
                  PSAPUSER1I
                  PSAPES700I
                  PSAPTEMP

                  32 rows selected.

                  SQL>

                   

                  Thank you in advance.

                  BR,
                  Ruzica

                  • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                    Vimal SAP
                    Currently Being Moderated

                    Hi,

                     

                    Please go to /export location/ABAP/DB/ORA and paste the DDLORA.TPL file available there..

                     

                     

                    Or it should be under / export location/ABAP/DB

                     

                    Thanks and Regards,

                    Vimal

                    • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                      Ruzica Kalkasliev
                      Currently Being Moderated

                      Hi,

                       

                      From the export dir from source:

                       

                      #

                      cat DDLORA.TPL
                      prikey: AFTER_LOAD ORDER_BY_PKEY
                      seckey: AFTER_LOAD

                      cretab: CREATE TABLE &tab_name&
                              ( /{ &fld_name& &fld_desc& /-, /} )
                              TABLESPACE &tablespace&
                              &compress&
                              &lob_cache&
                              STORAGE (INITIAL     &init&
                                       NEXT        &next&
                                       MINEXTENTS  &minext&
                                       MAXEXTENTS  &maxext&
                                       PCTINCREASE &pctinc& )

                      drptab: DROP TABLE &tab_name&

                      crepky: CREATE UNIQUE INDEX &pri_key&
                              ON &tab_name&
                              ( &key_fld& /-, )
                              TABLESPACE &tablespace&
                              STORAGE (INITIAL     &init&
                                       NEXT        &next&
                                       MINEXTENTS  &minext&
                                       MAXEXTENTS  &maxext&
                                       PCTINCREASE &pctinc& )
                                       NOLOGGING
                                       COMPUTE STATISTICS ;
                              ALTER INDEX &pri_key& LOGGING

                      drppky: DROP INDEX &pri_key&

                      creind: CREATE &unique& INDEX &ind_name&
                              ON &tab_name&
                              ( /{ &fld_name& /-, /} )
                              TABLESPACE &tablespace&
                              STORAGE (INITIAL     &init&
                                       NEXT        &next&
                                       MINEXTENTS  &minext&
                                       MAXEXTENTS  &maxext&
                                       PCTINCREASE &pctinc& )
                                       NOLOGGING
                                       COMPUTE STATISTICS ;
                              ALTER INDEX &ind_name& LOGGING

                      drpind: DROP INDEX &ind_name&

                      crevie: CREATE VIEW &view_name&
                              ( /{ &fld_name& /-, /} )
                              AS &query&

                      drpvie: DROP VIEW &view_name&

                      trcdat: TRUNCATE TABLE &tab_name&

                      deldat: DELETE FROM &tab_name& &where&

                      negtab: LICHECK MLICHECK

                      negdat: LICHECK MLICHECK
                      negind: LICHECK~0 MLICHECK~0 LICHECK^0 MLICHECK^0

                      negvie:

                      negcpr: NRIV ARFCSSTATE ARFCSDATA ARFCRSTATE TRFCQDATA TRFCQIN TRFCQOUT TRFCQSTATE QRFCTRACE QRFCLOG

                      # table storage parameters

                      loc: APPL0 PSAPSTABD                      0000
                           APPL1 PSAPBTABD                      0000
                           APPL2 PSAPPOOLD                      0000
                           CLUST PSAPCLUD                       0000
                           DDIM  PSAPCLUD                       0000
                           DFACT PSAPCLUD                       0000
                           DODS  PSAPCLUD                       0000
                           POOL  PSAPPOOLD                      0000
                           SDIC  PSAPDDICD                      0
                           SDOCU PSAPDOCUD                      0000
                           SLDEF PSAPEL700D                     0000
                           SLEXC PSAPEL700D                     0000
                           SLOAD PSAPLOADD                      0000
                           SPROT PSAPPROTD                      0000
                           SSDEF PSAPES700D                     0000
                           SSEXC PSAPES700D                     0000
                           SSRC  PSAPSOURCED                    0000
                           TEMP  PSAPPROTD                      0000
                           USER  PSAPUSER1D                     0000
                           USER1 PSAPUSER1D                     0000

                      sto: 0  0000000016K 0000000040K 0000000001 2147483645
                           1  0000000016K 0000000160K 0000000001 2147483645
                           10 0000000016K 0000655360K 0000000001 2147483645
                           11 0000000016K 0001310720K 0000000001 2147483645
                           12 0000000016K 0002621440K 0000000001 2147483645
                           13 0000000016K 0005242880K 0000000001 2147483645
                           14 0000000016K 0010485760K 0000000001 2147483645
                           2  0000000016K 0000000640K 0000000001 2147483645
                           3  0000000016K 0000002560K 0000000001 2147483645
                           4  0000000016K 0000010240K 0000000001 2147483645
                           5  0000000016K 0000020480K 0000000001 2147483645
                           6  0000000016K 0000040960K 0000000001 2147483645
                           7  0000000016K 0000081920K 0000000001 2147483645
                           8  0000000016K 0000163840K 0000000001 2147483645
                           9  0000000016K 0000327680K 0000000001 2147483645

                      # index storage parameters

                      loc: APPL0 PSAPSTABI                      0000
                           APPL1 PSAPBTABI                      0000
                           APPL2 PSAPPOOLI                      0000
                           CLUST PSAPCLUI                       0000
                           DDIM  PSAPCLUI                       0000
                           DFACT PSAPCLUI                       0000
                           DODS  PSAPCLUI                       0000
                           POOL  PSAPPOOLI                      0000
                           SDIC  PSAPDDICI                      0
                           SDOCU PSAPDOCUI                      0000
                           SLDEF PSAPEL700I                     0000
                           SLEXC PSAPEL700I                     0000
                           SLOAD PSAPLOADI                      0000
                           SPROT PSAPPROTI                      0000
                           SSDEF PSAPES700I                     0000
                           SSEXC PSAPES700I                     0000
                           SSRC  PSAPSOURCEI                    0000
                           TEMP  PSAPPROTI                      0000
                           USER  PSAPUSER1I                     0000
                           USER1 PSAPUSER1I                     0000

                      sto: 0  0000000016K 0000000040K 0000000001 2147483645
                           1  0000000016K 0000000080K 0000000001 2147483645
                           10 0000000016K 0000163840K 0000000001 2147483645
                           11 0000000016K 0000327680K 0000000001 2147483645
                           12 0000000016K 0000655360K 0000000001 2147483645
                           13 0000000016K 0001310720K 0000000001 2147483645
                           14 0000000016K 0002621440K 0000000001 2147483645
                           2  0000000016K 0000000160K 0000000001 2147483645
                           3  0000000016K 0000000640K 0000000001 2147483645
                           4  0000000016K 0000002560K 0000000001 2147483645
                           5  0000000016K 0000005120K 0000000001 2147483645
                           6  0000000016K 0000010240K 0000000001 2147483645
                           7  0000000016K 0000020480K 0000000001 2147483645
                           8  0000000016K 0000040960K 0000000001 2147483645
                           9  0000000016K 0000081920K 0000000001 2147483645

                       

                      BR,

                      Ruzica

                      • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                        Vimal SAP
                        Currently Being Moderated

                        Hi,

                         

                        Thanks .. Please try the following.

                         

                        1. Stop the sapinst.

                        2. navigate to sapinst_instdir folder  and rename the DDLORA.TPL file.

                        3. Copy the DDLORA.TPL file from the export location to sapinst_instdir location.

                        4.Start the sapinst and continue with old option

                         

                        Please share your feedback.

                         

                        Thanks and Regards,

                        Vimal

                        • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                          Ruzica Kalkasliev
                          Currently Being Moderated

                          Hi Vimal,

                           

                          I was wondering for something, if I use the DDLORA.TPL from export location there will be no mapping (or changing) from schema SAPR3 to SAPSR3 what I need to perform with this export and import.

                          Am I right ?

                           

                          Thank you in advance.

                           

                          BR,

                          Ruzica

                          • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                            Vimal SAP
                            Currently Being Moderated

                            Hi,

                             

                              You can try to rename the contents in the file DDLORA.TPL file which was copied to sapinst directory from the export location.

                             

                            Example

                             

                            Rename

                             

                            # table storage parameters

                            loc: APPL0 PSAPSTABD                      0000

                             

                            to

                             

                            # table storage parameters

                            loc: APPL0 PSAPSR3                      0000

                             

                             

                            Likewise change for the others also .

                             

                            Thanks and Regards,

                            Vimal

                            • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                              Ruzica Kalkasliev
                              Currently Being Moderated

                              Hi Vimal,

                               

                              I've changed the DDLORA.TPL and DDLORA_LRG.TPL like this and Import finished OK:

                               

                              > cat "DDLORA.TPL"|grep PSAPSR3700

                                ###     SLDEF PSAPSR370000D                     0000

                                SLDEF PSAPSR3700                     0000

                                ###     SLEXC PSAPSR370000D                     0000

                              SLEXC PSAPSR3700                    0000

                                ###     SSDEF PSAPSR370000D                     0000

                              SSDEF PSAPSR3700                    0000

                                ###     SSEXC PSAPSR370000D                     0000

                              SSEXC PSAPSR3700                    0000

                                ###     SLDEF PSAPSR370000I                     0000

                              SLDEF PSAPSR3700                     0000

                              ###     SLEXC PSAPSR370000I                     0000

                              SLEXC PSAPSR3700                    0000

                              ###     SSDEF PSAPSR370000I                     0000

                              SSDEF PSAPSR3700                    0000

                              ###     SSEXC PSAPSR370000I                     0000

                              SSEXC PSAPSR3700                    0000

                               

                              Thank you for all your help.

                               

                              BR,
                              Ruzica

              • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                Deepak Kori
                Currently Being Moderated

                Hi Ruzica,

                 

                Could you share dbsize.XML and DDLORA.TPL files.

                 

                Regards,

                Deepak Kori

                • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                  Ruzica Kalkasliev
                  Currently Being Moderated

                  Hi Deepak,

                   

                  I've shared the DDLORA.TPL above.

                   

                  The dbsize.XML file is too big . Can I paste it here?

                   

                  BR,
                  Ruzica

                • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                  Marius Burger
                  Currently Being Moderated

                  hi ruzica,

                   

                  you should be able just to change the entries in that file but you will also have to have a look at

                   

                  select * from sapsr3.taora;

                  select * from sapsr3.iaora;

                  • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                    Ruzica Kalkasliev
                    Currently Being Moderated

                    Hi Marius,

                     

                    From the target DB - there is no tablespace PSAPSR370000D:

                     

                    SQL> select * from sapsr3.taora;

                    TABAR TABSPACE                       PCTI OFR OF OP OP
                    ----- ------------------------------ ---- --- -- -- --
                    APPL0 PSAPSTABD                      0000 001 01 10 40
                    APPL1 PSAPBTABD                      0000 1   1  10 40
                    APPL2 PSAPPOOLD                      0000 1   1  10 40
                    CLUST PSAPCLUD                       0000 1   1  10 40
                    DDIM  PSAPCLUD                       0000 001 01 00 60
                    DFACT PSAPCLUD                       0000 004 01 10 60
                    DODS  PSAPCLUD                       0000 004 01 00 60
                    POOL  PSAPPOOLD                      0000 1   1  10 40
                    SDIC  PSAPDDICD                      0    1   1  10 40
                    SDOCU PSAPDOCUD                      0000 1   1  10 40
                    SLDEF PSAPEL700D                     0000 1   1  10 40

                    TABAR TABSPACE                       PCTI OFR OF OP OP
                    ----- ------------------------------ ---- --- -- -- --
                    SLEXC PSAPEL700D                     0000 1   1  10 40
                    SLOAD PSAPLOADD                      0000 1   1  10 40
                    SPROT PSAPPROTD                      0000 1   1  10 40
                    SSDEF PSAPES700D                     0000 1   1  10 40
                    SSEXC PSAPES700D                     0000 1   1  10 40
                    SSRC  PSAPSOURCED                    0000 1   1  10 40
                    TEMP  PSAPPROTD                      0000 1   1  10 40
                    USER  PSAPUSER1D                     0000 1   1  10 40
                    USER1 PSAPUSER1D                     0000 1   1  10 40

                    20 rows selected.

                    SQL> select * from sapsr3.iaora;
                    select * from sapsr3.iaora
                                         *
                    ERROR at line 1:
                    ORA-00942: table or view does not exist


                    SQL>

                     

                    Thank you in advance,

                     

                    BR,

                    Ruzica

                    • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                      Marius Burger
                      Currently Being Moderated

                      hi ruzica

                       

                      then i would suggest backip up and changing the file (DDLORA.TPL) to host the new tablespace name and retying.just before the import phase check the iora and taora tables to make sure there is not refrence to PSAPSR370000D

                       

                      best regards

                      marius

                      • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                        Ruzica Kalkasliev
                        Currently Being Moderated

                        Hi Marius,

                         

                        What should be the change ?

                        DDLORA with which tablespace names, from the v$tablespace from the target or?

                         

                        Thank you in advance.

                         

                        BR,

                        Ruzica

                        • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
                          Marius Burger
                          Currently Being Moderated

                          DDLORA.TPL on the target system change the PSAPSR370000D with PSAPSR3700

                           


                          # table storage parameters

                          loc: APPL0 PSAPSR3                      0000

                               APPL1 PSAPSR3                      0000

                               APPL2 PSAPSR3                      0000

                               CLUST PSAPSR3                       0000

                               DDIM  PSAPSR3                       0000

                               DFACT PSAPSR3                       0000

                               DODS  PSAPSR3                       0000

                               POOL  PSAPSR3                      0000

                               SDIC  PSAPSR3                      0

                               SDOCU PSAPSR3                      0000

                               SLDEF PSAPSR3700                     0000

                               SLEXC PSAPSR3700                     0000

                               SLOAD PSAPSR3                      0000

                               SPROT PSAPSR3                      0000

                               SSDEF PSAPSR3700                     0000

                               SSEXC PSAPSR3700                     0000

                               SSRC  PSAPSR3                    0000

                               TEMP  PSAPSR3                      0000

                               USER  PSAPSR3USR                     0000

                               USER1 PSAPSR3USR                     0000


                          # index storage parameters

                          loc: APPL0 PSAPSR3                      0000

                               APPL1 PSAPSR3                      0000

                               APPL2 PSAPSR3                      0000

                               CLUST PSAPSR3                       0000

                               DDIM  PSAPSR3                       0000

                               DFACT PSAPSR3                       0000

                               DODS  PSAPSR3                       0000

                               POOL  PSAPSR3                      0000

                               SDIC  PSAPSR3                      0

                               SDOCU PSAPSR3                      0000

                               SLDEF PSAPSR3700                     0000

                               SLEXC PSAPSR3700                     0000

                               SLOAD PSAPSR3                      0000

                               SPROT PSAPSR3                      0000

                               SSDEF PSAPSR3700                     0000

                               SSEXC PSAPSR3700                     0000

                               SSRC  PSAPSR3                    0000

                               TEMP  PSAPSR3                      0000

                               USER  PSAPSR3USR                     0000

                               USER1 PSAPSR3USR                     0000

  • Re: ORA-00959: tablespace 'PSAPSR370000D' does not exist
    Mauricio Giovanni Branada Montoya
    Currently Being Moderated

    Hi.

     

    Which patch level of SWPM did you use? The lastest is  PLV06.

     

    I have the same issue using SWPM PL03, and I had to change manually the tablespace entries in DDLORA.TPL, DDLORA_LRG.TP and DBSIZE.XML.

Actions

Incoming Links