Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!news-FFM2.ecrc.net!skynet.be!skynet.be!newsgate.cistron.nl!transit.news.xs4all.nl!newsfeed.xs4all.nl!xs4all!not-for-mail Reply-To: "Anton Buijs" From: "Anton Buijs" Newsgroups: comp.databases.oracle.server References: <68dbad24.0308081324.5acf67ca@posting.google.com> Subject: Re: exp/imp utilities index space Date: Fri, 8 Aug 2003 23:37:34 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Lines: 32 Message-ID: <3f341825$0$49099$e4fe514c@news.xs4all.nl> NNTP-Posting-Date: 08 Aug 2003 23:37:41 CEST NNTP-Posting-Host: 213.84.255.40 X-Trace: 1060378661 news.xs4all.nl 49099 213.84.255.40:1026 X-Complaints-To: abuse@xs4all.nl Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240135 Srinivas schreef in berichtnieuws 68dbad24.0308081324.5acf67ca@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? | | thanks, | Chowdary When the tablespace that is in the create statement in the dump file does not exists, the segment will be created in the users default tablespace. When the tablespace exists and the user has no privilige to create segments in that tablespace you get an error. But when you made an exp without indexes, there are no indexes to import... By the way: bad idea to create the indexes before the imp. For better performance it is better to create the indexes after the import. So do imp ... indexes=n .... and have a script that creates indexes afterwards.