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: Frank <fbortel_at_home.nl>
Date: Thu, 12 Dec 2002 21:56:21 +0100
Message-ID: <3DF8F7F5.4080908@home.nl>


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) Received on Thu Dec 12 2002 - 14:56:21 CST

Original text of this message

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