11,887 reputation
11833
bio website ddbcinc.com
location Rochester Hills, MI
age 37
visits member for 3 years, 6 months
seen 2 hours ago
Oracle ACE

Mar
27
answered Is there any disadvantage to using Oracle's Easy Connect syntax?
Mar
22
comment Oracle strong ref cursor with dynamic sql
Are you certain that you need dynamic SQL to add the predicates? Are you sure you can't have a static query with predicates like where (parameter = 'A' and (something)) that would only evaluate the something predicate if parameter is A?
Mar
19
comment Stored Procedure with ROW instead of a list of parameters
@joe - Assuming that the caller also defines rec as table_name%rowtype, then yes.
Mar
19
answered Stored Procedure with ROW instead of a list of parameters
Mar
19
comment How to Upgrade from Oracle 10G to Oracle 11G without bringing down the database
How much downtime can you tolerate? How much effort are you willing to expend to achieve that goal? What edition of Oracle are you using? What is the architecture of your "resilient environment with shared storage"? Does that mean DataGuard? RAC? Something else? It's possible to do a zero downtime upgrade but that generally requires considerably more effort to configure, practice, test, etc. than a simpler upgrade.
Mar
11
comment How to export oracle 11g database partially
Do you want a random sampling from each table? Or do you need a referentially correct 1% sample? So, if you choose a particular child row from among the 1% of rows from the child table, must the parent row be chosen from the parent table as well? If you choose the parent do you need to choose all the child rows (and grandchild rows)? Or are you fine missing some of the child rows (i.e. you pull order 123 and some number of order lines for 123 but not all of them)? Depending on the answers, this is probably not something export and import are designed for.
Mar
10
comment Oracle dead with unknown reason
Is there a reason that you haven't applied any patchsets to your database? You're running the very first 11.2 release. Do you have a support contract? ORA-00600 and ORA-00745 errors are internal Oracle errors. Normally, you'd use the Metalink search tools to see whether the ORA-00600 and ORA-00745 error lookup tools find anything useful or whether you need to log a support request.
Mar
6
comment Oracle case insensitive passwords seemingly ignoring SEC_CASE_SENSITIVE_LOGON
Are you logged in to the database server when you do this? Are you sure that you're not using operating system authentication (in which case the password will be completely ignored)? If you enter a totally incorrect password, do you still log in successfully?
Feb
26
comment Slowness after migration to RAC 11gr2
Are the query plans for the problem statements the same in your 10.2 database and your 11.2 database? Did you do anything as part of the upgrade to ensure plan stability?
Feb
25
comment How to compare a result of a query to a number?
@BrunoLM - Edited my answer
Feb
25
revised How to compare a result of a query to a number?
added 569 characters in body
Feb
25
answered How to compare a result of a query to a number?
Feb
25
comment Using CURSOR in Oracle 11g database to locate all matches for specifed string in DB
@Mikhail - The answer I gave on StackOverflow should work. It'll be slow as dirt. But it will work.
Feb
24
answered Using CURSOR in Oracle 11g database to locate all matches for specifed string in DB
Feb
24
comment Using CURSOR in Oracle 11g database to locate all matches for specifed string in DB
Are you looking for cases where a string exists in a column name? In a table name? Or in some row somewhere in the table?
Feb
23
comment Oracle data obfuscation on specific columns with set field sizes
What is the business problem you are trying to solve? Are you trying to obfuscate data in the test environment? Or prevent certain users from seing unobfuscated data in prod? Or preventing system admins or folks that get their hands on backup tapes from being able to see sensitive data? What version of Oracle?
Feb
22
comment Implement a deduplication trigger in Oracle
@user60216 - If the third party vendor can call stored procedures rather than issuing INSERT statements, yes, you could use stored procedures.
Feb
22
answered Implement a deduplication trigger in Oracle
Feb
22
revised Implement a deduplication trigger in Oracle
added 32 characters in body
Feb
6
answered Oracle: How can I add ROWDEPENDENCIES to an existing table?