Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help Export /Import -- Prob
Pre-create the table in the new tablespace. For IMP, add the option IGNORE=Y. IMP will warn that the tables exists but keep going and load the data.
Good Luck,
Scott
Brian Spears wrote:
>
> HI,
> Keep in mind we have no space to place with...
>
> I have exported 4 tables with the compress=y. The tablespace was
> near full. I was hoping to get some space. the tables exported
> were like 1gig size and won't import back into same tablespace.
>
> After some research I figure that there is not enough contigous
> space in that Tablespace.
>
> QUESTION: How do I import so that the table uses another tablespace?
>
> I tried Changing the Default tablespace for the export
> user and import but I see it is still trying to put
> it in the orginal table space. Am I missing something?
>
> PS I don't have a export of the entire original TABLE SPACE.
>
> Brian Spears
> brian_spears_at_dynapro.com
Received on Sun Apr 27 1997 - 00:00:00 CDT