Re: Prevent table delete

Sean wrote:
> how do i create a table which cant be deleted by the normal drop
> command.
>
> a friend told me that by hiding the table file it cant be deleted. is
> there any other way?

Use a DDL Trigger.

There is a demo in Morgan's Library at www.psoug.org. It can also prevent TRUNCATE.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org