Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!cyclone2.usenetserver.com!news.webusenet.com!news-hub.cableinet.net!blueyonder!amsnews01.chello.com!newshub1.home.nl!home.nl!zwoll1.home.nl.POSTED!not-for-mail Message-ID: <3DF8F7F5.4080908@home.nl> From: Frank Reply-To: fbortel@nescape.net User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.misc Subject: Re: Unlimted Extents = 505? References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 13 Date: Thu, 12 Dec 2002 21:56:21 +0100 NNTP-Posting-Host: 217.121.193.81 X-Complaints-To: abuse@home.nl X-Trace: zwoll1.home.nl 1039726065 217.121.193.81 (Thu, 12 Dec 2002 21:47:45 MET) NNTP-Posting-Date: Thu, 12 Dec 2002 21:47:45 MET Organization: @Home Network Xref: newsfeed1.easynews.com comp.databases.oracle.misc:90490 X-Received-Date: Thu, 12 Dec 2002 13:48:04 MST (news.easynews.com) TurkBear wrote: > One other point - if you do not specify the storage details in the create table statement, the tablespace's settings will be > used. > No! Every table comes with it's own storage clause. Try imp system/manager file=blah indexfile=readme.txt. Then examine readme.txt, and you'll find all storage clauses. BTW - including the maxextents 505 of the originating db. Recreat the tables (instructions in readme.txt above) and import with ignore=y. Grtz, Frank (not a DBA)