Reputation
15,403
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
1 28 42
Newest
 Nice Answer
Impact
~1.0m people reached

Nov
25
comment If a table is partitioned by a single column should that column be included in index definitions?
Are you creating local indexes? Or global indexes? I assume you've left off the part of the create table statement that specifies the partitioning clause.
Nov
25
comment Can't login ORA-28031: maximum of 148 enabled roles exceeded
This works if you happen to have a script that creates roles, that doesn't clean up after itself, and where you don't need the roles any longer. In the general case, though, you'd want to revoke the role from the user (or make the role non-default). That lets you keep the role (which is generally still useful).
Nov
24
awarded  Guru
Nov
22
answered Could Not Be Accessed Value Of The For Loop Counter In PL/SQL
Nov
18
comment Extract data from Oracle DBF files
It would make much, much more sense to get a logical backup (export either DataPump or classic) that you could load into whatever version of Oracle you want. I'm guessing that 170 dbf files implies a pretty large database so you probably can't use the express edition but depending on what you are trying to accomplish you may be able to get a relatively cheap personal edition license to cover your conversion efforts.
Nov
18
comment Extract data from Oracle DBF files
You would need to have exactly the same version of Oracle running on the same operating system to restore the backup in order to extract information (excluding spending crazy money on emergency data extract tools). You say in comments that you have Oracle 9.2.0.6. You're not going to be able to get that without having a support contract with Oracle, requesting media, doing an install, installing patchsets, etc. And 9.2.0.6 is so old that you'll probably need an ancient version of Windows to support it.
Nov
18
answered Oracle db - get rid of doubled rows
Nov
18
comment Oracle db - get rid of doubled rows
OK. And since the data is coming from a view, I assume that you don't really want to modify the data, you just want a query that replaces values with 0's.
Nov
18
comment Oracle db - get rid of doubled rows
How do you know which row to zero out and which row to retain non-zero values for? Do you just want to pick arbitrarily?
Nov
18
comment Oracle db - get rid of doubled rows
How do you know which row to zero out and which row to retain non-zero values for? Do you just want to pick arbitrarily? What happens if the v1, v2, and v3 values are different for two rows with the same yr and op? Why do you want to have multiple rows in the table in the first place rather than making (yr, op) the key?
Nov
18
comment Choosing Between SQL Server 2008 R2 and SQL Server 2012 - Which to learn about first?
What are you trying to accomplish? If you know nothing about databases, the differences between two versions of a database engine are going to be relatively tiny. If you're trying to get a certification, you'd want to use the version that matches the certification you want.
Nov
10
comment Does extending datafiles affect performance
How does your SAN do load balancing? I would expect that the SAN would be moving blocks around to balance the I/O load regardless of how you allocate files. But that's something to talk through with your SAN administrators.
Nov
10
comment Does extending datafiles affect performance
How is your storage subsystem (SAN? NAS? directly attached?) do load balancing. There generally isn't a direct correlation between a file and a set of spindles-- the SAN would generally be moving hot blocks around to balance performance.
Nov
7
comment Delete “Previous” row, if a value in a column in both rows are the same
You should be able to delete your own question. Removing all the text but leaving the question around isn't appropriate. Most likely, the last edit will be reverted. If you don't believe the question is appropriate, please delete it.
Nov
6
answered How to log the values that cause a unique constraint violation
Nov
3
comment SQL for Inserting the system date and a fixed time (not the system time) in a column
@LoneWolf91 - It sounds like you just want to replace the to_date expressions with the expression I posted (you'd obviously need to adjust the interval to produce a different time). If that is not actually what you want, I'm afraid that you'll probably need to clarify your question.
Nov
3
revised SQL for Inserting the system date and a fixed time (not the system time) in a column
deleted 6 characters in body
Nov
3
answered SQL for Inserting the system date and a fixed time (not the system time) in a column
Oct
29
comment How to validate data before loading it to DB
Is there a reason that you need to do the validation before loading? Normally, you'd stage your load. So you'd load data into a staging area in the database however it exists in the file then a separate step would cleanse the data.
Oct
8
comment Upgrade scenario: Oracle 8.0.5.0.0 to Oracle 12c?
I'm not sure that even ODBC would work. I'm hard-pressed to think of a version of the Oracle client that could be installed on an operating system that can run 12.1 that would be able to connect to an 8.0.5 database.