343 reputation
18
bio website
location
age
visits member for 1 years, 7 months
seen 6 hours ago

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
Dec
16
comment Why is SQL*Plus' desc table not showing not null constraints after using dbms_redefinition
And there is no issue as for as I know to alter the timestamp to date with alter table.
Dec
16
comment Why is SQL*Plus' desc table not showing not null constraints after using dbms_redefinition
just wondering, what's the output of the following?select column_name as "Name" , nullable as "Null?" , concat(concat(concat(data_type,'('),data_length),')') as "Type" from user_tab_columns where table_name = 'TQ84_REDEFINITION';
Dec
16
comment Why is SQL*Plus' desc table not showing not null constraints after using dbms_redefinition
1) What version are you on? I can't recreate it on 11.2. <br/> 2) Why don't you use alter table <table> modify (xx xx NOT NULL);