ORA-00604: error occurred at recursive SQL level 1 followed by ORA-25141:
Hello All,
We are trying to build a database and I getting the following error messages:
ORA-00604: error occurred at recursive SQL level 1
ORA-25141: invalid EXTENT MANAGEMENT clause
Offending statement at line 5478
CREATE TEMPORARY TABLESPACE TEMP TEMPFILE '/u18/oradata/DATAMART/dbf/datamart_temp01.dbf' SIZE 2147450880,
'/u18/oradata/DATAMART/dbf/datamart_temp02.dbf' SIZE 2147450880,
'/u18/oradata/DATAMART/dbf/datamart_temp03.dbf' SIZE 2147450880,
'/u18/oradata/DATAMART/dbf/datamart_temp04.dbf' SIZE 2147450880,
'/u18/oradata/DATAMART/dbf/datamart_temp05.dbf' SIZE 2147450880,
'/u18/oradata/DATAMART/dbf/datamart_temp06.dbf' SIZE 2147450880
EXTENT
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5478
ORA-00604: error occurred at recursive SQL level 1
ORA-25141: invalid EXTENT MANAGEMENT clause
The create script seems to be fine. I've pasted a copy of that here as well.
CREATE DATABASE DATAMART
USER sys IDENTIFIED BY admin
USER system IDENTIFIED BY manager
DATAFILE '/u12/oradata/DATAMART/dbf/datamart_system01.dbf' SIZE 1000M
AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/u18/oradata/DATAMART/dbf/datamart_temp01.dbf' SIZE 2147450880,
'/u18/oradata/DATAMART/dbf/datamart_temp02.dbf' SIZE 2147450880,
'/u18/oradata/DATAMART/dbf/datamart_temp03.dbf' SIZE 2147450880,
'/u18/oradata/DATAMART/dbf/datamart_temp04.dbf' SIZE 2147450880,
'/u18/oradata/DATAMART/dbf/datamart_temp05.dbf' SIZE 2147450880,
'/u18/oradata/DATAMART/dbf/datamart_temp06.dbf' SIZE 2147450880
EXTENT MANAGEMENT LOCAL
UNDO TABLESPACE datamart_undo
DATAFILE '/u81/oradata/DATAMART/dbf/datamart_undo01.dbf' SIZE 2147450880 REUSE,
'/u82/oradata/DATAMART/dbf/datamart_undo02.dbf' SIZE 2147450880 REUSE,
'/u83/oradata/DATAMART/dbf/datamart_undo03.dbf' SIZE 2147450880 REUSE
AUTOEXTEND OFF
MAXLOGFILES 16
MAXLOGMEMBERS 4
MAXDATAFILES 1022
LOGFILE GROUP 1 ('/u81/oradata/DATAMART/rdo/datamart_redo_01_01.log',
'/u84/oradata/DATAMART/rdo/datamart_redo_01_02.log') SIZE 250M REUSE,
GROUP 2 ('/u82/oradata/DATAMART/rdo/datamart_redo_02_01.log',
'/u85/oradata/DATAMART/rdo/datamart_redo_02_02.log') SIZE 250M REUSE,
GROUP 3 ('/u83/oradata/DATAMART/rdo/datamart_redo_03_01.log',
'/u86/oradata/DATAMART/rdo/datamart_redo_03_02.log') SIZE 250M REUSE
CHARACTER SET WE8ISO8859P1
/
I tried to google for the first error message and I can see that it is a generic message and as for the second message it tells me that I should use a valid EXTENT MANAGEMENT value but LOCAL is valid and it works for all other scripts except this one. No one seems to have got this combination of errors though!
Anyone has seen anything like this before? Any solutions?
Thanks in advance,
-Shyami