data import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: data import

  1. #1
    Join Date
    Aug 2008
    Posts
    118

    data import

    Hi,

    I have old system on 10g and trying to move data from 10 g to 11GR2(11.2.0.3) on linux

    I have created instance on 11G already

    if i do full export of 10G database. (expdp system/XXXXXX full=y directory=sys_dmp dumpfile=full_db_expdp.dmp logfile=full_db_expdp.log)

    and then import in to 11G can all the roles and users can come to 11G as well or i will have to create that seperately?

    Thanks

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    Cool

    If you use impdp full=y, All will come.
    You will receive gazillion errors you can ignore.
    Use also the VERSION=10.2.0.? parameter.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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