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

Apr
13
comment I'm unable to open a datafile in oracle, looking for a solution
Does the file exist o the file system? It appears that it used to exist and now does not. If that's the case, you're looking at doing a database recovery. Hopefully, the DBA left excellent documentation on how to do that in your environment.
Apr
11
comment Difference between oracle database desktop and server class
Can you describe the network topology a bit? Is your laptop, for example, getting its IP address via DHCP or does it have a static IP address? On the remote machine, are you using the IP address to connect to the Oracle database? Or is the remote client using a host name which is resolved by a DNS server?
Apr
10
comment what is better in terms of allocated space in Oracle Tables: NUMBER or BINARY_FLOAT?
Did you mean to add this answer to a different question? I'm not sure that I see the relationship to the question...
Apr
9
comment Importing bulk csv file to oracle database
Does that generate a control file and a command line? Can you post those? What is the database waiting on?
Apr
9
comment Importing bulk csv file to oracle database
What is your control file? What is your command line? Are you doing a direct path load? Are you loading data across the network? Is the file on the client machine or the server? Can it be moved to the server?
Apr
8
comment “Reformat” an Oracle instance
A schema is the collection of objects owned by a user. If you dropped the schema, you would have used the DROP USER command. If there are additional users that you want to drop, you'd need to drop them as well. Maybe you want to drop the entire database and create a new one but that seems excessive if you're really only trying to import a dump file.
Apr
8
comment “Reformat” an Oracle instance
I'm not sure that I understand what you are trying to "clean up". Is it not sufficient to drop whatever schemas you have that you no longer want? Perhaps you want to drop the existing database and create a new one from scratch?
Apr
7
comment Revised Question: How do I prevent Oracle 12c Database from starting on machine boot
@Eric - I'm not sure that I understand the question. OracleService<<SID>> is a service. If that service is set to run at startup (which it is by default), it will start the database when the machine starts up. If you change that service to start manually, the database won't start up automatically.
Apr
4
comment How to know DB size using backup file without restoring it
What database are you using (Oracle, SQL Server, MySQL, etc.)? What sort of backup do you have? For some types of backups the size of the backup is going to be roughly equivalent to the size of the restored database.
Apr
1
comment HOW does ROWNUM work with this “optimization”
Your most recent update does not appear to be deterministic. The ORDER BY is applied after the rownum is assigned in your inner query so there is no guarantee that the result will be the same across runs. It likely will be, assuming that the table remains constant, optimizer parameters are unchanged, etc. but it would be perfectly valid for Oracle to return the same value for every value of rowx that you pass in.
Apr
1
comment HOW does ROWNUM work with this “optimization”
@Sparksis - I've added to my answer to talk about the problem with the initial solution. Depending on what "sample data" means to you, you might be better off using the actual sample clause.
Apr
1
comment HOW does ROWNUM work with this “optimization”
A predicate rownum = rowx would only return rows if rowx was 1. If it was any other value, the query will return 0 rows. So the two queries are returning a different result in addition to having different performance, right?
Mar
28
comment Is there any disadvantage to using Oracle's Easy Connect syntax?
@jpmc26 - It depends. If you deploy a bunch of applications that use easy connect syntax and then decide that you want to add load balancing later on, that means that you've got to go touch a bunch of applications. Large organizations generally come up with a standard tnsnames file (or store TNS aliases in LDAP) that gets pushed to everyone when configuration changes are made. Supporting both can create support issues when, for example, some applications fail over automatically and some don't and someone needs to keep track of which are which.
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
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?