Home » SQL & PL/SQL » SQL & PL/SQL » How to drop the database (Oracle 9i,Windows XP)
How to drop the database [message #310027] Mon, 31 March 2008 00:20 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I execute the simple command,

Drop database mike;

It shows a error likr
ora-02026:missing like keyword .

what is the procedure for dropping database.
Re: How to drop the database [message #310028 is a reply to message #310027] Mon, 31 March 2008 00:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>what is the procedure for dropping database.
Are you using Oracle or MYSQL?
I suspect you are in the wrong forum.
Re: How to drop the database [message #310033 is a reply to message #310027] Mon, 31 March 2008 00:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-02026: missing LINK keyword
 *Cause: keyword missing
 *Action: supply missing keyword

Copy and paste what you have don't try to type it with errors.

There is no "drop database" in 9i, you have to delete the files yourself.

Regards
Michel
Re: How to drop the database [message #310040 is a reply to message #310027] Mon, 31 March 2008 00:59 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Oracle database
Re: How to drop the database [message #310157 is a reply to message #310027] Mon, 31 March 2008 07:48 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
DROP DATABASE wasn't available until 10g.
Previous Topic: What problem in this SQL statement?
Next Topic: Executing procedure using procedure
Goto Forum:
  


Current Time: Wed Feb 19 02:00:58 CST 2025