SysAdminMike
IS-IT--Management
If I export a DB and from server A and import that DB onto server B, do the indexes get recreated? Or are they just imported as is?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Does Oracle Recreate Indexes on import? 1
- Thread starter SysAdminMike
- Start date
- Status
-
1
- #2
SantaMufasa
Technical User
Mike,
The default imp parameter is "indexes=Y", which means that Oracle will re-create indexes. Dump files do not contain any literal index contents...they can only be re-created. You can confirm import-parameter settings by issuing the command-prompt command, "imp help=y".
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”
The default imp parameter is "indexes=Y", which means that Oracle will re-create indexes. Dump files do not contain any literal index contents...they can only be re-created. You can confirm import-parameter settings by issuing the command-prompt command, "imp help=y".
Mufasa(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”
- Thread starter
- #3
- Status
Similar threads
