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

Jun
13
comment Can we create a table in specific datafile - Oracle 11g R2?
@TomTom - I did say "generally". There are certainly systems that deal with a lot of historical data where having storage tiers makes sense. Though those systems would still have a separate RAID array for each storage tier rather than using a single drive. It is still generally the case that it would be very difficult for most systems to figure out how to manually distribute objects to maximize performance in this sort of setup unless you're willing to spend ridiculous amounts of time monitoring and redistributing load.
Jun
13
answered Can we create a table in specific datafile - Oracle 11g R2?
Jun
13
awarded  Enlightened
Jun
13
awarded  Nice Answer
Jun
12
comment Best practices to encrypt all the data
Is the concern that the "Junior IT guys" will have access to the underlying data files and will try to parse data from them? Or is the concern that they will log in to the SQL Server database and run queries? If the issue is running queries, why do these untrusted users have database accounts to begin with? Can you simply not create accounts for them? Or not grant their accounts privileges to query tables with sensitive information?
Jun
4
answered Why is the padding on months in Oracle 9 characters?
May
30
awarded  Nice Answer
May
22
answered Oracle database and data has been corrupted. Is there a way to get it back?
May
21
comment Need an Oracle query to get the Oracle Home directory for a particular instance
When you say "Oracle query", are you talking about a SQL statement? Or are you talking about a script that runs at the operating system level? The latter would seem much more reasonable. Are you assuming that the DBA didn't follow any sort of logical process in setting up the server? Or can we assume that things were configured logically?
May
20
awarded  Constituent
May
15
answered How to load .dbf to run select queries?
May
13
awarded  Caucus
May
13
answered How to use database users as a foreign key field in any table
May
3
comment Timezones in Oracle 10
@VincentMalgrat - I updated my answer to show that the results are returned based on the session's time zone.
May
3
revised Timezones in Oracle 10
added 1098 characters in body
May
2
comment Timezones in Oracle 10
@DylanKlomparens - I updated my answer. You can't just do an AT TIME ZONE on a plain TIMESTAMP assuming you want the time component to change. Either you actually have a TIMESTAMP WITH TIME ZONE or something else is going on.
May
2
revised Timezones in Oracle 10
added 1517 characters in body
May
2
answered Timezones in Oracle 10
May
2
comment Timezones in Oracle 10
@DylanKlomparens - I guess the database could assume that any TIMESTAMP is in the database time zone. But it doesn't. If you specify TIMESTAMP rather than TIMESTAMP WITH [LOCAL] TIME ZONE, you specify that you don't care about the time zone. How much of this is dictated by the SQL 99 standard for those data types and how much is an Oracle implementation detail is not something that I know off the top of my head.
May
2
comment Timezones in Oracle 10
@DylanKlomparens - The automatic conversion of time zones is something that the TIMESTAMP WITH LOCAL TIME ZONE data type does. You're not even storing a time zone with your data so Oracle has no idea that it should assume that they are UTC.