Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Unanswered: DB export from one SID and same data import in another SID

    Hi Friends

    Would like to know if it is possible to Export a User from one Database SID and Import the same to another Database SID. If possible, please let me know because I want to export User from one DB SID and Import the same to another DB SID. Is there any way? Help required.

  2. #2
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102

    Re: DB export from one SID and same data import in another SID

    yes. it is possible.jsut do something like 'exp file=xxx owner=yyy ...'
    and after changing ORACLE_SID 'imp file=xxx fromuser=yyy touser=yyy ...'
    ^/\x

Posting Permissions

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