on 07-07-2007 9:01 PM
Hello people,
We created some infostructures (SD), but at the moment this
infostructures become not necessary for us anymore. Now we want to
delete them, but because of the big amount of rows, its would generate
a huge redologs, if we execute the standard procedure to perform this delete.
For this reason we want to know if its possible to perform this task
with the transaction SE14 .
best regards
Oscar
if you are REALLY sure that you do not need its contents, you can truncate the contents at DB level, this will have no impact on redologs .
connect "/ as sysdba"
truncate sapr3.s888;
exit;
note that his is very drastic and risky.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.