Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!news.lightlink.com!news.alt.net!plato.usenetgateway.com!not-for-mail
From: LKBrwn_DBA <member30625@dbforums.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: exp/imp utilities index space
Date: Fri, 08 Aug 2003 22:03:14 +0000
Organization: dBforums
Lines: 10
Sender: LKBrwn_DBA
Message-ID: <3219489.1060380194@dbforums.com>
References: <68dbad24.0308081324.5acf67ca@posting.google.com>
User-Agent: dBforums
X-Original-NNTP-Posting-Host: dbforums.com
X-Original-Trace: 8 Aug 2003 22:24:48 GMT, dbforums.com
X-Authenticated-User: usenetgateway
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240139


Import (imp) will import the tables and indexes into the default
tablespace for the user you are importing into if the tablespaces from
export do not exist.

To avoid this, you create the tables/indexes in the correct tablespaces
and then import with IGNORE=Y option.

--
Posted via http://dbforums.com