Hello,
I recently restarted my Oracle8i database on my Linux box and configured PHP with Oracle8i. Now I cannot load any data into my tables.
I created a tablespace. Here is the syntax i used:
CREATE TABLESPACE IAIII DATAFILE \'/usr/local/oracle/8i/u01/app/oracle/oradata/DATA.dbf\'SIZE 300M REUSE DEFAULT STORAGE (INITIAL 25M NEXT 25M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) PERMANENT;
The tablespace was created with no problem.
But, when I try to load some data with SQL*Loader I\'m getting an error. Here is the error as it reads in the log file. There is actually two of them.
ORA-01552: cannot use system rollback segment for non-system tablespace \'IAIII\' SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.
I cannot load any rows at all.
I already tried resizing my tablespace to 500M but I still get the same errors.
Can anyone tell me why this is happening, please ?
Thank you.
I recently restarted my Oracle8i database on my Linux box and configured PHP with Oracle8i. Now I cannot load any data into my tables.
I created a tablespace. Here is the syntax i used:
CREATE TABLESPACE IAIII DATAFILE \'/usr/local/oracle/8i/u01/app/oracle/oradata/DATA.dbf\'SIZE 300M REUSE DEFAULT STORAGE (INITIAL 25M NEXT 25M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) PERMANENT;
The tablespace was created with no problem.
But, when I try to load some data with SQL*Loader I\'m getting an error. Here is the error as it reads in the log file. There is actually two of them.
ORA-01552: cannot use system rollback segment for non-system tablespace \'IAIII\' SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.
I cannot load any rows at all.
I already tried resizing my tablespace to 500M but I still get the same errors.
Can anyone tell me why this is happening, please ?
Thank you.