Re: Import table into different tablespace

santysharma wrote:

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

That's what I'm doing-doesn't work. Maybe I'm doing something wrong but I don't know what. I'm using these export parameters:

CONSTRAINTS=N
DIRECT=N
GRANTS=N
INDEXES=N
TABLES=NOTES_TBL And I'm using these import parameters:

DESTROY=Y
IGNORE=Y
TABLES=(*) Import reports "Import terminated successfully without warnings" but no data is in the table. Received on Mon Jan 28 2002 - 14:10:23 CST