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

1d
answered DISTINCT not using an index
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
10
revised what is better in terms of allocated space in Oracle Tables: NUMBER or BINARY_FLOAT?
added 725 characters in body
Apr
10
answered what is better in terms of allocated space in Oracle Tables: NUMBER or BINARY_FLOAT?
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
answered Oracle becomes too slow after system crash
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
7
answered Revised Question: How do I prevent Oracle 12c Database from starting on machine boot
Apr
4
revised How to know DB size using backup file without restoring it
edited tags
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
revised HOW does ROWNUM work with this “optimization”
added 1095 characters in body
Apr
1
answered HOW does ROWNUM work with this “optimization”
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?