Re: Import table into different tablespace

Svend Jensen wrote:

> 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

Thanks. FromUser/ToUser works. Received on Tue Jan 29 2002 - 18:02:27 CST