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

    Unanswered: Import into different schema

    export done using user1 and now I want to import the dump into different user called "user2".
    Is it possible without DBA privileges or dba user.
    Or is there any special privilege for just doing the above.
    Thanks
    YDJ

  2. #2
    Join Date
    Dec 2003
    Posts
    47
    You can use this command:
    imp user2/<passwUser2> file=<filename> fromuser=user1 touser=user2

Posting Permissions

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