RE: Re: Renaming tablespace by updating SYS.TS$

Shareplex is a product of Quest's. It reads the redo logs on the source database and replicates the SQL in the target database. Is it better that transportable tablespaces? Good question, depends more on the requirements and budget you have. Shareplex is NOT cheap.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
Sent: Friday, May 09, 2003 3:39 PM
To: Multiple recipients of list ORACLE-L

what is shareplex?

Not too familiar with replication. anyone think that is better than transportable tablespaces? before I hardcore research it?

> From: "Deshpande, Kirti" <kirti.deshpande_at_verizon.com>
> Date: 2003/05/09 Fri PM 02:38:13 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: Re: Renaming tablespace by updating SYS.TS$
>
> Replication? Shareplex?
>
> - Kirti
>
> -----Original Message-----
> Sent: Friday, May 09, 2003 1:08 PM
> To: Multiple recipients of list ORACLE-L
>
>
> import/output, sqlloader is not doable. to much I/O we are talking about 100 gigabytes a day sometimes.
>
>
> >
> > From: "Daniel W. Fink" <optimaldba_at_yahoo.com>
> > Date: 2003/05/09 Fri PM 01:42:42 EDT
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Subject: Re: Renaming tablespace by updating SYS.TS$
> >
> > If you are having to hack at the oracle data dictionary in order to use
> > transportable tablespaces, you need to rethink the process. Based upon
> > the 0 downtime requirement, you need to propose an alternate solution,
> > like export/import, sql*loader, dblinks, etc.
> >
> > I went through this process recently. The development team was very good
> > at resume building, so transportable tablespace was the 'best' option
> > since it was new. They architected the process without ever once testing
> > the actual mechanics. When we identified, via testing and research, that
> > tts was not doable, we had to go back to the beginning.
> >
> > --
> > Daniel W. Fink
> > http://www.optimaldba.com
> >
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.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: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.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: Goulet, Dick
  INET: DGoulet_at_vicr.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).