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

Thread: import all objects from dumpfile

  1. #1
    Join Date
    May 2000
    Location
    maryland hights
    Posts
    20
    i took the export all the objects from user A and i want to import into another database user B i can import only tables i want to import all the object including synonyms,procedurs and packages ...can anyone help me ...


    thanks you
    Nallamothu

  2. #2
    Join Date
    Mar 2001
    Posts
    63
    If you export by owner mode, it will export all objects owned by that user, including synonyms, packages, and procedures.

    Did you need to export packages owned by another user?

  3. #3
    Join Date
    May 2000
    Location
    maryland hights
    Posts
    20
    export file is exported by the owner and i'm impoting as a system into some schema..
    Nallamothu

  4. #4
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    It'll import everything.

  5. #5
    Join Date
    Apr 2001
    Posts
    37
    if you haven't resolved yet this problem,
    include in import command line:

    imp system/manager.. fromuser=A touser=B

    It may help.
    inosov
    Brainbench MVP for Oracle DBA

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