Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Synchronizing 2 tables in same database -how ?
Thanks Jonathan !
IŽll give it a try, I am eeger to see how long the create will take.
One question though, are there someway to exclude this clone table from being backed up ? Since its rather large table and there is no need to recover it in case of a database crash. We use RMAN as backup technique.
Thanks.
/Christian
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<bpi8l2$i6i$1$8302bc10_at_news.demon.co.uk>...
> Given your description, I don't think you want to follow
> either of my suggestions. It may be best simply to:
>
> Switch synonym to clone table.
> Drop bitmaps on table to be loaded
> Load table
> Recreate bitmaps (nologging)
> Switch synonyms to loaded table
> Drop clone table
> Create clone table as select nologging
> Create indexes nologging
> Create bitmaps nologging.
>
> Even at 60GB the CTAS stuff should fit within
> your remaining few hours.
>
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
Received on Thu Nov 20 2003 - 10:07:25 CST