Import Problem

Hello all,

   When I import a file (by imp73) to Oracle 7.3.4 on Windows NT server, I got the following error:

ORA-01654: unable to extend index sys.I-obj1 by 5 in tablespace system

   I increase the size of system tablespace but this error still generated during importing.

   What are the possible causes of this error and how to solve this problem?

   Here are the data files:
   And why there is no entry of FILE_ID = 1 in dba_free_space?

SQL> select * from dba_data_Files;

FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS

----------------  ------- ----------------    -------- ------ ------
E:\DATABASE\SYS   1       SYSTEM              10485760  5120 AVAILABLE
E:\DATABASE\RBS1  2       RBS                 4194304   2048 AVAILABLE
E:\DATABASE\SYS2  3       SYSTEM              10485760  5120 AVAILABLE
E:\DATABASE\DATA  4       DATA_FILE           10485760  5120 AVAILABLE

SQL> select * from dba_free_space;

TABLESPACE_NAME FILE_ID BLOCK_ID BYTES BLOCKS

------------------------- --------- --------- --------- ---------
SYSTEM                            3         2  10483712      5119
RBS                               2      1107   1929216       942
DATA_FILE                         4         3  10483712      5119

Thanks,
Alan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 04 2000 - 14:06:12 CST