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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01658: unable to create INITIAL extent for segment in tablespace

Re: ORA-01658: unable to create INITIAL extent for segment in tablespace

From: K POON <kspoon_at_netvigator.com>
Date: Sat, 29 Aug 1998 21:34:04 +0800
Message-ID: <35E8034C.691D0093@netvigator.com>


Yes, you can export the table structure with ROWS=N, edit the dmp file to extract the create table statement, and modify the initial extent, and create the table directly. Then you can import the data rows from your original dmp file with IGNORE=Y.

Regards,
Danny

suisum_at_freenet.edmonton.ab.ca wrote:

> Hi:
>
> How can I work around the following error, please? I get this error when I
> tried to import a dmp file. I know that I do not have enough disk space.
> If I only need the table structure, how can I import the table structure
> with less size? Should I have to modify the dmp file manually?
>
> ORA-01658: unable to create INITIAL extent for segment in tablespace
>
> --
> Best regards,
>
Received on Sat Aug 29 1998 - 08:34:04 CDT

Original text of this message

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