logs archiveIRC Archive / Freenode / #oracle / 2010 / February / 28 / 1
krb_hnd
hi all
how can I load multimedia file
into oracle
hali
krb_hnd: as a 'file' or a structured media file (with oracle aware of the metadata etc)?
krb_hnd
hali > as a structured media file
hali
krb_hnd: you need to use the CTX package
needs a bit of plsql or java b
oracle multimedia in 11g, used to be called oracle interMedia
what version do you use?
http://www.oracle.com/technology/documentation/multimedia.html for docs
it's a bit of a project, nothing you just do with an insert statement in 2 mins
krb_hnd
I'm using oracle 10R2
so I need to create internal blob data type right?
hali
no
an ordsys datatype
krb_hnd
ordsys?
hali
specific for oracle intermedia/multimedia
i.e. ordsys.ordimage for an image
krb_hnd
ok
         

hali
or whatever type of media file you want to store
it automatically calculates the metadata around it
if you already have the metadata and want to keep it simple, just use a blob and store the rest as values in the same table, but you loose out on the intermedia functions
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14302/ch_metadata.htm#sthref272
krb_hnd
ok
will check the links
sidh
Greetings Gentlemen
I'm reading that doc http://download.oracle.com/docs/cd/B14117_01/server.101/b10749/ch6unicode.htm to know what is the good character set to set and i don't understand the words "Supplementary characters "in the sentence "Supplementary characters are stored as 6 bytes instead of the 4 bytes defined by Unicode 3.2. As a result, Oracle has to convert data for supplementary characters if the client setting is UTF-8"
As i will store European data (france language on ly) i understand utf8 is better than al16utf16
Sajaki
doesnt concern you then as western langguages only use 1 or 2 bytes in unicode
cmug
Isnt UTF16 better than UTF8
UTF16 holds UTF8 plus more ?
sidh
thank you very much Sajaki
oh oh, 'im creating a database from command line, and at the create database statement i get a ORA-01092: ORACLE instance terminated. Disconnection forced
any idea ?
i'm running 10;2.0.1
on Solaris 10
cmug
it should state the actual error above that
as in why the instance is terminated
sidh
CREATE DATABASE cimmalo
*
ERROR at line 1:
that'sz all
as it come from a file that i call with @createdb_cimmalo.sql, does the error could come from the tab in the files used for indentation ?
cmug
I don't think so, but its not impossible either. Try to paste the commands one by one into an sqlplus prompt?
sidh
ok
cmug: pasting line by line get that error too
that's ok there was a typo between my init.ora file , and a TBS in the create databse statement
for permanent tablespace is it better to set AUTOALLOCATE for extent_management or LOCAL (i'm running 10gR2) ?
blu|two
test
Yay, I can speak now.
I'm trying to fill a type with some refs, but i'm not sure how. This doesn't work. http://pastebin.com/0mzxz2bi
I thought I could make a constructor for FRIEND instead, which I am in the process of doing, but I was also wondering how I could throw an error from the constructor if the refs don't actually exist?
usn
godd evening, folks
« prev next »