Re: Bug in 8.0.5.1 with export/import

From: Andrew Protasov <a_protasov_at_hotmail.com>
Date: Thu, 18 Feb 1999 04:34:32 GMT
Message-ID: <7ag58o$dvn$1@nnrp1.dejanews.com>

Hi,

Do not do any direct DML with SYS objects! It is prohibited by Oracle.

It is not a bug, because SYS objects are not usual schema objects.

Once I made an experiment with my test database in 7.2.2. I tried to decode all sources in SYS.SOURCE$ from one character set into another via usual update statement. I totally destroyed the contents of this table. Update was semantically corect and I tested it in an ordinary schema previously.

Andrew Protasov

In article <36C9B749.2D5B_at_mail.esrin.esa.it>, James Dickson <James.Dickson_at_mail.esrin.esa.it> 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
> --
> james_at_valhall.esrin.esa.it.NOSPAM
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 17 1999 - 22:34:32 CST