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: Bug in 8.0.5.1 with export/import

Re: Bug in 8.0.5.1 with export/import

From: James Dickson <James.Dickson_at_mail.esrin.esa.it>
Date: Wed, 17 Feb 1999 15:14:50 +0100
Message-ID: <36CACEDA.2712@mail.esrin.esa.it>


James Dickson wrote:
>
> Finding chaining in object SYS.SOURCE$ and its
> accompanying index SYS.I_SOURCE1, I exported to
> a file, dropped and reimported. Import tried to
> recreate the index with storage parameter:
> FREELIST GROUPS 1
> which (according to page 4-626 of the SQL reference
> manual volume 2 for Oracle 8) is illegal.
> So it failed with:
> ORA-02001: not permitted to create indexes with freelist groups
>
> I've reported it to Oracle as a bug.
>
> James

Oracle replied. They don't consider it to be a bug. They say that SYS' objects should never be exported and imported. The only official solution to chaining in SYS' objects is to recreate the database. Ho ho.

James
--
james_at_valhall.esrin.esa.it.NOSPAM Received on Wed Feb 17 1999 - 08:14:50 CST

Original text of this message

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