Re: Q: separate tables and indexes using imp

From: Christopher Kasper <kasper_at_nosc.mil>
Date: 1995/09/11
Message-ID: <1995Sep11.141429.21307_at_nosc.mil>#1/1


Another way to go is to specify INDEXFILE along with INDEXES=N. This will generate a script to create the tables only, which can be edited and run to the proper tablespace. Then run another import with the same export file with INDEXES=Y, IGNORE=Y while having the schema's default tablespace set to the one you want to contain the indexes and altering quota to 0 on all others to force them into the tablespace you want.

Chris Received on Mon Sep 11 1995 - 00:00:00 CEST

Original text of this message