on 11-12-2011 4:03 PM
Hi
How to take backup of SAP table on oracle 11.2 and db2 9.7 env
Thanks a ton
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check this link to export tables using brtools:
http://help.sap.com/saphelp_nw70ehp1/helpdata/en/84/4d854f11848a49939538fc1c9aa4ef/content.htm
Regards,
Srikishan
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
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://www.oracle.com/technetwork/database/enterprise-edition/index-093639.html
Hope it helps..
Thanks,
Siva Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.