| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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
A copy of this was sent to James Dickson <James.Dickson_at_mail.esrin.esa.it>
(if that email address didn't require changing)
On Tue, 16 Feb 1999 19:22:01 +0100, you 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.
>
did they tell you
source$ and i_source1 are objects that are created at database creation and are *not* exported by exp (unless you explicity tell it to using tables=).
this won't happen otherwise...
please don't do that to ANY of the objects owned by SYS or you stand a very good chance of trashing the instance. very dangerous. if the instance had gone down when you dropped source$ and before you recreated it -- who knows what might have happened.
(btw: source$ is frequently chained, especially in databases with 2k block sizes, since the size of a row is allowed to be bigger then the blocksize)
>James
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Feb 17 1999 - 08:45:05 CST
 |
 |