12,097 reputation
11933
bio website ddbcinc.com
location Rochester Hills, MI
age 38
visits member for 3 years, 8 months
seen 42 mins ago
Oracle ACE

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?
Feb
1
comment “Table or view does not exist” on synonym
@infoholic_anonymous - You don't need to fully qualify the table name assuming that you are running the script as the table owner.
Feb
1
comment “Table or view does not exist” on synonym
@infoholic_anonymous - I would guess that either you didn't run that line or that you (or someone else) subsequently dropped and re-created the table without granting the appropriate privileges.
Feb
1
comment Create Table with Int-attribute which can only use values between 6 and 36
@Kingalione - Then you've something different than what I suggested. I updated my example to show that the constraint is working.
Feb
1
revised Create Table with Int-attribute which can only use values between 6 and 36
added 589 characters in body
Feb
1
answered “Table or view does not exist” on synonym