cancel
Showing results for 
Search instead for 
Did you mean: 

DELETE Infostructures

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member204746
Active Contributor
0 Kudos

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.