Re: How to delete a user and his table?

From: Lawrence Simela <lsimela_at_mahalini.prestel.co.uk>
Date: Fri, 28 Sep 2001 00:36:14 +0100
Message-ID: <9p0clr$7ng$2_at_phys-ma.sol.co.uk>

There is a slight difference between someone asking for some help where they have an idea of what they are doing than a guy asking

1. How do I install
2. How do I create users
3. How do I drop user + table

This tells me that the guy has not looked at any manual and does not intend to.
Oracle is a wee bit more complex than that, it does need some study and then you can ask questions with a bit of knowledge. Otherwise this newsgroup will be reduced to questions like can I drop a coulmn? What is Pl/sql? How do I outer-join? Whats the difference between outer and inner join? Whats Pro*c? and before you know it.. Whats a table? etc etc etc

Lawrence

"Cameron Abbott" <cvabbott_at_altavista.com> wrote in message news:9ovb8p$k67$1_at_bcarh8ab.ca.nortel.com...
> Just because your an Oracle DBA, it doesn't give you the right to have an
> Holier than thou attitude, the person was just asking for help!
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:9otj7d$eqqgq$1_at_ID-62141.news.dfncis.de...
> >
> > "ftp" <shyan_at_cse.cuhk.edu.hk> wrote in message
> > news:9ot6t3$klf$1_at_eng-ser1.erg.cuhk.edu.hk...
> > > drop user usernmae;
> > > cannot delete the user if he/she has created tables.
> > > How to drop the user and his/her tables?
> > >
> > > --
> >
> > drop user <username> cascade
> >
> > Are you planning to ask the syntax of *all* sql commands from this group
> and
> > never to study any manual?
> >
> > Regards,
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> >
> >
>
>
Received on Fri Sep 28 2001 - 01:36:14 CEST