"Calvin Crumrine" <Calvin_Crumrine_at_dced.state.ak.us> wrote in message
news:3C55A8EA.3DB45FBC_at_dced.state.ak.us...
> I exported a table from a 7.3.4 database but I can't seem to import it
> into the 8.1.7 database I'm creating. Using SHOW=Y it appears that the
> problem is that I cleaned up the tablespace names in the 8.1.7 database.
> Is there no way to import a table into a different tablespace? Am I
> forever stuck with the stupid names under which they were originally
> created?
>
> Thanks.
>
create the table first in desired tablespace then import the table with
ignore = y. Basically import the data only and create table beforehand so
import does not create it.
hth
santysharma
Received on Mon Jan 28 2002 - 13:50:54 CST
