146 reputation
18
bio website
location
age 27
visits member for 1 year, 5 months
seen Apr 6 at 2:26

Feb
11
awarded  Notable Question
Feb
3
awarded  Popular Question
Aug
22
revised Why does Oracle SQL*Plus consider two queries executed together on the command line as a syntax error?
edited title
Aug
22
accepted Why does Oracle SQL*Plus consider two queries executed together on the command line as a syntax error?
Aug
22
comment Why does Oracle SQL*Plus consider two queries executed together on the command line as a syntax error?
Thanks for including the link to the documentation Phil! That clears it for me.. as when I run multiple queries in a Program window in PLSQL developer, it is intelligent enough to execute each one separately.
Aug
22
asked Why does Oracle SQL*Plus consider two queries executed together on the command line as a syntax error?
Jul
4
awarded  Popular Question
Jun
13
comment Is it recommended to run a Oracle schema backup when there are active sessions?
Hi @JackDouglas - multiple applications use the DB and the app I am working with uses just 2 of the schema's in the DB. So we go with a schema export. Thanks for the link, looking into RMAN
Jun
13
comment Is it recommended to run a Oracle schema backup when there are active sessions?
Hi @Mat - we finally decided to go with expdp as it copies empty tables as well, otherwise skipped by exp due to Oracle's Deferred Segment Creation. Other then that, I am not sure how expdp is better than exp for copying a schema in use by active sessions.
Jun
12
asked Is it recommended to run a Oracle schema backup when there are active sessions?
Jun
11
accepted Rebuild an index while it is being referenced in Oracle
Jun
11
comment Rebuild an index while it is being referenced in Oracle
Thank you Yasir!
Jun
11
revised Rebuild an index while it is being referenced in Oracle
added 13 characters in body
Jun
11
asked Rebuild an index while it is being referenced in Oracle
Apr
2
revised List partitioning or filtering a non-partitioned table, which incurs lower cost?
Made some corrections to the code, updated comments...
Apr
1
awarded  Commentator
Apr
1
comment List partitioning or filtering a non-partitioned table, which incurs lower cost?
Sure Phil.. Thanks again!
Apr
1
comment List partitioning or filtering a non-partitioned table, which incurs lower cost?
Hi @Phil, thanks. Row count can be in the millions but there are about 50 varchar2 columns-so that can be a lot of data.. Well I expect that INSERTs would slow down after the table was partitioned due to the additional overhead of managing the partitions. The problem here, is that I don't know of a way to measure the cost of inserts versus partitioning..
Apr
1
asked List partitioning or filtering a non-partitioned table, which incurs lower cost?
Feb
15
awarded  Critic