Re: Drop Table and Procedures

From: Mohamad SALEH <msaleh_at_orsys.fr>
Date: Fri, 04 Sep 1998 16:58:26 +0200
Message-ID: <35F00012.E1CF1E9@orsys.fr>

lalaina_at_my-dejanews.com wrote:

> Hi all ,
>
> I'm working on a SAP interface application in which there are a lot of DROP
> TABLE and CREATE TABLE scripts ( I'd better use TRUNCATE but for obscure
> reasons, the project leader doesn' want it !). Does it invalidate packages
> and procedures dependant on the dropped table ?

Absolutely yes.

> Although I recompile everything successfully with SQL Plus, the tool I use
> marks some of my packages as Invalid (even after a refresh).
>
> What is exactly the impacts of a DROP TABLE on
>
> - Procs/triggers
> - Memory use and resource consumption
> - Views
>

Procs and functions are invalidated, triggers are dropped, views are invalidated. Dropping a table libeerate its space and gives it back to data base.

> Thanks for your infos
>
> Lalaina
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Sep 04 1998 - 09:58:26 CDT