-
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?
Last edited by newbie5; 02-07-2003 at 02:21 PM.
-
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
-
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?
Last edited by newbie5; 02-07-2003 at 02:34 PM.
-
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
A Wise Man Knows How much he doesn't know !!!
-
.
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
A Wise Man Knows How much he doesn't know !!!
-
virajvk,
It explains why I get nothing for P/U indexes, but what about specifically created indexes in the tablespace?
-
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
Last edited by D Maverick; 02-09-2003 at 11:46 PM.
The Maverick
Oracle Certified DBA - 8i
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|