meta user
network profile
| bio | website | ddbcinc.com |
|---|---|---|
| location | Rochester Hills, MI | |
| age | 36 | |
| visits | member for | 2 years, 4 months |
| seen | 1 hour ago | |
| stats | profile views | 364 |
Oracle ACE
|
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 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 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 |
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. |
|
May 2 |
comment |
Timezones in Oracle 10 What data type are you using to store the data? TIMESTAMP? TIMESTAMP WITH TIME ZONE? Or TIMESTAMP WITH LOCAL TIME ZONE? |
|
Apr 23 |
comment |
What is a partitioned view? @SuhailGupta - The documentation I linked to walks through a complete example. That is probably easier to follow than any summary I could come up with. |
|
Apr 8 |
comment |
Execution of a java program by a trigger What database are we talking about? Is the Java program running inside the database (i.e. a Java stored procedure in Oracle)? Or are you trying to execute an external application? Does that application reside on the database server or on a different machine? |
|
Mar 20 |
comment |
import .dmp file created in OS W2K to Win 2003 Exactly what version of the export utility was used to generate the export file? "Oracle 8" could refer to anything from 8.0.3 to 8.1.7. Exactly what version of the import utility will be used? Since no version of "Oracle 8" was certified on Windows 2003, should we assume that you are able to successfully install Oracle 8 on Windows 2003 and that everything works in that unsupported and untested configuration? |
|
Mar 13 |
comment |
Cannot login to Oracle11g with System username Are you talking about shutting down Oracle via Enterprise Manager (the web-based GUI)? Or via a command-line? Enterprise Manager will request operating system credentials (on Windows, a Windows username & password that is in the ORA_DBA group) in order to start and stop certain services. A command-line tool will not (since, after all, you're using your operating system privileges inherently in that environment). |
|
Mar 12 |
comment |
how to create and insert into a table in an anonymous block @JHFB - You may want to take a look at the thread I just added a link to before writing that new question. |
|
Mar 12 |
comment |
Blocking incoming database links @Phil - Maybe I'm missing something. I believe the problem is to prevent database links from a database that you don't control. I don't see how that can be restricted via privileges. Of course, you can certainly prevent people from creating database links in your database that point to other databases. But that doesn't sound like the problem here. |
|
Mar 11 |
comment |
Blocking incoming database links @bonsvr - Added a link to another DBA thread with an example of a logon trigger that attempts to deny access. |
|
Mar 5 |
comment |
ORA-00990 error while trying to grant priviliges: Why is that? @SuhailGupta - OK. So you created a user but then didn't log in as that user. You're still logged in as whatever user you used initially to create the suhail user. Based on the output of your query, I'm assuming that you logged in as SYS initially and are still logged in as SYS. |
|
Mar 5 |
comment |
ORA-00990 error while trying to grant priviliges: Why is that? @SuhailGupta - Did you log in as suhail? Did you grant suhail the SYSDBA role? |
|
Mar 5 |
comment |
ORA-00990 error while trying to grant priviliges: Why is that? @SuhailGupta - If you own the table, you automatically have access to the data. If you do not own the table, the owner of the table would need to grant you INSERT privileges on the table in order to insert data and SELECT privileges on the table in order to select the data. |
|
Feb 26 |
comment |
Does disabling index exists in a table? What database are you using? |
|
Feb 14 |
comment |
Should a table be partitioned before or after an INSERT? @JHFB - Updated my answer. |
|
Feb 14 |
comment |
Should a table be partitioned before or after an INSERT? @JHFB - You can ALTER an existing partitioned table to add new partitions, yes. You cannot ALTER an existing non-partitioned table to partition it. |
|
Feb 14 |
comment |
Should a table be partitioned before or after an INSERT? @Phil - Well, but in that case you're really not partitioning an existing table. You're creating a new partitioned table, moving all the data from the non-partitioned table over, dropping the non-partitioned table, and renaming the new one. DBMS_REDEFINITION is just a pretty wrapper to hide from other users the fact that you're doing all this. |
