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

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?
Mar
28
revised Is there any disadvantage to using Oracle's Easy Connect syntax?
added 1279 characters in body
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
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.