| Thread | Last Post | Replies |
|
| Returning Recordsets fro Stored Procedure | 27 May 2005 03:00 GMT | 3 |
I am new to Oracle although I have done SQL Server for a number of years. I feel silly for asking such a basic question, but I have looked through anumber of books and cannot find a straighforward example opf what I need to do.
|
| oracle database 10.1.0.4 patch set for Linux x86_64 | 26 May 2005 23:20 GMT | 2 |
Do you know when the 10.1.0.4 patch set for Oracle Database for Linux x86_64 (AMD64/EM64T) will be out? The patch set is already out for almost all other platforms. Thanks.
|
| How to make Standby DB to be consistent with Primary db again? | 26 May 2005 23:09 GMT | 4 |
Platform:Linux AS3,Oracle9i(9204),Standby Arch Mode. The Standby DB was not consistent with Primary. And some of the necessary archivelogs are missing on Primary db. How to make Standby DB to be consistent with Primary one again in
|
| Redo size vs. archived logs size | 26 May 2005 23:00 GMT | 8 |
during weekend I have been doing stress testing of an archived logs destination on one of our systems here. I have done this by writing a PL/SQL package that basically inserts as many rows as specified, updated them one by one and deletes them. It also measures time elapsed
|
| Another newbie question about UPDATE | 26 May 2005 20:58 GMT | 4 |
Another question from this stupid danish oracle-newbie :-) I have 2 tables, STOCKTABLE and STOCKTABLE_EXT I want to update 2 fields in STOCKTABLE, with the values of 2 fields in STOCKTABLE_EXT.
|
| Oracle 10g & tablespaces | 26 May 2005 20:54 GMT | 10 |
We are planning the migration of some Oracle 8i databases to Oracle 10g (both on AIX 5.2). For most databases, we currently have only 2 DM tablespaces for user data : one for table data and one for indexes. Maximum table size is around 10GB,
|
| How to create an index ? | 26 May 2005 20:50 GMT | 1 |
I have this structure to implement i18n, but I don't know how to build an index on my test table to fasten search on value column of this i18n string. I'm using ORA10g.
|
| Oracle Error Messages | 26 May 2005 19:35 GMT | 8 |
I have a question. Is there a cool web site that documents Oracle error messages with details showing you the top 5 reasons why such an error normally occurs along with the actions one could take to resolve the error?
|
| Oracle Client breaks c# interop? | 26 May 2005 18:13 GMT | 1 |
I've a problem with an application that recently started to produce strange behaviour with interop. I'm automating Word and Adobe Illustrator through C# and it has worked fine for a long time. However, since some time it only works when running SQL Server as the database.
|
| truncate table | 26 May 2005 18:02 GMT | 6 |
I have a problem - Can anyone help? I have a requirement to lock a table (to deny all write access to it), update records in another table, and then to truncate the "locked" table before allowing access to it.
|
| Help: How should i partition this table | 26 May 2005 17:35 GMT | 8 |
I am using oracle 92. I have a table which has two date column, begining_time, and ending_time. The query usually is where
|
| java.sql.SQLException: Exhausted Resultset | 26 May 2005 16:58 GMT | 3 |
Hello Gents I have a application that work from 3 years and now on a prticular action show this error : java.sql.SQLException: Exhausted Resultset
|
| Group by year, display years as columns? | 26 May 2005 16:58 GMT | 2 |
All, Is there are a way do something like? select trunc(by_date, 'yyyy'), count(*) from my_table
|
| ORA-07445: exception encountered: core dump | 26 May 2005 16:35 GMT | 2 |
I have a string of these errors in the oracle logs. I am running Oracle 9.2 on Solaris 8. A google search doesn't reveal any thing. Any help is appreciated. thanks
|
| ORA-01427 single-row subquery returns more than one row | 26 May 2005 13:31 GMT | 2 |
This is my statement : update relpersoonhierarchiek rel set rel.soortfunctie = (select fun.cat
|