Re: about replication

A copy of this was sent to news_at_info-line.it (andy) (if that email address didn't require changing) On Thu, 17 May 2001 15:10:03 GMT, you wrote:

>
>I've some Oracle databases with replication.
>Databases are installed on Windows NT machine and the version is
>7.3.4. Instance are in 'NOARCHIVELOG' mode.
>Because tablespace are too defragmented i would like to backup and
>restore the master database with an import and export.
>How can i do it? In paritcular the import phase?
>

do not use exp/imp on a replicated database with 7.x. Replication used rowids in that release. If you take the data out and put it back in you'll have to rebuild all of the copies.

Can you define "too fragmented". If you have objects that are in a couple of dozen/hundreds of extents -- that is OK.

>Thanks in advance.
>
>
>Andy.

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp