Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sn-xit-03!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.server Subject: Re: exp/imp utilities index space Date: Fri, 08 Aug 2003 16:41:23 -0700 Organization: EXE Message-ID: <3F343523.F8F0D5E8@exxesolutions.com> X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 References: <68dbad24.0308081324.5acf67ca@posting.google.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@pond178.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 32 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240144 Srinivas wrote: > 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 Follow Anton's advice ... but keep in mind that there is no logical reason to place tables and indexes in separate tablespaces. The advice to do so, if it was ever valid, is no nothing more than mythology. Separate items to spread out I/O. Separating tables and indexes may, or more likely, will not accomplish this goal. -- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)