Re: Import / Export

From: <sybrandb_at_yahoo.com>
Date: 22 Jan 2004 06:53:45 -0800
Message-ID: <a1d154f4.0401220653.16d62bc8@posting.google.com>

spam_at_spam.com wrote in message news:<400f9b34.260377933_at_news.demon.co.uk>...
> Hi
>
> We use Oracle 8.1.7.4 with Sparc Soalris 8
> I want to export and Import a table to defrag it. The problem is
> tables has procedures and synoname depended on it. After I export and
> drop the table what happens to the synonym and procedures.
>
> How do I defrag the table without destroying the dependencies
>
> Thanks
>
> R

Nothing will happen to the synonym.
The procedure will become invalid and will automatically get recompiled at first use. If the table is there it will recompile successfully.
Better question however would be: why do I want to defrag, if we have LMTs?

Sybrand Bakker
Senior Oracle DBA Received on Thu Jan 22 2004 - 08:53:45 CST