Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Unlimted Extents = 505?

Re: Unlimted Extents = 505?

From: Rogbaker <Rogbaker_at_gdi.net>
Date: 16 Dec 2002 09:04:59 -0800
Message-ID: <e40a12ea.0212160904.67a52e65@posting.google.com>


Thanks, but it was not in a locally managed tablespace. -Roger
> Just to check, but if the exported database object was in a locally
> managed tablespace with uniform extents and was imported into a
> dictionary managed tablespace you can get a maxextents error on the
> imp. In this case truncating the new object copy, altering its
> storage setting, and re-importing with ignore=y would be one way to
> bypass the problem. In fact if this is the case then it may be
> advisable to import all the tables without data, indexes, or
> constraints, alter the storage, and then import the data, indexes, and
> constraints.
>
> HTH -- Mark D Powell --
Received on Mon Dec 16 2002 - 11:04:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US