Re: Export of snapshot logs on oracle server 7.3.2

A copy of this was sent to wanni_at_mbox2.singnet.com.sg (Wanni) (if that email address didn't require changing) On Sat, 22 May 1999 07:37:15 +0800, you wrote:

>Hi,
>
>I've read 'somewhere' that in Oracle server 7.3.2, the export utility
>does not export the tables of snapshot logs. (yeh, confirmed when we
>performed the export).
>
>However, is there a way to get the contents of these tables and 'put
>them' in the newly created database?
>

the definition of the snapshot log is exported but not the snapshot log itself.

In 7.x, the mlog$_<tname> table contains a ROWID. This is a rowid that points to the parent table. When you export the parent table and import it -- its rowids will naturally change. the rowids in the mlog$_.... table are meaningless if the parent table has been imported.

so, even if you could -- it wouldn't do anything for you. the snapshot log would not contain rowids that made sense in the new database.

>Thanks :)

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri May 21 1999 - 20:19:41 CDT