Export and Import in Oracle 6 question

From: anil golla <anil_golla_at_merck.com>
Date: Thu, 03 Dec 1998 21:06:44 -0500
Message-ID: <366743B4.908CFAA_at_merck.com>



Hi,

        I am exporting a table in Oracle 6, dropping the table and creating the same named table with some modifications by running a script and then importing data into this table. Sounds simple. After I finish importing, I no longer have the indexes associated with the table.

For EXP:

   EXP un/pw GRANTS=Y INDEXES=Y CONSTRAINTS=Y FILE=ABCDEF.DMP TABLES=(ABCDEF)         (Even though indexes and constraints are 'Y' by default, I am still using it)

For IMP:

    IMP un/pw FILE=ABCDEF.DMP INDEXES=Y FULL=Y

        I tried several combinations, still I can'y get the indexes back. Am I doing something wrong? Please advise.

thanks in advance

  1. Ka Gauranskas
       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.
Received on Fri Dec 04 1998 - 03:06:44 CET

Original text of this message