Reputation
14,729
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 27 40
Newest
 Yearling
Impact
~925k people reached

Dec
4
comment How to identify how many instances of Oracle are installed on Linux environment
And that didn't work for some reason? As I said, if you're assuming that someone in the past did installs in a non-standard method, didn't document anything, and the instance isn't running any longer, then they've done an excellent job of hiding it. You can search for things that look like parameter files and spfiles or data files but that likely requires human intervention to determine if they are "real". That's true regardless of OS.
Dec
4
comment How to identify how many instances of Oracle are installed on Linux environment
There is no guaranteed method. That's something that should be documented. You can look for indicators like entries in /etc/oratab but that is no guarantee if someone has really fouled up a server. Just as in Windows, it is possible to not have a service though that wouldn't generally be sensible.
Nov
25
comment If a table is partitioned by a single column should that column be included in index definitions?
OK. So you're creating local indexes. Is school_year reasonably selective within a partition? Or will all rows in the partition have the same value? If you are doing a range partition by month, for example, and your values are distributed throughout the month, that's different than if all rows in the partition will have the same school_year value.
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