146 reputation
28
bio website
location
age 28
visits member for 2 years
seen Sep 23 at 21:48

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
Feb
15
accepted How do I debug an ETL process that is unable to commit any records?
Feb
12
comment How do I debug an ETL process that is unable to commit any records?
@Justin, It's Oracle to Oracle.
Feb
12
revised How do I debug an ETL process that is unable to commit any records?
added 265 characters in body
Feb
12
asked How do I debug an ETL process that is unable to commit any records?
Jan
3
revised Why do I get an incorrect error “ORA-01775: looping chain of synonyms”, when the base table does not existing?
edited title
Jan
3
comment Why do I get an incorrect error “ORA-01775: looping chain of synonyms”, when the base table does not existing?
Thanks @Phil.. That now makes sense..