Re: decreasing initial extent

Actual error from imp log:

IMP-00017: følgende sætning fejlede med ORACLE-fejl 1659:  "CREATE TABLE "SAMPLES_TRACE" ("SAMPLES_TRACE_RECNUM" NUMBER NOT NULL ENABLE"
 ", "MODTAGET_DATO" DATE NOT NULL ENABLE, "SERIE_RECNUM" NUMBER NOT NULL ENAB"
 "LE, "VALUE" NUMBER NOT NULL ENABLE, "SAMPLETIME_FROM_CET" DATE NOT NULL ENA"
 "BLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE(INITIAL"
 " 2147483646) TABLESPACE "HBMSTAB""
IMP-00003: ORACLE-fejl 1659 fundet
ORA-01659: kan ikke allokere MINEXTENTS ud over 121 i tabelområdet HBMSTAB

/Peter

"Peter Laursen" <ptl_at_edbgruppen.dk> wrote in message news:3e23f3cb$0$127$edfadb0f_at_dread15.news.tele.dk...
> Hi,
>
> System= 8.1.7.4
>
> How do I decrease the size of the initial extent in a table that contains
no
> rows?
>
> I have a largish (test)database. I want to make a full export that shall
be
> imported into a small database for test purposes. The small database
cannot
> allocate space for some initial extents on import.
> The large database contains some tables with large initial extents, but
> since I dont need the data in them I have truncated these tables. I have
> also done "alter table deallcate xxx unused". The export however still
> contains create table statements with large initial extents for these
empty
> tables. There is one locally managed tablespace using atuoallocate.
>
> I dont want to precreate the tables before import. I need to make an
export
> that can be used by others.
>
> TIA
> Peter Laursen
> (email not valid)
>
>
Received on Tue Jan 14 2003 - 05:44:18 CST