Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.linkpendium.com!nntp-relay.ihug.net!ihug.co.nz!nntp.cs.ubc.ca!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: ps_chowdary@hotmail.com (Srinivas)
Newsgroups: comp.databases.oracle.server
Subject: exp/imp utilities index space
Date: 8 Aug 2003 14:24:05 -0700
Organization: http://groups.google.com/
Lines: 16
Message-ID: <68dbad24.0308081324.5acf67ca@posting.google.com>
NNTP-Posting-Host: 68.167.150.34
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1060377845 20710 127.0.0.1 (8 Aug 2003 21:24:05 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2003 21:24:05 GMT
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240134

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?

thanks,
Chowdary