cancel
Showing results for 
Search instead for 
Did you mean: 

SAP table backup

former_member201054
Contributor
0 Kudos

Hi

How to take backup of SAP table on oracle 11.2 and db2 9.7 env

Thanks a ton

Accepted Solutions (0)

Answers (2)

Answers (2)

ashish_vikas
Active Contributor
0 Kudos

It depends on your need.. What u want to do ??

and how about just making a backup copy of the table.

create table tab_bkp as select * from tab;

  • However changes made in original table will not be available in new table/exported table. if you later restore it, it may have inconsistent data.

thanks

ashish

former_member201054
Contributor
0 Kudos

Hi ,

If I want to take backup of a particular table means how to do ..can it be possible through brtools. how to avoid table inconsistency in restore.

Thanks a ton

Former Member
0 Kudos

Hi,

Check this link to export tables using brtools:

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

Regards,

Srikishan

Former Member
0 Kudos

Hi,

Direct export command can be used:

exp SYSTEM/<password> FILE=/<any path>/<filename>.dmp <table name1, name2> compress=n

Let me know if you want to use this option there is a similar import command as well to import the table contents.

Ranjeet

JPReyes
Active Contributor
0 Kudos

You can't take a backup of a single table using brtools but you can export a table to a file using brspace

Regards

Juan

Former Member
0 Kudos

Here is the command to export and Import

exp SYSTEM/<password>

export file: EXPORT.DMP > <ANY FILENAME>

U or T > T

Export Table content > yes

Compress extents > yes

enter table in the next prompt and press enter to quit.

Check the file space, before you drop or modify SAP table in database

Import command is

imp SYSTEM/<password>

import file: IMPORT.DMP > <ANY FILENAME>

Enter Insert Buffer size > leave it to default

yes to all the next options

Former Member
0 Kudos

Hi Daniel,

You can you can export the content of the table using export (SQL) commands at DB level.

Please have a look at below links for more details.

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.dm.doc...

http://www.oracle.com/technetwork/database/enterprise-edition/index-093639.html

Hope it helps..

Thanks,

Siva Kumar