Re: [imp] getting error ORA-01461

Unfortunately, I don't have the ORACLE 8 documentation with me right now, and don't have the time to go to http://docs.oracle.com to get the relevant info.

But, in the ORACLE 8 utilities documentation, you should look at the export/import part. In ORACLE 7, we see that

<quote>

Exporting LONGs
On import, LONGs require contiguous memory. Therefore, it is not always possible to export LONG columns from one operating system and import them on another system. Even on the same system, memory limitations may make it impossible to import very large LONG columns that were successfully exported on that system.
Warning: LONG columns can be up to 2 gigabytes in length. Because they can be exported in sections, Oracle LONGs are always exportable.

</quote>

and that

<quote>

Importing LONGs
Warning: LONG columns can be up to 2 gigabytes in length. Because they can be exported in sections, Oracle LONGs are always exportable. On import, however, LONGs require contiguous memory. Therefore, it is not always possible to export LONG columns from one operating system and import them on another system. Even on the same system, memory limitations may make it impossible to import very large LONG columns that were successfully exported on that system.

</quote>

Apparently, what happens to you is that the LONG you try inserting cannot be inserted in a single extent. You should try recreating the table with a greater initial extent, and see if it solves the problem. You may also have to look in the tuning section of the manuals, if the cause is not from extent size but from SGA size.

Hope this helps,

FiX

"Sascha Kiefer" <sascha.kiefer_at_pikon.com> a écrit dans le message news: 1a4ec7a7.0111130354.76bb8a95_at_posting.google.com...
> Hi,
>
> I have two databases. With exp I exported a user from the first one
> and I want to create the user in the second one with imp.
>
> So far so good.
>
> There ist one table in the user-scheme with a long-column. When imp
> trys to import this table I get a Oracle error message ORA-01461: Cant
> bin a LONG value only for insrt into a LONG column.
>
> What went wrong. The table should be createtd the same way the old one
> was?
>
> The export db is a 8.1.6 and the import db is a 8.1.7. Can this matter
> ? Normally it shouldn't.
>
> Thanx in advance
>
> Sascha
Received on Thu Nov 22 2001 - 10:33:18 CST