logs archiveIRC Archive / Freenode / #oracle / 2009 / December / 16 / 1
Spec
Heya...I'm looking for a patchset, but I can't seem to find it. Specifically, I'm seeing if there's a patch to get oracle enterprise edition (linux, x86) from 10.2.0.1.0 to 10.2.0.3.x....where should I be looking?
On http://www.oracle.com/technology/software/products/database/index.html , all I see are linux x86 binaries for 10.2.0.1.0
idletask
Spec: on metalink, you can find that
Spec
metalink just redirects me to that flash thing...is that the correct place?
Dormir
Spec: yes, that's the right place. you need a service contract to log in
idletask
dbvault is a PITA when configured by default, really :/
Role separation is all good all well, but it requires that all parties involved (re)train about database administration, really
OK, question... I have a user with "unlimited tablespace" access, which is very, very bad. I now want to forbid this user to write anything to a given tablespace. Is it doable, if yes how, and all this given that I (have to) use dbvault on a full-fledged 11g enterprise edition install?
OK, I have found
Once again, dbvault has striked
sysdba can grant unlimited tablespace, but if you want to grant unlimited quota on this and that tablespace, you have to use one of the specialized dbvault users
xep
Hi all.
I'm wondering if anyone here has had a similar issue to mine with Oracle DB 10g using Oracle JDBC (doesn't matter if I use OCI or Thin in this case) ...
I have a few places where we insert data into a CLOB after a row has been created:
INSERT foo INTO table_foo VALUES (EMPTY_CLOB()) RETURNING foo INTO (?)
I have proper Oracle JDBC code that calls registerReturnParameter(), gets the OracleResultSet and calls getClob() on that and everything, has been working great.
now I take this code and run it with -Doracle.jdbc.defaultNChar=true -- CLOB doesn't get written to in this case.
keep in mind I'm inserting regular ASCII-7 values like "abc123"
and the NLS_LANG of the DB is set to ALU32UTF8 or whatever the right thing for UTF8 ought to be
if I do INSERT INTO table_foo VALUES (?) and just set the clob regularly via OraclePreparedStatement.setString(int, String), no problem -- regardless of whether I set defaultNChar to true or false.
also, if I do the above RETURNING INTO type INSERT with an NCLOB and that flag set to true, no problems ....
it only has problems with the RETURNING INTO type INSERT with CLOBs when using defaultNChar=true.
now the CLOBs are using WE8ISO88591 internally AFAIK
NLS_LANG / NCLOB / N* fields are using ALU32UTF8
if anyone has had a similar problem and knows a workaround other than migrating fields to NCLOB (which is probably what I'll have to do) please let me know
otherwise, I'm going to be filing an enterprise-level support ticket with Oracle tomorrow =\
I'm using Java 5 (doesn't matter if I use Java 6) with latest Oracle 10g JDBC driver -- doesn't matter if I try OCI or Thin
I tried using the 11g JDBC driver but that has less API exposed and won't even give me an OraclePreparedStatement or OracleResultSet to play with
and the standard java.sql classes don't have the methods to allow me to register return parameters.
cyberjames
Hi. I have issue of using ocfs2console that after I add node, there is no devices display in the list. How to fix this?
vill0042
I have 1 ID that returns 3 records. I need a particular column in the table and I need the 3 records "flattened" into a single record. Any ideas? thank you
Dormir
vill0042: http://asktom.oracle.com/pls/asktom/f?p=100:1:2715907404809393::NO:RP::
that has some articles that have suggestions on how to do that
stragg was written by Tom Kyte to do it, but you can write your own function. I had one that did something similar
         

vill0042
thank you :)
can you please give me the link to the stragg code? I searched the net but various results are returned which has nothing to do with tom.
thank you
Junior
lalala
i have the following issue, and i know that i'm forgetting something basic, but don't recall right now ... http://pastebin.com/m70d44070
TheBonsai
Junior: also ask #sql
Junior
yo ;)
asked there too :)
mattboll
hi, I've got a dump but I'm not sure if it is a full dump or not, is there a way for me to know ?
if I've got an oracle up and running with a database, may I import a full dump without breaking everything ?
Junior
never mind... fmm.. i looked this morning at a different column than the one that i was supposed to (net not gross value )
fmmm
spent 4 hours on this
paissad-hp
hi all, i followed this tutorial to build tora !
https://help.ubuntu.com/community/HowToBuildToraWithOracle
i build it successfully, but i don't have into "connection provider" -> Oracle
i just see Mysql
i should see oracle like in this picture ! https://help.ubuntu.com/community/HowToBuildToraWithOracle?action=AttachFile&do=view&target=tora-connect.png
so i would like to know if it's possible to import connections in order to have oracle
thanks in advance
NOW,when i try to import a connection, it is said that i have to import connections from a XML file, but i don't know which file
does someone have an idea ?
http://www.zimagez.com/zimage/capture-1198.php
Reign1
how can i check present SMTP_OUT_SERVER value?
and how do i list all ACLs for the user?
mfilipe
what is wrong with this sql http://pastebin.com/d14820932 ?
Xgc
mfilipe: SELECT only proper aggregates.
Reign1
how can i check present SMTP_OUT_SERVER value?
hali
Reign1: show parameter smtp_out_server ?
Reign1: or select value from v$parameter where name='smtp_out_server'; if you need it from sql
Reign1
true, thanks :)
wtf? i grant execute access to all these for the user and still get: ORA-24247: network access denied by access control list (ACL) ORA-06512: at "SYS.UTL_TCP", line 17 ORA-06512: at "SYS.UTL_TCP", line 246 ORA-06512: at "SYS.UTL_SMTP", line 115 ORA-06512: at "SYS.UTL_SMTP", line 138 ORA-06512: at "SYS.UTL_MAIL", line 386 ORA-06512: at "SYS.UTL_MAIL", line 599
tho UTL_TCP UTL_SMTP and UTL_MAIL were granted execute to the needed user :/
mfilipe
Xgc: I know, but I want use osuser to aggregate.
Reign1
i grand execute on UTL_TCP UTL_SMTP UTL_MAIL for the user and still get: ORA-24247: network access denied by access control list (ACL) ORA-06512: at "SYS.UTL_TCP", line 17 ORA-06512: at "SYS.UTL_TCP", line 246 ORA-06512: at "SYS.UTL_SMTP", line 115 ORA-06512: at "SYS.UTL_SMTP", line 138 ORA-06512: at "SYS.UTL_MAIL", line 386 ORA-06512: at "SYS.UTL_MAIL", line 599
what can be wrong?
idletask
Hello
Anyone using 11gR2 + dbvault + iFS?
mastro
how do I insert / select a blob from unix script? (calling sqlplus I think) but I don't know how
DOGLINO
I need to insert a date like '02/2000' in field date, i'm receveing it '02/2000' from a form html,
idletask
Is it possible with dbvault to say that all objects _except_ a few from a schema should be protected?
brutuz
i was wodering if someone can give me suggestion on how to export data to a file wherein data are foreign chars..
cant save it as csv..
because its going to be garbage.
         

kamsky
hi, how can i concatenate 2 sentences in oracle without semicolon?¿ (if i use it, fails, wrong character)
Dormir
what are you trying to do? concat 2 sentences isn't clear
kamsky
select * from db1;select * from db2; ---> this in mySQL works, in Oracle fails
Dormir hablas español?
Dormir
n
no
kamsky
ok
Dormir
why not just put the selects on 2 lines?
or are you trying to merge the resultsets?
kamsky
mmm... think i need do it in one line, why is not important xD
Dormir
not possible
kamsky
not possible?? ouch :(
Dormir
that's why I asked why you're doing it that way. there may be a different way to do it
kamsky
sql i
Dormir
but doing select * from a; elect * from b; doesn't work
kaylee_work1
I'm sure this is a stupid question...but do I need to set anything in my configuration or whatever to make dbms_output.put_line actually print the output to the console?
Dormir
set serveroutput on size 1000000
kaylee_work1
son of a
thanks
!
« prev next »