Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Oracle / Oracle Server / August 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
manipulating blobs in sqlplus01 Sep 2007 00:08 GMT2
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 parameter01 Sep 2007 00:05 GMT1
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-person31 Aug 2007 22:55 GMT1
> 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 '' revisited31 Aug 2007 22:45 GMT165
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 logs31 Aug 2007 19:34 GMT8
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 auditing31 Aug 2007 19:18 GMT3
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 GMT1
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 GMT9
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 block31 Aug 2007 17:51 GMT4
how can i get output like this
1 = 1
1+2 =  3
1+2+3 = 6
Converting Data types using SQL31 Aug 2007 17:51 GMT2
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 GMT6
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 GMT1
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 table30 Aug 2007 21:26 GMT2
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 MP30 Aug 2007 21:06 GMT1
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 GMT2
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.
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 July, 2007
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.