428 reputation
29
bio website
location
age
visits member for 2 years, 1 month
seen yesterday

Sep
28
comment Adding numer to varchar and comparing the result with another varchar value, ORA-01722
XE is free depending on what you do with it :P
Sep
26
comment Adding numer to varchar and comparing the result with another varchar value, ORA-01722
Why would you start adding new functionality? :P maybe put some effort in an upgrade
Sep
26
comment If I assign a NVL constraint to a nullable column will it display an error or it will retrieve the records?
errr the issue is the "t_alert" there. But oke.
Sep
26
comment If I assign a NVL constraint to a nullable column will it display an error or it will retrieve the records?
My bad, updated the answer
Sep
26
revised If I assign a NVL constraint to a nullable column will it display an error or it will retrieve the records?
added 177 characters in body
Sep
26
answered If I assign a NVL constraint to a nullable column will it display an error or it will retrieve the records?
Sep
25
comment If I assign a NVL constraint to a nullable column will it display an error or it will retrieve the records?
It's probably the open @ your cursor
Sep
25
comment If I assign a NVL constraint to a nullable column will it display an error or it will retrieve the records?
the problem is not related to your query, can you post the pl/sql?
Sep
25
awarded  Yearling
Sep
24
comment Find columns referenced by virtual column expression
This is just plain weird. If you did the DDL in schema1, why can you just keep it in a log and do it in schema2 later?
Sep
23
answered How to use imdpd to import data file into different schema including index from different tablespace as well
Aug
24
awarded  Student
Aug
11
comment Oracle 12c SYSTEM user locked out
set ORACLE_SID=<fancy instance> then sqlplus / as sysdba, would do the job as well
Aug
6
comment Database design for a table with both bulk insert and single row insert
@FrustratedWithFormsDesigner I can give you some numbers later today or tomorrow, we do daily loads of 30-100M rows. We don't use SQLLDR due to transform, but I tested it in the past to compare speed.
Aug
5
comment Database design for a table with both bulk insert and single row insert
SQLLDR --> only a few x10 seconds for few million rows.
Aug
4
comment Modify text file with Oracle PL/SQL
I've written a procedure doing the same as you are trying, first I create a temp file so R on the text_file.txt, then w on text_file_temp.txt and then I do a UTL_FILE.FRENAME with overwrite true. Didn't check for oracle 9
Aug
4
comment How to write a procedure /job to kill all session running for more than 5mins in Oracle?
there is also the possibility to use resource manager for this. But without version it's hard to give advice
Jul
28
comment oracle emca refusing sys password
You mean emctl is refusing the password? Did you try login in remotely or always local cli sqlplus?
Jul
10
comment Oracle 11g not allowing to connect to. Error ORA-01122: database file 1 failed verification check
database is not open. Alter database open. But you mentioned an alert in your title? Can you elaborate or post the alert.log part?
May
15
comment ORA-00119 & ORA-00130 when trying to startup Oracle
fact is that de db won't crash when you make changes to your tnsnames when it is already running, it could refuse to start indeed