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.
>
> Brian Spears
> brian_spears_at_dynapro.com

There are two ways to do this (at least)  

1. Pre-Create the objects in their desired tablespace or
2. Set the Default Tablespace for the schema to the desired tablespace

     BOTH Methods require the import parameter IGNORE EXISTING OBJECTS to be set to YES (This will cause IMP to overlook any pre-existing objects)

-- 
Jim Robertson                   Enron Capital & Trade Resources
Information Technology          1400 Smith Street
email: jrobert_at_ect.enron.com    EB-3419B
vmail: 713/853-7801             Houston, Texas 77002 
fax:	713-646-3010