251 reputation
18
bio website floringhita.blogspot.com
location Bucharest, Romania
age 32
visits member for 2 years, 9 months
seen Jul 4 at 13:05

Sql and Oracle enthusiast.

My tags


Jul
5
comment Most efficient way to perform table operations (spec. drop) on tables having table names that match a certain criteria
AFAIK, there is no bulk drop. Your method is straight forward. And dropping is anyway fast, excluding the situation when there is a lock on the table.
May
21
awarded  Caucus
Apr
26
awarded  Critic
Apr
16
comment How to disable oracle's MAX_ENABLED_ROLES limit
on 11g I read "Range of values 0 to 148" :)
Jan
27
awarded  Yearling
Oct
26
comment Oracle error “too many values”, must be solved with nested SELECTs
You're welcome :)
Oct
26
answered Oracle error “too many values”, must be solved with nested SELECTs
Oct
26
comment Oracle error “too many values”, must be solved with nested SELECTs
what means single select? no Joins?
Oct
22
awarded  Citizen Patrol
Oct
22
answered How can I append a column to an inner SQL statement?
Oct
3
awarded  Commentator
Oct
1
comment Oracle server session terminated by fatal error
Do you use user sys or a normal user? Or a table in system schema?
Sep
21
awarded  Editor
Sep
21
comment Is it worth partitioning a Table by single value in Oracle?
I've updated my answer to respond to your update.
Sep
21
revised Is it worth partitioning a Table by single value in Oracle?
added 474 characters in body
Sep
5
answered Is it worth partitioning a Table by single value in Oracle?
Apr
4
comment Oracle 11gR2 expdp table converted to CSV from Linux
I'm not the poster. You are really sleepy :))
Apr
4
answered Oracle 11gR2 expdp table converted to CSV from Linux
Apr
4
comment Oracle 11gR2 expdp table converted to CSV from Linux
@Phil he want to write outside the database some tables. How can be useful an external table? Can you write it?
Mar
3
comment oracle - does this have the potential to cause a lock?
You can read an explanation about locks with examples I provided here