Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle 8i: how to do a full import to the same database?
Donovan R. <mdonovan_at_hotmail.com> wrote in message news:<fa8i5v0umltsi6k4ktrofugk42rq087uka_at_4ax.com>...
> The shortest way is to drop the application users(not the ones created
> by oracle like sys, system, outln ..) with cascade option, and
> recreate them before the import, because if the users did not exists
> some import versions will create them on the system tablespace. So you
> better already have the users an the tablespace on the database before
> doing the import. You can create a script to produce the script you
> will use for users creation.
If go this way, I will have to do an "imp fromuser=xxx touser=xxx ..." instead of an "imp full=y ...", right?
Thanks,
Bombadil.
Received on Mon Feb 24 2003 - 01:14:00 CST