From ssharma1@fcsltd.com Tue, 05 Jun 2001 22:40:43 -0700 From: "Saurabh Sharma" Date: Tue, 05 Jun 2001 22:40:43 -0700 Subject: Re: Recording Destructive DDL Message-ID: MIME-Version: 1.0 Content-Type: text/plain hi, can u tell me, how have u done this. i too require it. can u explain it. saurabh ----- Original Message ----- To: Multiple recipients of list ORACLE-L Sent: Wednesday, June 06, 2001 7:16 AM > I've written a system event trigger which records information on when a table was dropped or truncated. I would also like > to record when someone does an "alter table drop column..." The problem is determining when the alter statement includes the drop column clause. It looks like I have to use the ora_is_drop_column function, calling it for each column in the table and checking the return code. Is there a way of determing whether "drop column" was issued without using this function? > > Ian MacGregor > Stanford Linear Accelerator Center > ian@slac.stanford.edu > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: MacGregor, Ian A. > INET: ian@SLAC.Stanford.EDU > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh Sharma INET: ssharma1@fcsltd.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).