Stats collection for upgrade to 11G
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Stats collection for upgrade to 11G

  1. #1
    Join Date
    Jul 2001
    Location
    Montreal
    Posts
    218

    Question Stats collection for upgrade to 11G

    Hi, I have a 10.2.0.5 database running on Windows Server x64bit that I want to move to 11G Linux SUSE10. I will be using export / import. Should I export the database stats from 10G and import into 11G ? Or will export / import take care of this ?

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    I would do the export with statistics=none. However, you are better off using expdp,
    i.e. data pump. It faster, and better supported than the older exp/imp utilities.

    Either way, you should gather all new stats after you migrate the data.
    this space intentionally left blank

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