User Import in Oracle 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: User Import in Oracle 9i

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    131

    User Import in Oracle 9i

    Hi,

    I have two databases, Oracle 8.0.4 on Tru64Unix and oracle 9.2.0.1 on Linux 8.0. I have a full export of oracle 8 DB and want to import only three users with object in to 9i Database.

    Can I use full export dump of Oracle 8 DB or i have to first take user level export of 8.0.4 DB and then use fromuser, touser parameters ?

    What other precautions i have to take before doing this operation ?
    Thanks,

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    you can use any one of those methods. The only advantage with full DB export will be that you have the option to import other users too if you later want to. And any way you need to do fromuser touser in both cases if you are importing only users.

    Precautions.

    1. Create the tablespaces to which those users belong.
    2. Create users. (This only in case you do userlevel import, for full db import this is not required)

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    You can use the FULL.DMP. Always take more than is needed, this way you will have it if the original request changes.

    You can do any level import from a full dump since you have everything in there. There should be no problem going from an 8 export to 9i import. The opposite would not work.

    You will need to code...

    FROMUSER= Mr.Hanky, adweri, Yo_Momma!, Yo_Papa!
    TOUSER= Mr.Hanky, adweri, Yo_Momma!, Yo_Papa!

    in your import.par file. Make sure the order is the same in fromuser/touser.

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Mar 2001
    Posts
    131
    Thanks......Amar, MH

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