| Thread | Last Post | Replies |
|
| manipulating blobs in sqlplus | 01 Sep 2007 00:08 GMT | 2 |
I am working for a software dev company doing a port to Oracle (from SQL Server). Currently, when deploying the initial software (or changes to the software) the database changes are made using sql scripts. DML handles changes to the data. This issue is that the
|
| _DISTRIBUTED_LOCK_TIMEOUT parameter | 01 Sep 2007 00:05 GMT | 1 |
Oracle version: 9.2.0.8 We are facing a problem with one of our jobs that runs on say database db_a and writes on db_b. Job, at times, aborts giving error "ORA-02049: timeout distributed
|
| > Oracle Development DBA - Irvine - CA - Interview in-person | 31 Aug 2007 22:55 GMT | 1 |
> Oracle Development DBA - Irvine - CA - Interview in-person > > We need an Oracle Database Administrator for 6 month contract > assignment in Irvine, CA. |
| Oracle NULL vs '' revisited | 31 Aug 2007 22:45 GMT | 165 |
Ok, I'm developing another oracle application where the distinction between NULL and '' will be important. Given Oracle doesn't adhere to SQL standards for the distinction, is there any best practices for comparing, and storing blank strings in a
|
| Problem with lost archive logs | 31 Aug 2007 19:34 GMT | 8 |
Not sure if this is the correct area to ask this question but it is a start. First of all I am new to Oracle so forgive me for how basic I will be. We are running 9i on a 2003 server. Hard drive space is limited, and
|
| fine-grained auditing | 31 Aug 2007 19:18 GMT | 3 |
I'm trying to add a new FGA policy, but I get message "DBMS_FGA must be declared". Is there a previous step before the creation of the policy? I'm using 10g on Windows XP.
|
| PL/SQL Developer from AllAround. Performing a SET? | 31 Aug 2007 19:10 GMT | 1 |
Dumb question, How could i do the the following in that tool? set define off I try from SQL, but i get invalid option. I'm trying to stop my procedure compile from interpreting & as prompt.
|
| ORA-04031: unable to allocate 2097152 bytes of shared memory ("shared pool","unknown object","hash-join subh","QERHJ Hash Table Entries") | 31 Aug 2007 19:09 GMT | 9 |
We getting the following error in our database: ORA-04031: unable to allocate 2097152 bytes of shared memory ("shared pool","unknown object","hash-join subh","QERHJ Hash Table Entries")" We have already tried the following:
|
| i want to print in single line pl/sql block | 31 Aug 2007 17:51 GMT | 4 |
how can i get output like this 1 = 1 1+2 = 3 1+2+3 = 6
|
| Converting Data types using SQL | 31 Aug 2007 17:51 GMT | 2 |
I have a table that has a column that is a data type of "LONG". The data in this column is actually text (it's descriptions). Don't know they history of why it was set up this way, but I cannot change it. So, I am trying to use SQL to pull this column along with other
|
| Suppressing output in export/import. | 31 Aug 2007 16:00 GMT | 6 |
Please suggest if there is any way to suppress output in export/import.
|
| Antique 1912-1949 Porcelain teapot 528 chinaware 400, invitation visit, | 31 Aug 2007 03:23 GMT | 1 |
Chinese antique, wonderful treasure big collection ,invitation visit Antique 1912-1949 Porcelain teapot 528 chinaware 400, invitation visit, Thanks !
|
| How to: Convert vertical table into horizontal table | 30 Aug 2007 21:26 GMT | 2 |
Hello friends, I have 2 tables. One store employee information attributes as columns of table in horizontal form. Other store same employee's more information in a vertical form, in a
|
| Today's Opinion Poll - 66 in MP | 30 Aug 2007 21:06 GMT | 1 |
NLHE MTT. Blinds 75/150. Full table. Your stack is 7000 - odd; a bit above average. UTG limps, folded to you, you limp along with 66. If you disagree with this, please say so. Folded to SB, SB folds, BB checks, so three to the flop. No
|
| 817 for linux.... | 30 Aug 2007 21:03 GMT | 2 |
All, Our company is charged with supporting various clients, some of which are still on 81x. We keep many versions in house on our Solaris environment, but we have outgrown it and a moving to RHEL4 on x86-64.
|