Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: experience with convert Dictionary managed tbs to LMT with dbms_space_admin

Re: experience with convert Dictionary managed tbs to LMT with dbms_space_admin

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Sat, 2 Jul 2005 19:46:09 +0800
Message-ID: <5e3048620507020446bf3a251@mail.gmail.com>


Couple of worthy-of-notes in an article I wrote at:

http://www.e-dba.net/site/full_article.asp?id=7

Cheers
Connor

On 7/1/05, Mladen Gogala <gogala_at_sbcglobal.net> wrote:
>
> On 07/01/2005 05:19:31 AM, zhu chao wrote:
> > Hi, Lex,
> > Rebuild would be nice but as I said before, our database is pretty
> > big (1TB-3TB)
>
> Nice range of values. Your database can be 1TB but can also be 3 times as big.
>
> > and it is impossible to rebuild it without days's
> > downtime.
>
> Actually, migration is usually much faster. Depending on your hardware,
> 2 hours sounds pretty close.
>

-- 
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jul 02 2005 - 06:48:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US