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;
- I am bringing the new emp data over from the remote_connect database?
- 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).
Received on Fri Jan 17 2003 - 09:30:10 CST
