| Amjad Ali |
Posted: Apr 13, 2008 11:44:35 AM |
Total Post: 13
Joined: Apr, 2008
|
Dear Friends...
I am trying to drop complete database from command line... in 9i XP, I am getting the below error....
SQL>STARTUP MOUNT RESTRICT
SQL>DROP DATABASE
SQL>Drop database databasename
Error at line 1:
ORA – 02026 : Missing Link Keyword
Can anyone solve out this problem...
Thanks and Regards... |
|
|
Murtuja |
| Posted: Apr 14, 2008 02:37:38 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Drop Database command is not available in 9i . Use DBCA to drop Database.
|
|
|
|
|
Amjad Ali |
| Posted: Apr 14, 2008 08:10:41 AM | |
|
Total Post: 13
Joined: Apr, 2008
|
Thanks Murtuja,
The above syntax which I had mentioned will work in 10g...
Thanks and Regards...(presently its not installed on my system thats why I am asking.....)
|
|
|
|
|
Murtuja |
| Posted: Apr 14, 2008 10:37:55 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Drop Database command is newly added into Oracle 10g database.It's not available with Oracle 9i.
You can use DBCA to delete database.
|
|
|
|
|
Amjad Ali |
| Posted: Apr 15, 2008 10:29:04 AM | |
|
Total Post: 13
Joined: Apr, 2008
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |