Import into a different tablespace

I ahve an import file that was created from a series of tables stored in an archive tablespace. I can't use the archive tablespace anymore (data files trashed; tablespace won't drop) and am trying to get the data from teh import file into another tablespace.

I have followed the instructions in the V6 utility documentation and am using the fromuser=/touser= command-line parameters to import the data for a user who does not have access to the original tablespace. I have been able to get this to work a little. The first table gets created in the user's default tablespace, but all subsequent tables (the dmp file contains data from 6 tables) do not get created because the import utility is trying to create them in the original tablespace which is now invalid.

Any tips?

Glenn Received on Tue Nov 22 1994 - 01:53:59 CET