DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: how to exp/imp indexes only tablespace

Threaded View

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

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