Re: Replication in NOARCHIVELOGMODE

Replication is completely different story and independent from archive mode,
thus everything will remain the same (well, unless you're doing replication
with Streams, but that's a different story)

Deftran is a view which is based on def$_aqcall and def$aq_error tables,
these tables are in system schema, but in which tablespace they are, depends
on your system users default_tablespace setting, in my test db it is tools
for example.

>> Sorry if my question sounds too simple.>> what are the pros/cons of the above?>> Where will deftran be stored? System tbs?. Should i increase my> system tbs size.>>> Thanks> Quriyat DBA>>>>>>> _______________________________________________> No banners. No pop-ups. No kidding.> Introducing My Way - http://www.myway.com> -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net> -- > Author: quriyat> INET: quriyat_at_myway.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: Tanel Poder
INET: tanel.poder.003_at_mail.ee
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).