Re: Import table into different tablespace

Calvin Crumrine wrote:

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

Two ways to do it.
1)
Set the importing users default tablespace to where you want the table to go, assuming the original tablespace dosn't exist and the export file only contains the needed table. Then import the table with fromuser= a touser= a? full=y file=? ignore=y destroy=n grants=? indexes=?... Works with or without table already created in users default tablespace. 2) As you have tried, but with destroy=n, dont destroy tablespaces/files by overwriting. If destroying the import assumes the original tablespace/datafile exists and can be overwritten, but thats not your case as i se it.

rgds

/Svend Jensen Received on Tue Jan 29 2002 - 14:37:29 CST