logs archiveIRC Archive / Freenode / #oracle / 2009 / December / 16 / 1
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 to should I be looking?
On http://www.oracle.com/technology/software/products/database/index.html , all I see are linux x86 binaries for
Spec: on metalink, you can find that
metalink just redirects me to that flash thing...is that the correct place?
Spec: yes, that's the right place. you need a service contract to log in
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
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:
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.
Hi. I have issue of using ocfs2console that after I add node, there is no devices display in the list. How to fix this?
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
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

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
i have the following issue, and i know that i'm forgetting something basic, but don't recall right now ... http://pastebin.com/m70d44070
Junior: also ask #sql
yo ;)
asked there too :)
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 ?
never mind... fmm.. i looked this morning at a different column than the one that i was supposed to (net not gross value )
spent 4 hours on this
hi all, i followed this tutorial to build tora !
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 ?
how can i check present SMTP_OUT_SERVER value?
and how do i list all ACLs for the user?
what is wrong with this sql http://pastebin.com/d14820932 ?
mfilipe: SELECT only proper aggregates.
how can i check present SMTP_OUT_SERVER value?
Reign1: show parameter smtp_out_server ?
Reign1: or select value from v$parameter where name='smtp_out_server'; if you need it from sql
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 :/
Xgc: I know, but I want use osuser to aggregate.
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?
Anyone using 11gR2 + dbvault + iFS?
how do I insert / select a blob from unix script? (calling sqlplus I think) but I don't know how
I need to insert a date like '02/2000' in field date, i'm receveing it '02/2000' from a form html,
Is it possible with dbvault to say that all objects _except_ a few from a schema should be protected?
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.

hi, how can i concatenate 2 sentences in oracle without semicolon?¿ (if i use it, fails, wrong character)
what are you trying to do? concat 2 sentences isn't clear
select * from db1;select * from db2; ---> this in mySQL works, in Oracle fails
Dormir hablas español?
why not just put the selects on 2 lines?
or are you trying to merge the resultsets?
mmm... think i need do it in one line, why is not important xD
not possible
not possible?? ouch :(
that's why I asked why you're doing it that way. there may be a different way to do it
sql i
but doing select * from a; elect * from b; doesn't work
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?
set serveroutput on size 1000000
son of a
« prev next »