DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: export problem

  1. #1
    Join Date
    Apr 2002
    Posts
    135
    I tried to export a table

    i got thefollowing error:

    EXP 00056 : oracle error 01033 encountered
    ORA-01033:Oracle initialization or schutdown in progress.

    Then it asked me to enter the username


    please help

    deepa

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Is you database up?
    Try a connection from sqlplus.

    Sanjay

  3. #3
    Join Date
    Apr 2002
    Posts
    135
    yes it is up.i can connect from sqlplus.

    when i do a export as internal/oracle login, then it gives

    ora-01219 error:database not open : queries allowed on fixed tables/views only


  4. #4
    Join Date
    Feb 2002
    Posts
    54
    Check your ORACLE_SID.
    =======================
    Manifest plainness,
    embrace simplicity,
    reduce selfishness,
    have few desires. LAO TZU
    =======================

  5. #5
    Join Date
    Sep 2000
    Posts
    305
    shutdown the database and start it again and then take export.

    hope this will work.
    Shailendra

  6. #6
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    Check your tnsnames.ora file through which you connect to SQL*Plus.

    Your database(through which you are trying to take a export is at mount phase) is down. Try issuing a command
    'alter database open' if it fails then take neccessary action.
    (it will fail only if recovery is required).

    Thanks.
    Vijay.
    Say No To Plastics

Posting Permissions

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


Click Here to Expand Forum to Full Width