Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bug in 8.0.5.1 with export/import
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