342 reputation
18
bio website
location
age
visits member for 1 year, 10 months
seen 18 hours ago

23h
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
Dec
26
comment prepared statements are not inserted
So he messed up with his query? He got 1 value and trying to insert 5?
Dec
24
comment prepared statements are not inserted
Are you inserting a question mark into the table? ifso add '' around the ? eg '?'. You have to tell Oracle it's a string. Not used to work with Java so could be wrong.
Dec
23
revised Oracle : How to grant to a ROLE the ability to grant a ROLE to a USER?
added 8 characters in body
Dec
23
answered Oracle : How to grant to a ROLE the ability to grant a ROLE to a USER?
Dec
16
comment Why is SQL*Plus' desc table not showing not null constraints after using dbms_redefinition
Thanks for the feedback, nice problem :)
Dec
16
awarded  Yearling