149. You lost the index tablespace in your database. You decided to r
e-create the index tablespace and the indexes in the tablespace. What
methods can you use to re-create the indexes? (Choose all that apply
.)
A. SQL scripts
B. Recovery Manager (RMAN) script
C. Data Pump
D. SQL*Loader
E. Flashback database
Answer: A,C
datapump 导入索引,关键是用参数INCLUDE=TABLE, INDEX.
Eg:impdp tests/tests directory=dump_dir logfile=logfile.log
network_link=crm_test REMAP_TABLESPACE=CRMREPORT:USERS
SQLFILE=sqlfile.sql include=INDEX
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718189/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
