Skip to Content
avatar image
Former Member

How to backup table RSMPTEXTS's records

I used t-code SE14 to adjust table RSMPTEXTS, but it got an error during adjusting, now there is no data in it, could anyone tell me how to get records back?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Nov 04, 2016 at 04:40 AM

    Hi Kevin,

    Are you able to get data via sqlplus directly?

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi James

      I used oracle code: select count * from rsmptexts; but it said : table or view does not exist.

      Now in SE16 I found there is 54 records in this table.

      Best Regards

      Kevin

  • Nov 04, 2016 at 07:59 AM

    Hi Kevin,

    Are you log on database with correct user? sapsr3?

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 04, 2016 at 08:49 AM

    Hi Kevin,

    You need to log on as the owner of rsmptexts. Check its owner:

    select owner from dba_objects where upper(object_name)='RSMPTEXTS'

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi James:

      Yeah the owner is sapsr3,but when I use 'su sapsr3' ,it said : user sapsr3 does not exist.

      Best Regards

      Kevin

  • avatar image
    Former Member
    Nov 04, 2016 at 12:12 PM

    Hi Kevin,

    If SE16 shows 54, same would be shown when you perform select count(*) on the table.

    Login as oraSID and try below query..

    select count(*) from sapsr3.RSMPTEXTS;

    Coming to your initial question on how to backup the content of this table.

    You can use export functionalityprovided in BRTools or copy the content of the table in a transport request at SAP level.

    http://help.sap.com/saphelp_nw70/helpdata/en/84/4d854f11848a49939538fc1c9aa4ef/content.htm

    Regards

    Prithviraj

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Prithviraj:

      I have tried to download data( language key = EN and DE) of table rsmptexts from another sap system and upload into my own system, now ican find 3322733 records in SE16,both in oracle database.

      But I find the menu bar at the top of sapgui interface such as 'Edit' 'Goto' 'Utilities' 'system' 'Help' now disappeared and some application bars display like @12@ (F8) with no texts.

      Best Regards

      Kevin

  • avatar image
    Former Member
    Nov 05, 2016 at 04:40 AM

    Hi all

    It seems work well now, I have do some steps as below:

    run program 'SAPRSEUG' with parameter

    With Cleanup RSMPTEXTS = 'X'

    and then relogon system.

    Thanks All !

    Add comment
    10|10000 characters needed characters exceeded