CODEWITHSUNDEEP
databaseoracle-databaseoracle11gdatabase-administration
Malatesh
Malatesh

Reputation: 1954

Oracle DB: delete all the contents

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,

Upvotes: 1

Views: 764

Answers (1)

Lalit Kumar B
Lalit Kumar B

Reputation: 49062

Ultimately I want fresh db

Then do the following:

  • Open DBCA
  • Select the operation "Delete Database", put the required credentials when asked.
  • After completion of step 2, go back to first step.
  • Select the operation "Create Database"

Upvotes: 3

Related Questions