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

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