Hi Anders..!!

This is not necessary..!! U can directly give import too..!!

We are using Large Objects. The only thing to keep in mind is the name of
the index tablespace should (must)be same.

- Chirag Majmundar../


----- Original Message -----
From: <Anders.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, January 30, 2004 04:00 PM
Subject: Re: Importing data into a different tablespace


>
> Create a user whose default tablespace is XYZ. That is, if you do not have
> any lobs in the dumpfile.
> (Then you will need to first import the structure, then import the data.)
>
> ------------------------------------------------------------------------
> Anders Leffler
> Oracle DBA
> Frango AB
>
>
> |---------+---------------------------->
> | | "Vikas Sharma" |
> | | <[Email Address Removed] | | .co.in> |
> | | |
> | | 01/30/2004 09:06 |
> | | AM |
> | | |
> |---------+---------------------------->
>
>---------------------------------------------------------------------------
-------------------------------------|
> |
|
> | To: "LazyDBA.com Discussion" <[Email Address Removed] | cc:
|
> | Subject: Importing data into a different tablespace
|
>
>---------------------------------------------------------------------------
-------------------------------------|
>
>
>
>
> I have exported the data of USER A from tablespace ABC.
>
> Now I want to import the data into tablespace XYZ in a different
> database.
>
> How can I do it?
>
>
>
> Please help.
>
>
>
> Regards,
>
> Vikas Sharma
>
>
>
>
>
>
> --------
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
Oracle LazyDBA home page