Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Binary types
In article <37016182.A30A3DF3_at_gwl.com>,
Dogan Cibiceli <dcib_at_gwl.com> wrote:
> bilal_z_at_my-dejanews.com wrote:
>
> > I have 2 questions:
> >
> > How can you enter a binary file into a table in Oracle 8? I know that you
> > declare the datatype as 'raw', but how exactly is a .gif (for instance)
> > entered. Also, how do you create a new schema? I cant figure that
> > out...uptill now all my tables are part of the System schema.
> >
> > I'd appreciate it if someone can help me out.
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
> Hi bilal,
> first of all , you should read your gif file into a buffer and then insert
> it using this buffer. Look oci or Pro*c for examples.second is create schema
> should be your answer :)
Thanks Dogan,
The problem is...I cannot find 'create schema' anywhere in the schema manager.
The only 'create' there is for all the schema objects, but nothing for a new
schema itself.
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 09:42:20 CST