| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Unlimted Extents = 505?
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
![]() |
![]() |