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

Thread: Enterprise Manager-not showing export Database option.

  1. #1
    Join Date
    Apr 2006
    Posts
    16

    Enterprise Manager-not showing export Database option.

    Hello,
    I've been working on exporting my database.EM only shows me 2 options: export Tables or export Schema.
    It doesnt show mw the export Database option.
    Also,while exporting tables,I am only able to select tables in SYSTEM schema and nothing else.

    Can you help me solve this problem?Are there any system/object priveleges that I'm missing out on?

    Thanks.

  2. #2
    Join Date
    Jan 2001
    Posts
    3,134
    Use a parfile and stop putzing around with a GUI.

    Makes life easier IMO.
    I remember when this place was cool.

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    You have to login as sys as sysdba or system to do the database export or role granting exp_full_database to the user who is performing the export.

    Select from Tools>database tools> data management>Export

    has 3 options database, tables and user.
    "What is past is PROLOGUE"

  4. #4
    Join Date
    Apr 2006
    Posts
    16
    Quote Originally Posted by dbasan
    You have to login as sys as sysdba or system to do the database export or role granting exp_full_database to the user who is performing the export.

    Select from Tools>database tools> data management>Export

    has 3 options database, tables and user.
    Thanks for the response.

    I gave that role to SYSTEM using SYS account, still I cannot see an option to export full DB as SYSTEM.

    Quote Originally Posted by dbasan
    Select from Tools>database tools> data management>Export
    Could you tell me where is this?I have config and migration tools and integrated management tools in my oracle app.

    Thanks a lot.

  5. #5
    Join Date
    Apr 2006
    Posts
    16
    Does it have to do anything with shared/dedicated oracle servers by any chance?

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no

  7. #7
    Join Date
    Apr 2006
    Posts
    16

    Red face

    Hi guys,
    So I ran the scripts catproc.sql and catalog.sql and it worked! I can see the Database export option now.Feeling somewhat happy happy .

    Thanks for all your help.

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