how to exp/imp indexes only tablespace
I am trying to convert a 9.2 index tablespace into DMT to LMT. I exported as sys all the index objects to an dmp file, dropped and recreated the tablespace, and I am trying to import these indexes and I get NOTHING.
I know that oracle automatically imports indexes when tables are created in an import if indexes=y is specified but can I import Indexes only without the tables?
These are my parameter files:
EXPORT:
tablespaces=(doe_index)
rows=y
grants=y
indexes=y
constraints=y
triggers=y
statistics=none
log=doe_index.log
file=c:\doe_project\export\doe_index.dmp
IMPORT:
full=y
tablespaces=(doe_index)
rows=y
grants=y
indexes=y
constraints=y
statistics=none
log=doe_index.log
file=c:\doe_project\export\doe_index.dmp
Did I overlook something obvious? I know I can rebuild indexes into the new tablespace, but did I miss something here?