Results 1 to 2 of 2

Thread: Ora 00907 error

  1. #1
    Join Date
    Sep 2010
    Posts
    1

    Unanswered: Ora 00907 error

    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';

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool Just a minute...hang on...

    Quote Originally Posted by Pragati.rch View Post
    ...
    Please provide solution at the eraliest.
    ...
    Sure, just sit down and we will attend your request immediately...

    HINT: You may be missing parameters (depending on your Oracle version).
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •