348 reputation
19
bio website
location
age
visits member for 1 year, 11 months
seen yesterday

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
Apr
14
awarded  Citizen Patrol
Mar
24
comment Stock price database optimization in MySQL
What's the source?
Mar
4
comment ORA-01658 on index tablespace when trying to insert into empty table of new database
other way around :P it's true and you want false :D
Mar
3
comment ORA-01658 on index tablespace when trying to insert into empty table of new database
Is deferred segment creation enabled? It's probably false. You could try setting DEFERRED_SEGMENT_CREATION=true.
Feb
13
answered Exporting from Oracle enterprise edition to standard edition reaches schemas limit
Feb
13
revised Exporting from Oracle enterprise edition to standard edition reaches schemas limit
added 907 characters in body
Feb
13
asked Exporting from Oracle enterprise edition to standard edition reaches schemas limit
Jan
13
comment Oracle database Architecture
This is the wrong order ...
Jan
6
answered Capturing Table Changes without killing the server
Jan
3
comment Capturing Table Changes without killing the server
There's a way easier method ... Check flashback query: docs.oracle.com/cd/E11882_01/appdev.112/e41502/…
Dec
31
comment rename datafile when file does not exists
This makes no sense, why would you create dummy files for a tablespace that exists? ifso you can just recreate the tablespace? ... Because apparently you don't need the data in them