Re: How can I re-import after tablespace not found?

Kaka wrote:
> I am currently in the middle of the large database import. I am
> currently seeing some error about tablespace not created. I know I
> need to create these tablespace in order to have a successful import.
> However, at this point, I would like to let the imp continue to run
> without terminating it because the import really takes up a lot of
> time. The question is, after this import is done, and after I create
> those missing tablespaces which was complained during this import.
> How can I re-import the objects which was originally failed to import
> due to the tablespace was not there?
>
> Please advise... thanks!
>

Run the import again, but this time, use the TABLESPACES parameter to explicitly denote those tablespaces you created anew. The imp process will skip the objects in the tablespaces not in the list.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com