Oracle

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

Validating Flashback Database
Oracle 10.2.0.3 EE on RHEL 4 I am considering using the following method for application upgrades in the future: (N.B. Flashback Logging is Disabled) 1. Shutdown DB 2. Create Guaranteed Restore Point 3. Upgrade application 4. Test application 5. Drop Restore point I am proposing to use the above method ... 25 Jun 2008 02:41

Any Oracle 11g for Solaris x86?
In article <g2tco0$go4$1(a)net44p.hkbu.edu.hk>, Mr. Chow Wing Siu <Johnson.Chow(a)Comp.HKBU.Edu.HK> wrote: I visit Oracle homepage. It doesn't include Oracle 11g for Solaris x86. Would there be available later? 32-bit Oracle for Solaris x86 is EOL at 10gR2. 64-bit Oracle 11g for Solaris x64 is promised. My WAG... 1 Jul 2008 21:35

Administration Assistant for Windows Startup/Shutdown Options
test_1t(a)hotmail.com wrote: On Jun 14, 3:09 am, Frank van Bortel <frank.van.bor...(a)gmail.com> wrote: test...(a)hotmail.com wrote: I run 10.2.0.1.0 and use Administration Assistant for Windows. It worked fine Then the error was: Snap-in failed to initialize Name:<unknown> CLSID:{50D0... 19 Jun 2008 01:14

SELECT Question
Hi, Quick question here, if I have a WHERE clause with an IN condition - WHERE var IN (1, 2, 3)...... What if the list is dynamic? How would you do that? The column in the table is numeric. Do I have to 'build' the select statement? Thanks! John ... 19 Jun 2008 01:14