Skip to Content
0

How to backup table RSMPTEXTS's records

Nov 04, 2016 at 02:38 AM

79

avatar image

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?

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

5 Answers

James Zhang
Nov 04, 2016 at 04:40 AM
0

Hi Kevin,

Are you able to get data via sqlplus directly?

Best regards,
James

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

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

0
James Zhang
Nov 04, 2016 at 07:59 AM
0

Hi Kevin,

Are you log on database with correct user? sapsr3?

Best regards,
James

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

Hi James,

I logon db with user oraor4, or4 is our Oracle's name.

Best Regards

Kevin

0
James Zhang
Nov 04, 2016 at 08:49 AM
0

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

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

Hi James:

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

Best Regards

Kevin

0
Prithviraj Rajpurohit Nov 04, 2016 at 12:12 PM
0

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

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

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

0
Kevin Gao
Nov 05, 2016 at 04:40 AM
0

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 !

Share
10 |10000 characters needed characters left characters exceeded