Re: [oracle-db-l] How to Completely Delete the Database Files

Reply from MRDBA on Jul 3 at 2:56 AM
Hi,

I tried to connect from command prompt

set ORACLE_SID=test

sqlplus

I entered the user name password

I got this error ORA-12518 TNS:LISTENER COULD NOT HAND OFF CLIENT CONNECTION.

---

---------------Original Message---------------
From: Harshan Eppurath
Sent: Monday, July 02, 2012 11:45 AM
Subject: How to Completely Delete the Database Files

The best would be to connect using sqlplus to database as sysdba from dos
prompt and enter the following.

drop database;

This should the trick.

to connect database from dos prompt you have to set value for ORACLE_SID

if you want to deinstall oracle s/w as well then you can do using oracle
installer.

Regards,
Harshan

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2012 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
MRDBA  
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Toolbox.com for iPhone & Android: Ask Questions & Get Answers Anywhere. Download the Free App

_.____.__

No comments:

Post a Comment