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

Thread: data import

  1. #1
    Join Date
    Aug 2008

    data import


    I have old system on 10g and trying to move data from 10 g to 11GR2( 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?


  2. #2
    Join Date
    Jul 2002
    Lake Worth, FL


    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