Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help Export /Import -- Prob
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.
You have at least two options:
Regards,
-- Jurij Modic Republic of Slovenia tel: +386 61 178 55 14 Ministry of Finance fax: +386 61 21 45 84 Zupanciceva 3 e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000Received on Sun Apr 27 1997 - 00:00:00 CDT