how to exp/imp indexes only tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: how to exp/imp indexes only tablespace

  1. #1
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178

    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 01:21 PM.

  2. #2
    Join Date
    Jun 2000
    Posts
    295
    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

  3. #3
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    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 01:34 PM.

  4. #4
    Join Date
    Jan 2002
    Location
    India
    Posts
    105
    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 !!!

  5. #5
    Join Date
    Jan 2002
    Location
    India
    Posts
    105
    .
    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 !!!

  6. #6
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178
    virajvk,

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

  7. #7
    Join Date
    Sep 2001
    Posts
    261
    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 10: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
  •  



Click Here to Expand Forum to Full Width