4,862 reputation
21529
bio website stackoverflow.com/users/…
location France
age 37
visits member for 3 years, 5 months
seen 5 hours ago

“Well!... That takes the biscuit!”

Joyce, James. The Dubliners

The best way to speed up something is to not do it in the first place.

Kyte, Thomas.


5h
revised Storing Japanese characters in a table
deleted 45 characters in body; edited title
12h
comment Will my sqlite database occupy less space if I insert nulls instead of zeros
Why don't you try it out and see for yourself?
1d
revised Query working in phpMyAdmin but not in Java
edited title
2d
comment Why there are so much restriction on LONG datatype in Oracle
It's deprecated because they introduced better stuff.
2d
comment Why there are so much restriction on LONG datatype in Oracle
Oracle has advised against using these datatypes for something like 15 years now. Why would they have expended any time (& money) in maintaining and enhancing that datatype when better alternatives are available?
Jan
24
comment Oracle StartUp Issue
Possibly hardware or OS issue, have your sysadmin look at the server. (Get ready to restore that database elsewhere too.)
Jan
23
answered DESCRIPTION_LIST in tnsnames.ora
Jan
21
comment Duplicate databases error
Please copy the error you're getting as text into your question. Images aren't searchable (and the host you used is blocked by some corporate filters).
Jan
21
revised Duplicate databases error
added 30 characters in body
Jan
10
comment create_index_cost used_bytes vs alloc_bytes
That's exactly 2MB/256 8k blocks. Look at the default storage/extent/uniform settings for your tablespace.
Jan
10
comment create_index_cost used_bytes vs alloc_bytes
How much bigger is alloc_bytes when you run this?
Jan
9
comment Is there any other way that we can take auto backup in oracle 11g apart from RMAN?
What problem do you have with RMAN exactly? Why are you looking for something else than the standard backup tool to do backups?
Jan
8
comment How can I in Oracle discover the average number of rows affected per transaction?
Could you elaborate on you mean exactly? "Modified" rows? By itself a number of rows is pretty meaningless in itself - some queries can return thousands of rows at essentially no cost, while some others might put an instance "on its knees" for hours and return nothing at all.
Jan
8
revised Can't open/select a table created with another user
added 27 characters in body; edited title
Jan
7
comment Difference between database vs user vs schema
@NealWalters: no, you can't create a schema without creating a user. Security's orthogonal, that user doesn't need to have any privilege at all. That's just how it works, get used to it.
Jan
7
comment Difference between database vs user vs schema
@NealWalters: yes, although it's not "first". You just create the user, then create your tables/views/whatever. There's a create schema but... that doesn't create a schema :-)
Jan
5
comment Database design what are your thoughts
ORMs, persistence managers, various sorts of "frameworks" already do this. More or less badly. It's very hard to get right, given the slight semantic differences between the various DB engines and their (not slight at all) differences in how they "like" their schemas and queries designed.
Jan
2
revised How to Avoid Mutating Error in Oracle
added 152 characters in body
Jan
1
revised Trying to copy a schema using impdp
added 53 characters in body
Dec
31
revised Understanding statistics, execution plans, and 'ascending key problem'
added 130 characters in body