Re: imp questions

From: Andreas Necker <Andreas.Necker_at_isb-ag.de>
Date: Wed, 05 Sep 2001 13:53:41 +0200
Message-ID: <3B961245.34605D46@isb-ag.de>

hi,

Antony Mak wrote:
>
> Hi all,
>
> I always have to setup a testing environment by import (drop some tables and
> import it back). Can anyone tell me can I change some indexes' tablespace
> during import?

do an import with the indexfile-option.

> and What about the functions, procedures, package, synonym
> with the dropped and re-imported table?

your procedures, packages and functions will get invalid when you drop your table. (dbms_utility.compile_schema may help you)

ciao
andreas

-- 
Andreas Necker

ISB AG              Tel: +49 (0)721/82800-0
Karlstrasse 52-54   Fax: +49 (0)721/82800-82
76133 Karlsruhe     mailto:Andreas.Necker_at_isb-ag.de
Germany             http://www.isb-ag.de

Received on Wed Sep 05 2001 - 06:53:41 CDT