(no subject)

David,

The very term MATERIALIZED VIEW means the data is created. In this case you have a segment called EMP in your local database. Users, when they select from EMP, will only see data that has been placed there; they will not see the remote database EMP table. When the MV is refreshed the changes are propagated across to your local DB.

HTH. Arup
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, January 17, 2003 10:30 AM

> If I use Replication such as:
>
> create materialized view EMP
> storage (...)
> tablespace ...
> refresh fast
> start with sysdate next sysdate+1
> as
> select * from emp_at_remote_connect;
>
> 1) I am bringing the new emp data over from the remote_connect database?
>
> 2) This is a materialized view with a local base table. When my user
comes
> in and selects from emp how does he get the new data? Does Oracle join
the
> local base table and emp table? Does it access the view? Or does Oracle
> actually copy the new data into the emp table from the view and local base
> table?
>
> thanks
>
> David Ehresmann.
>
> -----Original Message-----
> Sent: Friday, January 17, 2003 4:54 AM
> To: Multiple recipients of list ORACLE-L
>
>
> an incremental export does not export just the new rows but ALL the
> data in the table. It will, however, only export if there has been a
> change to the table, thus the "incremental"
>
>
> --- Krishna Kakatur <master_dba_at_hotmail.com> wrote:
> > How about using incremental exports/ imports?
> >
> > HTH, Krishna
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Thursday, January 16, 2003 11:19 AM
> >
> >
> > > Use the query= feature of export. This will work if there is a
> > timestamp
> > > column where you can determine which are the 'new' records.
> > >
> > > -----Original Message-----
> > > Sent: Thursday, January 16, 2003 11:49 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > how about, database link
> > >
> > > -----Original Message-----
> > > Sent: 17 January 2003 01:46
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > replication
> > >
> > > -----Original Message-----
> > > Sent: quinta-feira, 16 de Janeiro de 2003 15:09
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > List,
> > >
> > > I have to move data on a regular basis between two instances of
> > 8.1.7 on
> > > two different UNIX servers. The schema is exactly the same. There
> > are
> > 543
> > > tables to be "refreshed". It is only the "new data" on one of the
> > servers
> > > to move to the other. What is the best and easiest way to do this?
> > >
> > > thanks,
> > >
> > > David Ehresmann
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Ehresmann, David
> > > INET: David.Ehresmann_at_ps.net
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting
> > services
> > >
> > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like
> > subscribing).
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Paulo Gomes
> > > INET: PGomes_at_Datinfor.pt
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting
> > services
> > >
> > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like
> > subscribing).
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Sinardy Xing
> > > INET: SinardyXing_at_bkgcomsvc.com
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting
> > services
> > >
> > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like
> > subscribing).
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Fink, Dan
> > > INET: Dan.Fink_at_mdx.com
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting
> > services
> > >
> > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like
> > subscribing).
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Krishna Kakatur
> > INET: master_dba_at_hotmail.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ehresmann, David
> INET: David.Ehresmann_at_ps.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: arupnanda_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).