Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01658: unable to create INITIAL extent for segment in tablespace
Hi Danny:
Thank you very very for your reply.
It is my mistake. I forget to alter the the auto entent = ON.
Yes, I do the way as you mentioned. It works.
Best regards,
K POON (kspoon_at_netvigator.com) wrote:
: 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.
: suisum_at_freenet.edmonton.ab.ca wrote:
: > 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
Received on Sat Aug 29 1998 - 18:04:20 CDT
![]() |
![]() |