logs archiveIRC Archive / Freenode / #oracle / 2010 / January / 14 / 1
usn_work
got to go, good night oracle folk
blaamann
Evening. I loop through a cursor with two parameters and want to take an action when no rows are found. How do I do that?
http://dpaste.org/fXTr/
bpmuckian
blaamann: I don't think you want a for loop if you want to take action on %NOTFOUND http://dpaste.org/oxx5/
bijoo
Hi, is the Oracle Advanced Security (for DB 10gR2) available for download?
Thanks
Do I have to reinstall Oracle Database to install the Oracle Advanced Security, oracle.network.aso? Thanks in advance.
I'm installed using a response file that was missing the oracle.options:DEPENDENCY_LIST={"oracle.network.aso:10.2.0.1.0"}
Where is the Oracle DB channel? Thakn.s
mheap
Good Morning
I'm wondering if anyone has 20 minutes or so to help me out with some Oracle Apex problems?
I know what I want to do, and the constraints are right (I think)
But the master/detail form won't build correctly
Junior
yello ;)
dedicated vs shared.... tough decision ... :(
blaamann
bpmuckian: Thanks for the suggestion.
Rudemeister
moarning
TheBonsai
y0
         

Rudemeister
'y0
mfilipe
how do I do to increment a variable in oracle?
Rudemeister
mamurdian: sequences?
mamurdian
Rudemeister> yup
:new does not work with delete trigger right?
since there is no new value
Rudemeister
dunnow
mamurdian
as far as i can test it with my beginner knowledge it is so.
Dormir
:new in a delete trigger should be null
been awhile since I've done it, though
mamurdian
Dormir> http://www.adp-gmbh.ch/ora/sql/trigger/new_old.html
Dormir
what does it say, it's undefined?
mamurdian
not sure
Dormir
when in doubt, check the docs. First link: http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_triggers.htm#sthref1222
Rudemeister
hi
m[e]ntor
hello i installed 10g on windows today, configured every thing and get a connection with php to the database, now i want create tables but i get the following error: ORA-01658:
unable to create INITIAL extent for segment in tablespace
FLOW_!
FLOW_1
this file has a size of 5 mb
i request a storage of 500 mb but nothing happens
does anybody know what i can do to get a higher storage on that file ?
mator
mentor, depends on how your tablespace is defined, check server logs why you getting this message.
mentor, and google have enough info to mitigate this error
like autoextent or 'add a datafile'
m[e]ntor
yes i found several of this hints, but nothing has an effect
mator
and what has you tried ?
dam
should be 'what have you tried'
m[e]ntor
i tried to resize the flow_1.dbf file to 1000mb
but i get a error ora-01516 on that
no logfile/datafile/tempfile
mator
select file_name from DBA_DATA_FILES
mentor, what the exact 'alter database' statement was ?
m[e]ntor
alter database datafile 'C:\app\OT\oradata\orcl\FLOW_1.DBF' resize 1000m;
i also tried to resize it in the apex: 'Home>Administration>Manage Services>Request Storage' to set it to 500 mb but nothing happens
i only get the message:
You have requested an additional 500 Mb of space.
but if i try to create a new table i get the error above
mator
mentor, put somewhere pastebin 'select * from DBA_DATA_FILES'
         

m[e]ntor
k
http://pastebin.ca/1751060
need to be resize that file: C:\APP\OT\ORADATA\IDF\USERS01.DBF ?
Orbit
Hello.
I was able to download Oracle11gR2 after a few days try. Now, I read the checksum and the size of the file from their web site and compute my download file checksum, the result is different. Does anyone know how the Oracle calculates the checksum of the zipped files.
m[e]ntor
mator
i think i´ve got it
the paste is the wrong database
i have reconnect sqlplus to the other db
Orbit
DiscordianUK, do you know how Oracle computes the checksum on their files.
m[e]ntor
the flow_1.dbf was also 5mb
so i alter that file there, withno error
and the creation of a new table works
DiscordianUK
Absolutely no idea sorry
Orbit
Does anyone know how to verify the finger print of a download file from Oracle?
m[e]ntor
thanks for your help
Orbit
who is expert about oracle in this room?
This is the room for the Oracle. Am I right?
Dormir
yes, this is a room for Oracle
DiscordianUK
Orbit yes
Orbit
sj, hi man. I need to know how to verify the finger print of downloaded file from the Oracle site. Do you have any idea. It seems in this party room no one listens to me.
mator
Orbit, http://forums.oracle.com/forums/thread.jspa?threadID=833899
DiscordianUK
I listened to you and told you I did not know
Dormir
people listen, they're just busy with their own work at times
so, at times, it takes time to get a response
Orbit
Thanks for sparing your time with me.
Dormir
and Disco did answer you
Orbit
Thanks all for their help.
mfilipe
I want pass of 1 to 1000 in IN of WHERE clause. How do I do this?
I want create a number range
one range function in oracle?
hum... BETWEEN 1 AND 10000 :)
I went only this
Dormir
you want to do what?
you want to pass the endpoints of a FOR loop to a stored procedure?
or do you want to loop through values, passing each to a procedure?
Egyptian[Home]
evening all
is it possible for a procedure to call a binary or shell script (to run as is) within the procedure? i.e. the procedure does nothing just calls the program?
Dormir
yeah, look into extproc
Egyptian[Home]
Dormir: thanks umm.. before i delve too deeply .. does this work on oracle racs too ?
Dormir
my guess would be yes and it'd need to be set up on each node, but I haven't done it, so I'm not sure
Egyptian[Home]
Dormir: thanks
Dormir
np
mfilipe
Dormir: I want get rows when id is between 1 and 10000 ~
Dormir: curiosity... Dormir is equal sleep in brazilian portuguese :)
Dormir
yep, in Latin, Spanish, French, etc
mfilipe: you want to get rows from a table when the id is between 1 and 10000?
mfilipe
yes
Dormir
you can either use greater than and less than or between. comparison operators are in the docs
zasz
are you sleepy, Dormir
mfilipe
do you know the url to oracle docs?
Dormir
docs.oracle.com
as I told a guy yesterday, I make it so that everyone can sleep comfortably when I manage databases
lol
zasz
hahahahh
cheesy :P
Dormir
very much so
giusef
Did anyone of you partecipated at Oracle Fusion Middleware eSeminair, today?
mids
I am looking for an oracle schema migration tool; like Rails migrations or Django's South; but fully PL/SQL
Rudemeister
really?
mids
could you recommend such a thing?
Rudemeister
fully plsql ghmm no
write your own?
mids
seems like it
ComputerNoobie
why do developers who knows oracle make so much money
compared to people who use mysql
dsdel
no one would ever use mysql for real production purpose, only for websites and small supplementary apps :D
jason_froebe
I don't know about that.. MySQL has it's uses just as Oracle does. ultimately they are just tools
ComputerNoobie
so aside form knowing sql, whats so hard about knowing oracle
jason_froebe
from a developer or dba point of view?
your question would be equivalent to someone asking what's so hard about driving a semi truck with three trailers when the person is comparing it to a Jeep Wrangler.
ComputerNoobie
i see
Rudemeister
ehr
wazzup
jason_froebe
for a front end developer, you don't have to learn PL/SQL (or any other SQL dialect) if you don't want to, there are ORM's that will 'hide' the database backend from you.
for a dba... a dba needs to know the dbms, regardless of which dbms, inside and out.. most of the commercial dbms's have so many features and tunable things in it that it becomes an art
each dbms has pros and cons.. use what best fits the task
hope that answers your question
rizzo
hoffa!
hoffa
umm
hello
avaia
made it out of the meadowlands
Rudemeister
ho
jason_froebe
Rudemeister.. that should be "Thundercats! ... HO!" ;-)
Rudemeister
ho
hoffa
he's not catching on
the xmltransform() example I see shows that you need to insert your xsl into the database, and pass that in as the second argument. is there a way to use an xsl file on the file system rather than inserting it into a table first?
I'm looking here: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions229.htm
stoick
i asked about this the other day, but did not have a lot of time. i have a sql statement that joins 6 tables to get what it needs. it takes about 60 seconds to run. when i queried with 3 of those joins into 1 table, and modified the sql after that to use this new table, it ran in 1.5 seconds. why such a change? and is there anything i can do to get this performance without having to maintain another table?
Dormir
stoick: create a materialized view
Rudemeister
wow
stoick
i'll give it a shot, thanks
Dormir
if done right, no need to change the query...query rewrite will use the MV instead of joining the tables
stoick
oh yeah
Dormir
it's an option anyway
« prev next »