I am getting ora 00907 error at line 10 missing left parenthesis
'/d02/oracle/TEST/db/apps_st/data/log01b.dbf
Please provide solution at the eraliest.
Regards,
Pragati
Pragati.rch@gmail.com
CREATE CONTROLFILE set DATABASE TEST RESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 420
MAXINSTANCES 16
MAXLOGHISTORY 1600
LOGFILE
GROUP 1 (
'/d02/oracle/TEST/db/apps_st/data/log01a.dbf’,
'/d02/oracle/TEST/db/apps_st/data/log01b.dbf'
) SIZE 1000M,
GROUP 2 (
'/d02/oracle/TEST/db/apps_st/data/log02a.dbf’,
'/d02/oracle/TEST/db/apps_st/data/log02b.dbf'
) SIZE 1000M
DATAFILE
'/d02/oracle/TEST/db/apps_st/data/a_archive01.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_int01.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_int02.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_media01.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_nolog01.dbf’,
'/d02/oracle/TEST/db/apps_st/data/apps_ts_tools01.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_queue01.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_queue02.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_ref01.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_ref02.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_ref03.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_summ01.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_txn_data01.dbf' ,
'/d02/oracle/TEST/db/apps_st/data/a_txn_data02.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_txn_data03.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_txn_data04.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_txn_ind01.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_txn_ind02.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_txn_ind03.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_txn_ind04.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_txn_ind05.dbf’,
'/d02/oracle/TEST/db/apps_st/data/a_txn_ind06.dbf’,
'/d02/oracle/TEST/db/apps_st/data/ctxd01.dbf’,
'/d02/oracle/TEST/db/apps_st/data/odm.dbf’,
'/d02/oracle/TEST/db/apps_st/data/olap01.dbf’,
'/d02/oracle/TEST/db/apps_st/data/olap.dbf’,
'/d02/oracle/TEST/db/apps_st/data/owad01.dbf’,
'/d02/oracle/TEST/db/apps_st/data/portal01.dbf’,
'/d02/oracle/TEST/db/apps_st/data/sysaux01.dbf’,
'/d02/oracle/TEST/db/apps_st/data/sysaux02.dbf’,
'/d02/oracle/TEST/db/apps_st/data/system01.dbf' ,
'/d02/oracle/TEST/db/apps_st/data/system02.dbf' ,
'/d02/oracle/TEST/db/apps_st/data/system03.dbf' ,
'/d02/oracle/TEST/db/apps_st/data/system04.dbf' ,
'/d02/oracle/TEST/db/apps_st/data/system05.dbf' ,
'/d02/oracle/TEST/db/apps_st/data/system06.dbf' ,
'/d02/oracle/TEST/db/apps_st/data/system07.dbf' ,
'/d02/oracle/TEST/db/apps_st/data/system08.dbf' ,
'/d02/oracle/TEST/db/apps_st/data/system09.dbf' ,
'/d02/oracle/TEST/db/apps_st/data/system10.dbf' ,
'/d02/oracle/TEST/db/apps_st/data/system11.dbf' ,
'/d02/oracle/TEST/db/apps_st/data/system12.dbf' ,
'/d02/oracle/TEST/db/apps_st/data/undo01.dbf';