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: <suisum_at_freenet.edmonton.ab.ca>
Date: 29 Aug 1998 23:04:20 GMT
Message-ID: <6sa1dk$8di$2@news.sas.ab.ca>


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

Original text of this message

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