Re: materialized view of a remote partition

2002-09-06 Thread Ray Stell 

On Fri, Sep 06, 2002 at 07:23:28AM -0800, Ray Stell wrote:
> 
> 8.1.7.4
> 
> create snapshot TEMP as 
>   select * from [EMAIL PROTECTED] partition (020904)
> 
> ERROR at line 1:
> ORA-14100: partition extended table name cannot refer to a remote object


Well, it ain't pretty, but...

on the remote db:

SQL> create snapshot eh_snap as select * from emp partition (e18);

Materialized view created.


on the local db:

SQL> create snapshot eh_snap as select * from [EMAIL PROTECTED];

Materialized view created.
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: materialized view of a remote partition

2002-09-06 Thread Mandal, Ashoke 

Hi Ray,

Please let me know if you received any answer.

Thanks,
Ashoke

-Original Message-
Sent: Friday, September 06, 2002 10:23 AM
To: Multiple recipients of list ORACLE-L



8.1.7.4

create snapshot TEMP as 
  select * from [EMAIL PROTECTED] partition (020904)

ERROR at line 1:
ORA-14100: partition extended table name cannot refer to a remote object

why not?
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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.com
--
Author: Mandal, Ashoke
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).