4,962 reputation
21529
bio website stackoverflow.com/users/…
location France
age 37
visits member for 3 years, 7 months
seen 1 hour 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.


2h
comment Database design trouble for survey application
There are a lot of questions about designs for surveys on this site (just enter survey in the search box). Please look around.
4h
comment ORA-01033: ORACLE initialization or shutdown in progress
Get your DBA to fix it if you don't have enough privileges.
4h
comment alter database open - Oracle11g
Please search, both Google and Oracle Support for that error. It's usually controle file corruption. => support.oracle.com
Mar
9
comment Cannot install Oracle Grid on Oracle Linux 6.4
You need to determine why the grid services don't start. Look at the log files, etc.
Mar
9
revised Cannot install Oracle Grid on Oracle Linux 6.4
added 6 characters in body; edited title
Mar
5
comment Are there any databases with out of the box Point-in-Time-Architecture support?
@Phil: I don't think that'll work with the "change in database schema" requirement. The "Total Recall" option sounds like a better match for long-term tracing, but I don't know if that can handle schema changes either.
Mar
4
comment Recommendation for the mysqldump?
You'll never know how long it takes with your hardware and your load unless you actually test it.
Feb
27
comment Connecting to Oracle SQL Developer locally on Mac?
Yes, it's still like that. You can download pre-built VMs for VirtualBox though (oracle.com/technetwork/community/developer-vm/index.html). (Oh, and "SQL Server" is the name commonly used for Microsoft's database engine.)
Feb
25
comment How I optimize data dump in oracle 11g
No, I can't help you. You need someone who is familiar with backing up that sort of volume, and knows and has access to your environment, and knows the business constraints. You need someone to work with you on this, not a tutorial on the 'net. Unless you don't care about your data, then just google "oracle rman" and try stuff out.
Feb
25
comment How I optimize data dump in oracle 11g
You can't back up a database "little by little". (Well, you can, but you can't restore it to a consistent state when you do that => your backups are useless.) Unless you know exactly what you're doing and can handle the restore scenario. Without the right tools and knowledge, you're toast.
Feb
25
revised Character set for 11.2 version database in oracle for sql* loader
added 37 characters in body; edited tags
Feb
24
comment one or multiple tables mysql
You'll need to be much, much more precise in your description of your actual use case if you want reliable advice. As it is, your question is unanswerable.
Feb
24
comment How I optimize data dump in oracle 11g
Time to call a pro if you don't know how to do a backup. You can't just mess around with 20T of data and no tested, consistent backup strategy (and disaster recovery process).
Feb
24
comment How I optimize data dump in oracle 11g
Well do another backup. What's blocking you? (And if you have only a single backup of that thing... hope it's not important data.)
Feb
24
comment How I optimize data dump in oracle 11g
What do you want to do with that dump? Why can't you use your backups for that?
Feb
23
comment FACT table loading
How do you deal with the "Acct Num" data?
Feb
21
answered ASM File System type
Feb
13
comment SELECT from Function that return CURSOR
Interesting read here: community.oracle.com/thread/888365?tstart=0
Feb
10
revised Oracle StartUp Error
added 86 characters in body
Feb
8
comment Options for fastest guaranteed writes to a SQLite Shared cache in memory database
Why are you using sqlite for this? Queues seem like a better alternative.