| Thread | Last Post | Replies |
|
| CBO for sys/system objects | 07 Apr 2006 13:49 GMT | 3 |
Oracle9i 9207 (64 bit) Solaris 9 (64 bit) We generate statistics for the user schemas via dbms_stats. Works fine although we had to tune a few queries with the RULE hint since it was
|
| Oracle 9i EE on Suse 10.0 | 07 Apr 2006 13:28 GMT | 2 |
I want to install Oracle 9i EE on Suse 10.0. Any experienced people about this? Cookbook maybe? Thanks in advance! Best regards!
|
| Problem With Merge Statement | 07 Apr 2006 13:06 GMT | 7 |
I have two table's as category Name exp_date exp_time Flg Tom 23-03-06 23:00:00 N
|
| Help needed with "ORA-01000: maximum open cursors exceeded" error | 07 Apr 2006 11:54 GMT | 7 |
I am adding data to a table using the SQL insert command via ODBC; after adding about 300 rows I am getting "ORA-01000: maximum open cursors exceeded" errors. I don't open any cursors explicitly. I have tired to issue a
|
| RMAN and tape backup | 07 Apr 2006 09:11 GMT | 1 |
I understand that RMAN can't backup to tape (ie it can backup to disk) without interfacing to a product like Legato or Veritas NetBackup. We run a development database on a Sun Fire V880 server and have Oracle 9i installed on Sun Solaris 9. The tape drive is DLT 7000. Since it is a
|
| Can't connect MS Access to 8i | 07 Apr 2006 05:05 GMT | 8 |
I'm not an Oracle expert but I do know a bit about ODBC. I'm trying to link to an Oracle 8i table. I built the DSN using the Microsoft Driver for Oracle. I have a valid user/pass/server... but I get some obscure TNS error that I looked up and told me nothing (I forget the number... ...
|
| Free ODBC driver for Oracle on AIX? | 07 Apr 2006 02:16 GMT | 3 |
Any free ODBC drivers for Oracle available on AIX? Thanks a lot!
|
| Replace System01.dbf | 07 Apr 2006 01:44 GMT | 34 |
Is there any way to replace a corrupt SYSTEM01.DBF? I have a 6 month old dump file and the table structures haven't changed at all. This DBF is not recoverable and there are no backups. I inherited this situation so lecturing me on the importance of backups isn't
|
| Group by/Order by Pivoting problem. | 06 Apr 2006 21:15 GMT | 5 |
I am "pivoting" multiple years of data by key. I want to ensure year1 is really the 1st row, so I want to order by Date but it can't be part of my group by clause. tableA
|
| INTERNET PART TIME JOBS | 06 Apr 2006 20:24 GMT | 1 |
INTERNET PART TIME JOBS Take a tour: http://website.ws/daisypool/show
|
| Can't connect to Oracle after domain join | 06 Apr 2006 19:44 GMT | 10 |
Hi to all; I have an Oracle 8 database running on a Windows Server 2003 computer which is a stand-alone server; the Oracle DB works perfectly. I'm in the process of building a domain and moving all servers and clients into it, but when I join that server to the domain, Oracle ...
|
| linux /proc/sys/vm/pagecache for oracle | 06 Apr 2006 18:56 GMT | 6 |
Does anyone know what this parameter has been replaced with on RedHat 4.0? I just noticed over 10G of my memory is used for file system caching. [root@mars ~]# more /proc/meminfo
|
| Is it possible in SQL or PL/SQL | 06 Apr 2006 16:43 GMT | 5 |
I am using Oracle 9.2 database. I am having following data drop table toto; create table toto (
|
| Breaking news: The ball-less DA Morgan to wed the breast-less J Burleson in a reinflating ceremony for both | 06 Apr 2006 16:17 GMT | 1 |
Breaking news: The ball-less DA Morgan to wed the breast-less J Burleson in a reinflating ceremony for both; check the details at oraclexg.com/news.html
|
| Oracle Internet Directory High Availability solutions | 06 Apr 2006 14:45 GMT | 4 |
We would like to know how others implement high availability solutions for OID. What are some of the high availability options for OID 10g? We selected the High Availability Oracle Multimaster replication option during installation but somehow we could not get the replication to
|