Schema level import using full database export
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Schema level import using full database export

  1. #1
    Join Date
    May 2006
    Posts
    41

    Schema level import using full database export

    Is it possible to do schema level import using full database export,If so,if i set the

    fromuser=system
    touser=(user1,user2)


    Will it allow me to import only USER1 schema objects successfully?

    Please advise needed on this,because when i tried to do schema level import by setting fromuser & touser like above,it started
    to do full import.

    So,tell me how can i successfully to do a schema level import using full database export

    Thanks.

  2. #2
    Join Date
    Mar 2006
    Posts
    2
    For parameter fromuser, you must specify owner of the source schema.
    Such as you have a full export file:full.dmp, source schema is owner by user1 and destination schema is user2.

    imp system/manager file=full.dmp fromuser=user1 touser=user2

  3. #3
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    If you set the fromuser and the touser like you said how could it possibly start a full export if you didn't set the variable full=y ?

    why don't you just use the owner variable instead?

    Help=y is a wonderful thing *hint hint*
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

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