Re: Offline instantiation

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Thu, 28 Aug 2003 00:00:15 +0300
Message-ID: <3f4d1be0$1_1@news.estpak.ee>

Hi!

Depending on your network implementation and processor speed, you might want to try SSH tunneling with -C (compress) option and direct your sqlnet traffic through a compresses (and secure) tunnel. It could help with bandwidth problems, but consumes more CPU.

Tanel.

"cuenta_chou" <member37167_at_dbforums.com> wrote in message news:3292240.1062010256_at_dbforums.com...
>
> Hi everybody,
>
>
>
> I'm using Oracle 9.0.1 with WIN2K. I have a Master Site with some tables
> I want to replicate, and a Materialized View Site. The tables are too
> big, and my network connection isn't enough for this load.
>
>
>
> I'm following the instructions that came in the chapter "Performing an
> Offline Instantiation of a Materialized View Site Using Export/Import"
> of the book "Oracle9i Replication Management API Reference Release 1
> (9.0.1)". Everything goes fine until I try to run as mview_admin
>
>
>
> DBMS_OFFLINE_SNAPSHOT.BEGIN_LOAD
>
>
>
> when I get this error
>
>
>
> ORA-23308: object XXX.YYY does not exist or is invalid
>
>
>
> The object exists and the db link and everything seems to be ok. Could
> somebody tell me how can I fix this problem?
>
>
>
> Many Many thanks in advance (sorry for my bad english)
>
>
>
>
>
> Manu
>
>
> --
> Posted via http://dbforums.com
Received on Wed Aug 27 2003 - 16:00:15 CDT