Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import table into different tablespace
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 Mon Jan 28 2002 - 15:54:39 CST