Re: "Import succeded with warnings" and ERRORS!?

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>The assertion about pre-existing tablespaces should be read as follows
>
>'If you want to/need to change the location of the files
>you have to precreate the tablespaces (because otherwise the tablespaces
>will either be created in the wrong location or the create tablespace
>command will simply fail.)'
>That said you can quite easily extract the commands from your export, by
>issuing
>imp .. show=y full=y log=<any file>
>and edit <any file>
>
>I'm not sure what's not easy about that.

I will try that. Thanks a lot.

Is it a common practice to truncate all objects of a DB prior to importing a dump file into it?

Rick Received on Sat Oct 20 2001 - 19:09:41 CDT