Mike,
Honestly haven't tried it. No time lately, dealing with the "UFH" (User
>From H--L") who thinks that I work exclusively for him (and asks the
most inane questions involviing hours of work on my part to prove to
him that what I said really was right), the other DBA here out on
vacation (vacation? what's vacation?) and gone to visit his family in
China (so much for cell phone numbers) so I'm doing his work as well as
mine....
Right now I'm in "it's working, I'm not changing it" mode. I'll try to
test this when I get some breathing time in a week or 2 or 100.
:)
Rachel
- Michael Thomas <mhthomas_at_yahoo.com> wrote:
> Rachel,
>
> If you create a materialized view (MV) locally for the
> remote table, "... AS SELECT * FROM ..._at_link.. " but
> with predicate 'WHERE ... AND 1=0', does the metadata
> on this MV show you the column size difference?
>
> > > What happens if you just try and copy the remote
> > table to a local
> > > table
> > > and then merge between the two local tables?
> > >
> >
> > that's actually what I was doing.....
> >
>
> I have tried the above technique, for many nefarious
> purposes, and just wondering if it would work in your
> case, too.
>
> Greetings. :-)
>
> Mike Thomas
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Win a $20,000 Career Makeover at Yahoo! HotJobs
> http://hotjobs.sweepstakes.yahoo.com/careermakeover
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri May 07 2004 - 04:50:14 CDT