how to exp/imp indexes only tablespace

[newbie5]

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?

[sysdba]

In the importing database, do you have tables created?
If not, I do not know there is a way to import index only.
And it does not make sense either without tables.
If you have tables created before importing, you can
import index only by using ignore=Y

[newbie5]

sysdba,

Thanks for the reply. I have all the tables in other tablespaces. This table has INDEXES only. I disabled all the P/U constraints for indexes in this tablespace before dropping the tablespace. Is this a problem?

[virajvk]

you can import index only by using ignore=Y

Hold on What does your tablespace contents only indexes ?
You can not export Indexes only DDLs for Indexes are written to Export Dump.

So check for existance of objects , Retrived index file and run for DDLs regarding Indexes statements.



virajvk
------------
OCP 9i DBA

[virajvk]

.
I disabled all the P/U constraints for indexes in this tablespace before dropping the tablespace. Is this a problem?

Yes Enable constraints for primary key and unique key.
When you disable these constraints Implicit Indexes are dropped


Viraj
----------
OCP 9i DBA

[newbie5]

virajvk,

It explains why I get nothing for P/U indexes, but what about specifically created indexes in the tablespace?

[D Maverick]

Hi guys,

perhaps you can also post the parameters n options in exp/imp to help us understand better =)

this is quite an interesting topic =) Thanks