Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    37

    Unanswered: ORA-00604 and ORA-00904 error

    Hi,

    I use Oracle 7.3.4.0.0 on UNIX SCO operating system
    When i made a normal startup of the base, the request "select * from cat;" work normally
    But when i make a startup with an init.ora file i have this error message :
    ORA-00604: error occured at recursive SQL level 1
    ORA-00904: invalid column name (it points on "cat")

    And then, the same problem appears when i want to export the data base

    anyone knows why i have this error messages ??

    The init.ora has this form :

    db_file_multiblock_read_count = 8 # SMALL
    db_block_buffers = 60 # SMALL
    shared_pool_size = 3500000 # SMALL
    log_checkpoint_interval = 10000
    processes = 50 # SMALL
    dml_locks = 100 # SMALL
    log_buffer = 8192 # SMALL
    sequence_cache_entries = 10 # SMALL
    sequence_cache_hash_buckets = 10 # SMALL
    max_dump_file_size = 10240 # limit trace file size to 5 Meg each
    transactions_per_rollback_segment
    connects to
    global_names = TRUE
    db_name.db_domain

    # define directories to store trace and alert files
    background_dump_dest = $REP_INST/trace
    user_dump_dest = $REP_INST/trace

    db_name = mybase

    control_files=$REP_INST/control/control1.ora $REP_INST/control/control2.ora

    # gestion des ROLLBACK SEGMENTS
    rollback_segments = (SYSTEM, ROLL_SEG1)

    thx

  2. #2
    Join Date
    Feb 2003
    Posts
    37
    up

Posting Permissions

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