Re: exp/imp utilities index space

"Srinivas" <ps_chowdary_at_hotmail.com> wrote in message news:68dbad24.0308081324.5acf67ca_at_posting.google.com...
> Hi DBA gurus,
>
> In our app setup we use separate table and index spaces. We use
> exp/imp utilties to transfer between different schemas wihtin a
> database or between different databases. We do not exportof indexes
> (index=n during exp)
>
> If we create all the tables and indexes before import, then I will be
> able to define index space name along with each index creation.
>
> But I do not create tables and indexes before import, then where will
> be indexes created after the import? How is it possible to configure
> in a such a way that it uses separate index space rather than temp?
>

Hi Chowdary,

Is there any specific reason why you don't export the indexes ? You do of course realize that it's only the index definitions, rather than the index data (which would be pointless) that gets exported....

Just to add to what the others have said, if you want to re-create your indexes in specific tablespace(s), an option is to use the indexfile option during an import and modify the index creation scripts to your hearts content.

Good luck

Richard Received on Mon Aug 11 2003 - 07:34:09 CDT