Oracle DB: delete all the contents?

Question

I have oracle DB it is for testing purpose, I have not added any tables. I just want clear all the files like control, redo, archive, date. Ultimately I want fresh db. I know it can done by delete the db and recreate. I have searched in the internet could not find any relevant information. Update: The reason for this requirement is, some of the above mentioned files are corrupted. Please advice, Thanks,

Answer 1

If you don't have system level access, and want to scrub your schema, the following sql will produce a series of drop statements, which can then be executed.

select 'drop '||object_type||' '|| object_name|| DECODE(OBJECT_TYPE,'TABLE',' CASCADE CONSTRAINTS','') || ';' from user_objects

purge recyclebin;