meta user
network profile
| bio | website | ddbcinc.com |
|---|---|---|
| location | Rochester Hills, MI | |
| age | 36 | |
| visits | member for | 2 years, 4 months |
| seen | 8 mins ago | |
| stats | profile views | 363 |
Oracle ACE
|
Feb 26 |
comment |
Does disabling index exists in a table? What database are you using? |
|
Feb 20 |
answered | Can Oracle Named User Licenses be reused? |
|
Feb 14 |
comment |
Should a table be partitioned before or after an INSERT? @JHFB - Updated my answer. |
|
Feb 14 |
revised |
Should a table be partitioned before or after an INSERT? added 575 characters in body |
|
Feb 14 |
comment |
Should a table be partitioned before or after an INSERT? @JHFB - You can ALTER an existing partitioned table to add new partitions, yes. You cannot ALTER an existing non-partitioned table to partition it. |
|
Feb 14 |
comment |
Should a table be partitioned before or after an INSERT? @Phil - Well, but in that case you're really not partitioning an existing table. You're creating a new partitioned table, moving all the data from the non-partitioned table over, dropping the non-partitioned table, and renaming the new one. DBMS_REDEFINITION is just a pretty wrapper to hide from other users the fact that you're doing all this. |
|
Feb 14 |
answered | Should a table be partitioned before or after an INSERT? |
|
Feb 14 |
revised |
Oracle insert max from two date added 116 characters in body; edited tags |
|
Feb 14 |
answered | Oracle insert max from two date |
|
Feb 12 |
answered | 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? Are you using an Oracle-to-Oracle database link? Or are you using Heterogeneous Services? If so, which gateway are you using? |
|
Feb 7 |
reviewed | Approve suggested edit on temporary table inside procedure oracle |
|
Feb 7 |
answered | temporary table inside procedure oracle |
|
Feb 4 |
answered | Tracking changes to a table via the update/insert cmds executed against it daily |
|
Feb 4 |
awarded | Custodian |
|
Feb 4 |
reviewed | Satisfactory Is there a way to speed up an ALTER statement in SQL Server |
|
Feb 4 |
reviewed | Needs Improvement Simplify and optimize a complex query |
|
Feb 4 |
reviewed | Satisfactory What would be the correct size of redo logs? |
|
Feb 4 |
comment |
Does a standby slow down Oracle imp? They should hardly influence each other assuming that the network between the servers has enough bandwidth to allow the archiver to copy the logs over the network faster than the primary can generate them at peak utilization. If the network between the servers doesn't have enough bandwidth and the import process generates a bunch of REDO, the primary could easily be stuck waiting on network transfers to the standby server. |
|
Jan 23 |
answered | How to list all users that have grants over a package |
