Oracle
in [SQL]
|
ADO request mistery Hello, I am running an application on a client machine (server 2003 sp2) that uses the oledb driver to execute ado command (driver ODAC1020221.exe). It connects to an oracle server 10.2.0.1.0 installed on a windows server 2003R2 SP2. The oracle has nls_language AMERICAN and nls_territory. The application is ... 25 Jun 2008 04:43
Role/Security Question Oracle 10.2.0.3.0 Windows Server 2003 In our database the security has been wide open (every table has been granted SELECT TO PUBLIC). Also, every schema has had privileges such as SELECT ANY TABLE granted to them. We're going to be having outside users start using the database and there are only certain... 20 Jun 2008 17:23
Query Question Hi, Is it possible to return all rows from a query on one line? I have this query: SELECT cnt || ':' || t_id FROM (SELECT COUNT(*) cnt, t_id FROM zc_body zb, zc_type zt WHERE zb.t_id = zt.id group by t_id); It returns data like this: 86:3 994:7 99:18 38:27 45:36 However, th... 20 Jun 2008 04:03
driving_site and local function call oracle 10G R2: I've got this query accessing a lot of remote data via database link. Therefore hint DRIVING_SITE is used to make the query happen on the remote server. Now I've done a change, I call a local package function, which makes the hint being ignored. The query looks something like this select /*+D... 25 Jun 2008 05:44
unregistering old dbid's from rman catalog Looking for assistance in unregistering old dbid's from the rman catalog. The db in question is a test db that is duplicated from a production db every so often and each time it gets duplicated, it creates a new dbid for the test db, effectively abandoning the old dbid and all it's associated backups. These bac... 20 Jun 2008 10:10
ORA-04091 with table insert Hi Group, Oracle 10G - This is my problem: There's a table containing a time series like date,val 1.1.08,2 2.1.08,1 3.1.08,4 5.1.08,-1 Now I need to advance this table in time, the new records come from a query so I have something like: insert into timeseriestable select date,val from timeseriesque... 23 Jun 2008 14:47
Connect Solaris ldapclient to a Oracle internet directory On 2008-06-18 15:28:01 +0100, denis <Denis.Nicklas(a)googlemail.com> said: As far as I know the native Solaris ldap client doesn't have this commands. I found only: ldapadd ldapaddent ldapclient ldapdelete ldaplist ldapmodify ldapmodrdn ldapsearch You should first test whether NSS is working ... 4 Aug 2008 07:26
Heteregenous connections client ==> oracle database ==> sqlserver I am using 9i client to connect a 9i database 9.2.0.5 enterprise / 9i listener I have setup an ODBC connection to a sqlserver database on this server I can run the following code on the server select * from mi_v_agents(a)rdt ...where rdt is a link whenever I try and run from my client it fails / ORA-12154... 20 Jun 2008 13:16
ORA-03135: connection lost contact OS Windows 2003 server Database Oracle Database 10g Standard edition version one Hi, I have installed oracle database on machine M1 and on second machine M2 installed oracle client. Created one service on M2 pointing to Oracle database on M1. Started SQL*Plus UI on machine M2. Executed some query on ... 23 Jun 2008 04:31
Sifobo Enterprise Manager for Oracle - Free Download Dear all, Sifobo Enterprise Manager for Oracle And SQL Server is an MMC based Oracle and SQL database backup manager for Windows and available for free download on http://www.sifobo.com Please feel free to download and use it or pass it onto anyone who might be interested..Remember it is FREE ;-) ... 19 Jun 2008 01:14 |