I have a little problem. I have to delete all the data from our database. I don't want to drop tables, only delete the data sets.
These are 47 tables in total.
I tried the following:
Delete FROM(select TABLE_NAME from USER_TABLES); Delete FROM(select * from ALL_ALL_TABLES Where OWNER = 'DB_NAME')
But that is not valid. How can I efficiently remove all the data from all my tables?