Re: Creating table with BLOB

On Wed, 8 Oct 2003 18:28:17 +0200, "Moritz Klein" <mklein_at_students.uni-mainz.de> wrote:

>Hello NG,
>i just figured out a problem regarding BLOBs and i am searching to find a
>solution, but using google did not help any further. I am running Oracle 9i
>Enterprise on Suse 8.0. Creating a table in the USERS tablespace just works
>fine, but other tablespaces do not work. Here is a short example i did for
>illustrating the problem:
>
>-----------------------------------------------------------
>Verbunden mit:
>Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
>With the Partitioning option
>JServer Release 9.0.1.0.0 - Production
>
>SQL> create table blob_a (b blob) tablespace users;
>
>Tabelle wurde angelegt.
>
>SQL> create table blob_b (b blob) tablespace yazd;
>create table blob_b (b blob) tablespace yazd
>*
>FEHLER in Zeile 1:
>ORA-03001: Funktion nicht implementiert
>------------------------------------------------------
>
>Maybe someone can help me with this?
>
>Many thanks in advance
> Moritz
>

please type
oerr ora 3001
before posting
and work from there.
Please try to avoid to show you are lazy. Once you leave the uni, this attitude is going to harm you.

--
Sybrand Bakker, Senior Oracle DBA