Or simply add a datafile to the problem tablespace before doin the import.
K POON wrote in message <35E8034C.691D0093_at_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 Mon Aug 31 1998 - 16:27:13 CDT
