logs archiveIRC Archive / Freenode / #oracle / 2009 / December / 7 / 1
Dormir
TomJ: look into glogin.sql
TomJ
thanks
aisla
hi, good night !
somebody know that is this wait
"cursor: pin S wait on X"
?
thepro4ever
when I try to install oracle 102g i get a prompt saying could not create jvm instance, any ideas how to fix it?
well this channel is useless
Junior
good morning
thepro4ever
hey
Reign1
hi, anyone got working apex_mail on 11g apex?
what am i missing to make apex_mail (htmldb_mail) work on apex on 11g?
so does anyone got working apex_mail on oracle 11g?
TheBonsai
y0 Junior
Junior
y0 bonsai
how are you?
"long time no see" :)
         

TheBonsai
well, fine so far. playing with 11r2
Reign1
i did these ( http://www.dot.state.ut.us/i/doc/sec_outbound.htm ), but apex_mail doesnt seem to work anyway, what might be the problem?
krz
hi
ive got 3 tables: tbl_user_song_upload, tbl_user_video_uplaod, tbl_user_photo_upload. all of them have more or less same columns. for example, the tbl_user_song_upload: id, user_id, song_id, ip_address, created_at. in tbl_user_video_upload: id, user_id, video_id, ip_address, created_at
should i just have one table called tbl_user_media_upload and the following columns: id, user_id, song_id, video_id, photo_id, ip_address, created_at ?
PaulFertser
krz: probably you want to read about database normalisation rules in general, WP has some good articles iirc.
krz
WP?
PaulFertser
krz: http://en.wikipedia.org
krz: if you're designing a rational database you probably should understand all those concepts: http://en.wikipedia.org/wiki/Database_normalisation
krz: and (unrelated) advice. If you do not know for sure you really need oracle, you better do not bother, it's a real PITA to even install it, and using it is not easy too; better go for mysql5 or postgresql, there's plenty of good documentation for it.
krz
PaulFertser, ok lets try this
ive got 3 tables so far, for photo, video, and song
PaulFertser, should i have a table for each?
or should i just have one table?
mfilipe
hi! I want export table data to a txt file, but I need do a relationship with other tables for export the correct rows. Is there any wayt to do this?
TheBonsai
open a cursor over the SELECT in PL/SQL and use UTL_FILE to write the data out to a file
(google for CSV export, you'll stumble over this method i guess)
PaulFertser
krz: your question is too specific, you need to consider your whole database design and the usecases. I think you need to read some introductory relational database design docs.
usn_work
qwak
TheBonsai
y0
jonr
is id reserved word in oracle?
Dormir
no. are you getting an error?
hAnton
Hello ! where can i install the OAS metadata repository ? only in a new database ? or extisting one ? or both, or in a file system ?
cant remember
mfilipe
Is there any way to I do this http://pastebin.com/d4f1d8ca6 ?
I want export the data but with exp doing relationshop between two tables
sab
hello
philipsd6
hello sab
sab
i am new to oracle
i want to know where can i look for the sample tables to use queries in sqlplus. like we can check the sample table in SQL?
philipsd6
http://wiki.oracle.com/page/scott%2Ftiger
         

sab
the particular page has no answer for my question!
any one please?
TheBonsai
whatever your question was, it wasn't very clear.
philipsd6
I think you need to clarify then sab
sab
let me ask it again
philipsd6
the scott/tiger schema IS the sample schema for Oracle.
sab
there are these tables "emp" and "dept" in scott/tiger schema
right?
philipsd6
yes
sab
i want to know what other tables exist in this schema
where i can i find it?
philipsd6
as scott, select table_name from user_tables;
sab
thank you so much philipsd6
philipsd6
depending on your version however, scott/tiger might not be as simple as the emp/dept tables as it used to be
sample schema in 9i and up is a bit more complicated.
See: http://www.databasejournal.com/features/oracle/article.php/3364161/Oracles-Sample-Schemas-Saying-Goodbye-to-Scott.htm
sab
i just wanted to know the tables of this schema
why are you telling me it could be complicated?
i am new and i am just learning queries
philipsd6
then stick with emp/dept to start with.
sab
yea thanks
what is a cross join?
philipsd6
same as a cartesian product
sab
do we call it Cartesian product in oracle?
philipsd6
cross join, cartesian join, cartesian product are all the same time -- I'm not sure any particular term is associated with a particular database culter
culture
I've just always called them cartesian products.
sab
right
Ayyappan1
any help me what is oracle instance
akm1
Hi all , is there any way to get index definition from oracle data dictionary tables ?
Dormir
Ayyappan1: check the Concepts manual
akm1: dbms_metadata.get_ddl
for info, you can look at dba_indexes
akm1
Dormir, Thanks
Dormir
np
Ayyappan1
any tell me about rman in oracle
puuck
shoot, i was just about to tell him everything about rman
foureight84
Hello
does anyone here use OCI?
BlackBox
buenas a todos
alguien conoce un canal de oracle en espaƱol ?
« prev next »