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

Home -> Community -> Usenet -> c.d.o.server -> Re: Intermedia indexes and export

Re: Intermedia indexes and export

From: John Darrah <john.darrah_at_usa.net>
Date: Wed, 1 Aug 2001 17:19:42 +0000 (UTC)
Message-ID: <20010801171953.28025.qmail@awcst401.netaddress.usa.net>

Your export will only export the commands to create the index on the new database. This is because an Intermedia index creates both tables and in dexs
as well as (I think) tables with rowid pointers to other tables. Your on ly
option is to do a physical clone of the database. You can't even transpo rt
the drsys tablespace because the index is not entirely contained within t hat
tablespace.                                                                     

Get free email and a permanent address at http://www.amexmail.com/?A

-- 
Posted from acct01.netaddress.usa.net [204.68.24.146] 
via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Wed Aug 01 2001 - 12:19:42 CDT

Original text of this message

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