Re: Unable to Delete table

"balu" <nairb_at_sabc.co.za> wrote in message news:1136982093.003511.269600_at_g43g2000cwa.googlegroups.com...
> Hi there, pls help me resolve this issue...
>
> In my oracle 9i Schema there is a table called 'AREA'
>
> When I ran a DTS from SQL Server to populate some tables in my schema
> it erroneously created another table by the name 'area'. how it is
> possible to create two objects with the same name?
>
> (actually two other tables 'area_party_votes_pr' &
> 'area_party_votes_ward' was also created. For convenience am referring
> only to one table --> 'area')
>
>
> More trouble is that , I am not able to delete the new 'area' table.
>

Use double-quotes:

    drop table "area";

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 10th Jan 2006