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,
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
- 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