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 KE4TJC 28^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).
