On Wednesday 07 November 2001 08:53, you did posit: > Dear members , > Re :: Oracle8 > > How do you delete a datafile in Oracle (as DBA- superuser ) and not as OS- Administrator ? > I read that this is possible . > > Please guide me on this . > > Warm Regards, > ([EMAIL PROTECTED]) > Shyam >
if you mean delete a phyical file in oracle, this is a real, real, real bad idea. you will corrupt one or more databases, and that is probably not what you want. i am guessing that you mean that you want to drop a table or a database.. refer to the oracle database manuals under "drop table" or "drop database" as appropriate. if you have further questions, you should direct them to an oracle and/or sql mailing list. -- regards, allen wayne best, esq "your friendly neighborhood rambler owner" "my rambler will go from 0 to 105" Current date: 28:5:10::310:2001 The meek shall inherit the Earth. (But they're gonna have to fight for it.)
