Import / Export

Giganews Newsgroups
Subject: Import / Export
Posted by:  spam@spam.com
Date: Thu, 22 Jan 2004

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

Replies