Re: dc_free_extents error

I think that you need to modify your storage clause of your tablespace. the number of extents that your tablespace has is being exceeded durring your operation. what you should do is increase the number of MAXEXTENTS that the tablespace where you are creating table1 is. Or you can just create a tablespace large enough to handle the data. See your Server SQL Lang. Ref Manual under Storage clause pg 4-391 or so.

Good Luck, Hope this helps.

Craig Harper
IFTN gunnk_at_winchcombe.win-uk.net (KEVIN GUNN) wrote:
>
>
> Help new user in trouble. ORACLE 6.0 on a Digital VAX.
>
> I have a query of the form
>
> create table table1 as
> select A.*
> from table2 A, table3 B
> where A.field1 = B.field2 ;
>
> The aim being to Export table1 as an archive of table2
> using the contents of field2 in table3 as the selection
> criteria.
>
> I get an error message of the form
>
> A.field1 = B.field2
> *
> quota ( parameter 'dc_free_extents' ) exceeded.
>
> dc_free_extents is not a parameter in my init.ora file
> so if it is a parameter that can be included in init.ora I
> assume the default value is active.
>
> If I am correct can anyone tell me it's default value and
> offer a suggestion as to what I should increase it to.
>
> Unfortunately I have no manuals I can refer to.
>
>
> Thanks in anticipation. Kev .
>
>
>
>
Received on Thu Sep 21 1995 - 00:00:00 CEST