I have an access to remote database via db link.
How I can get the time what is on that server, is there any solution...
rgds
kari

I am using SQL Server 2000, and I am trying to rank based on three
columns (A, B, C) all contain numeric values. First off I am trying to
rank base on COLUMN A, if there are any ties (same numeric value) then
the values of COLUMN B is used as the tie breaker. Likewise if there is

First, I've talked to a few Oracle DBAs about this. None of them can
give hard and fast rules about when/how to gather statistics.
At the same time, I have a database which has been in production for
about 6 months, and the statistics have never been updated. While it's

I have a new install of Oracle 10g Database on a Solaris 8 system.
What does one need to do to run PHP applications on an Oracle 10g
database server (i.e. this is NOT OAS, HTMLDB or the like - just a DB
server install of 10g)?

Source: Oracle Relational Database (Rdb) Engine for  VAX/OpenVMS
platform (current version Rdb 7.0.31)
Target: Oracle 10g on Linux
Questions:

Hey there,
i using Oracle Database 10g and im new to these sequences and trigger-stuff.
Now i got an issue that you might be able to help me with.
i have created this sequence:

The database is 10.1.0.4 RAC on HP-UX Itanium.
I am having a hard time with this query.   The best I have done is
about 5 minutes with a 2GB db_cache_size (the box is running short on
memory if I add more to the cache),  and I have played with

Helo
I have a tablespace for indexes . When I count a free space the result is  
3,5 gb in all files (there is some files for this tablespace) but in alert  
log I have an information : ORA-1652: unable to extend temp segment by  

Hi newsgroup,
is there anything like the command "autoconfigure" in IBM Universal Database
V8.2 to configure database initialization parameters automatically in Oracle
10g? As I found out, AWR and ADDM could help to find out bottlenecks, but

Dear DBA,
You are cordially invited to test and review our windows native and
100% pure Java Oracle 10g Monitoring & Security Application (Xg).
Xg is  the Ultimate Visual Real Time Oracle Monitoring Tool. As the

GIS Business Application Programmer Job Description:
The position is located in Arlington, Virginia. This is a long term
contract (through 2013) with the U. S. Environmental Protection Agency.
APPLICANTS MUST BE US CITIZENS OR US PERMANENT RESIDENTS. NO SECURITY

Dumb question.  When I try to increase buffer cache of Oracle DB
10.1.0.3.1 on MS Window 2000, I get following error:
ORA-4033:  Insufficient memory to grow pool
Mealink Note 172563.1 says this happens when the system has

I have large_pool_size = 10485760 in my init.ora. But Large-Pool-size is
actually 0. I use Oracle 9i. Can you give me a hint?
Thanks in advance!
stupsnose

Hey all,
I'm an admitted newbie when it comes to the meat 'n' potatoes of SQL.
I can do simple one line  selects or updates.  but anything bigger than
that give me the willies.

who can tell me what is wrong with the follwoing code.
i am getting ora-06502 and ora-06512.
CREATE OR REPLACE procedure add_hw_partition is
P_MaxValue varchar2(30):= to_char(trunc(sysdate -1),'SYYYY-MM-DD