Re: Import table into different tablespace

No. But then I already know that the data isn't being imported-I just don't know why. (Or better yet, I don't know how to get it imported. I really couldn't care less about why, except that if I know why maybe I can figure out how.)

"Jaap W. van Dijk" wrote:

> Do you also see the
>
> '<table_name> nnn rows imported'
>
> line in your output?
>
> Jaap.
>
> On Mon, 28 Jan 2002 11:10:23 -0900, Calvin Crumrine
> <Calvin_Crumrine_at_dced.state.ak.us> wrote:
>
> >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 Tue Jan 29 2002 - 10:42:14 CST