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

Thread: Export from a user to another

  1. #1
    Join Date
    Feb 2001
    Posts
    100

    Question Export from a user to another

    Hi all,

    I want to understand why when I export all the objects of a user to another user, I have always some triggers which have the old schema as table owner. What can I do to avoid this problem

    Thanks in advance

    NED

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You should post your import and export commands.

    However this should work:

    exp system/pwd@aliasa owner=schema-a

    imp system/pwd@aliasb fromuser=schema-a touser=schema-b ignore=y commit=y buffer=102400

    schema-b should already exist. and it should have the basic grants connect, resource.

    I have done this before and it does work unless there is something different about your database it should work.

  3. #3
    Join Date
    Feb 2001
    Posts
    100
    That exactly what I always do Gandolf

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