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?
Yu ca do it full, if the user is already created there is no danger
you will have it in double. A full database export export all schema
less sys. The same for import
On 23 Feb 2003 23:14:00 -0800, bombadil_at_fastmail.fm (Bombadil) wrote:
>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 - 19:56:42 CST